Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias not found
Message
From
24/04/2000 15:49:33
 
 
To
21/04/2000 16:11:10
Tyson Bonn
Myers and Stauffer Consulting
Harrisburg, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00362019
Message ID:
00362892
Views:
16
I do have a cursor called curruser that is set in my login screen. But rebuild shouldn't have to worry about that. Here is the code for my rebuild. It uses the data dictionary but for some reason I get the error that alias curruser can't be found. If I run it without logging in, it works perfect.

* Determine which files to Rebuild
if empty(FileList)
select distinct dbf_name, d_template;
from datadict ;
where alltrim(field_name) != "TABLENAME" and alltrim(field_name) != "LASTID";
order by dbf_name ;
into cursor dbf_list
else
select distinct dbf_name, d_template;
from datadict ;
where alltrim(dbf_name) $ m.FileList ;
and alltrim(field_name) != "TABLENAME" and alltrim(field_name) != "LASTID";
order by dbf_name ;
into cursor dbf_list
endif

* Begin Processing
select dbf_list * If I put a browse here I get the alias error
scan

* Get table, template, and CDX names
alias = strtran(alltrim(dbf_list.dbf_name),".DBF","")
template = alltrim(dbf_list.d_template)
currdbf = alias+".DBF"
currcdx = alias+".CDX"



It shouldn't even look for curruser, I wouldn't think.

Need some help with this,

Thanks,
Tyler
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform