All of a sudden this script reports this error;
"This Alias is not currently opened."
Both of the referrenced tables are in the D:\Pdoxwin\Mrmls Folder.
Any ideas please?
Thanks much! Rick
"This Alias is not currently opened."
Both of the referrenced tables are in the D:\Pdoxwin\Mrmls Folder.
Any ideas please?
Thanks much! Rick
Code:
method pushButton(var eventInfo Event)
var;----------------Declare Variables-------------
Mrmls table
MrmlsNormalized table
qbe query
endVar;-------------End Variable List-------------
addAlias("MyDir","Standard","D:\\Pdoxwin\\Mrmls")
;----------------------------------------------------------------
qbe=Query
:Mrmls:MrmlsNormalized.db | OfficeID | NormalizedOfficeName |
| _ID | _Name |
:Mrmls:Mrmls.db | ListId | ListName |
| _ID | changeto _Name |
endquery
if not qbe.executeQbe()then
errorShow()
return
endif
qbe=Query
:Mrmls:MrmlsNormalized.db | OfficeID | NormalizedOfficeName |
| _ID | _Name |
:Mrmls:Mrmls.db | SellID | SellName |
| _ID | changeto _Name |
endquery
if not qbe.executeQbe()then
errorShow()
return
endif
endMethod