Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alias Fails . . ?

Status
Not open for further replies.

Rick4077

Technical User
Oct 19, 2004
149
0
0
US
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

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
 
Okay . . . silly me . . . I figured it out!

Rick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top