Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd Alias Not Found Error
Message
From
04/03/2003 13:45:55
 
 
To
04/03/2003 13:21:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00760836
Message ID:
00761073
Views:
30
Code is VERY lengthy, but here are the pieces involving the problem.

LPARAMETERS tcDatabase,tcTable
*-- Note:
*-- tcDatabase = "AS-400DispensingData"
*-- tcTable = "Non_Formulary_Data" as passed in

*-- several LOCAL variable declarations

lcTable=LOWER(IIF(EMPTY(tcTable),ALIAS(),ALLTRIM(tcTable)))

lcDBF=lcTable
lcAlias=LOWER(SYS(2015))
IF !EMPTY(tcDatabase) AND FILE(tcDatabase)
OPEN DATABASE (tcDatabase)
ENDIF FILE(tcDatabase)
IF FILE(lcDBF)
SELECT 0
USE (lcDBF) ALIAS (lcAlias) AGAIN SHARED
ENDIF

Error is "Alias Non_Formulary_Data not found"; however, I had already opened and closed it earlier in the same routine.
GOOOOOOOO BUCS !!!!!!!!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform