Alias not currently opened . . .

[Rick4077]

I give up.

Error is "Alias is not currently opened. Table Working:ScmlsNormalize.db
Alias Working Table ::ScmlsNormalize.db"

method pushButton(var eventInfo Event)
var;----------------Declare Variables-------------
Scmls, ScmlsNormalize		table
qbe								query
endVar;-------------End Variable List-------------
;-------------------------------------------------
addAlias("Standard","D:\\Pdoxwin\\Working")
;-------------------------------------------------

qbe=Query

:Working:ScmlsNormalize.db | UID | NormalizedOfficeName |
                           | _ID      | _Name |

:Working:Scmls.db  | ListID | ListName |
                   | _ID    | changeto _Name  |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif

qbe=Query

:Working:ScmlsNormalize.db | UID | NormalizedOfficeName |
                           | _ID | _Name |

:Working:Scmls.db  		   | SellID | SellName |
								   | _ID    | changeto _Name |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif

endMethod

 

[Rick4077]

Okay . . . I fixed it by removing

:Working:

BUT WHY did this cause a problem?

The paths and all were still correct.

Rick

 

[Bystander]

Rick,

The second attempt may have worked because ScmlsNormalize.db and Scmls.db are in your Paradox default Working directory and therefore can be referenced without an alias.

As to the initial code failing. I presume that the directory D:\Pdoxwin\Working exists and is where the tables for the query are located. This being the case then the only problem I think is in the syntax used for addAlias. I believe it should be

addAlias("Working","Standard","D:\\Pdoxwin\\Working")rather than the addAlias("Standard","D:\\Pdoxwin\\Working") which you posted above as this does not actually give a name for the alias.

I hope that this helps.

Regards

Bystander