Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alias not found
Message
De
24/04/2000 15:49:33
 
 
À
21/04/2000 16:11:10
Tyson Bonn
Myers and Stauffer Consulting
Harrisburg, Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00362019
Message ID:
00362892
Vues:
15
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
Fil
Voir

Click here to load this message in the networking platform