Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report Trouble
Message
De
30/12/1999 12:37:05
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
30/12/1999 12:28:36
Jimmy Ditta
Twin City Electronics
Monroe, Louisiane, É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:
00310435
Message ID:
00310509
Vues:
16
Jimmy-

[sorry about my dangling HTML tag, btw < s>]

>It is problematic, but I don't know how else to do it yet. I've only been programming for a couple of weeks now. It's telling me that "variable 'Total12' is not found".
>
>here's my code:
>SELECT data1.bundle as Total12;
>FROM lumber!data1 into cursor bundata;
>WHERE siz = szValue and grade = gdValue and length = 2;
...snip
>tb2 = bundata.Total12 + bundata.Total22 + bundata.Total32 + bundata.Total42 + bundata.Total52 + bundata.Total62 + bundata.Total72 + bundata.Total82
First, you can drop the semi-colons at the end of the command. Not needed and a potentional trap if you every accidentally add a line of code after w/o inserting a blank line.

Second, you need to SELECT INTO a different cursor...you overwrite each one with the next select. You want to end up with one cursor per SELECT statement.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform