General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only