Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement