Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Trouble
Message
From
30/12/1999 12:37:05
 
 
To
30/12/1999 12:28:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00310435
Message ID:
00310509
Views:
17
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform