Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recall and Select Sql
Message
From
18/07/2003 13:13:09
 
 
To
18/07/2003 13:05:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811558
Message ID:
00811559
Views:
13
>>I need make one select in a secondary table .
>This select results , for example
>
>NumDoc
>28
>41
>62
>75
>87
>94
>
>Now i need make recall in Table LinhaFac for this 5 records
>
>I want put one condition in command Recall that work with result previous select .
>
>Any ideia ?


If NumDoc a key field in LinhaFac?
You could Scan..Endscan in the NumDoc results and seek (or relate to) LinhaFac to recall each record (set deleted would have to be off).


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform