Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Subscript Reference
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00506781
Message ID:
00506838
Vues:
15
>This error is usually associated with trying to access an element of an array that doesn't exist. However in your select I would specify the table or cursor each field is selected from...
>
>
>SELECT table.projectid,table.name,table.typeid,etc...
>

If the field names are unique, this is not needed. However, Name is a reserved Foxpro word, which potentially can cause some problems...

>
>>The following SELECT statement causes an "Invalid Subscript Reference" error when run over a Citrix server:
>>
>>
>>SELECT projectid,name,typeid,biddue,tonnage,status,division,projects.salesreid,;
>>lastactivity FROM projects,curDivId,curSalesId WHERE projects.division =;
>>curDivId.DivisionId AND projects.salesrepid = curSalesId.salesrepid INTO;
>>CURSOR curProj
>>
>>When I run this on my local machine or even over the local network it runs fine.
>>What am I doing wrong? Is there a better way to write this SELECT statement?
>>
>>Thanks in advance for your help,
>>Russell Clendenon
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform