Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor / Select calling procedures
Message
 
To
27/06/2000 15:37:07
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00385345
Message ID:
00385349
Views:
10
Hi Bonnie,

>Help...I have a cursor and when I do a select from that cursor calling a procedure, the first record in the cursor is processed twice.
>
>Example:
>
>Select job,part from mytable where job="1234" into cursor temp
>Select getpart(part),job from temp into cursor temp2
>Procedure getpart
>Parameters joba parta
>Wait window parta
>Endproc
>
>If the cursor temp has 62 records, the procedure getpart is processed 63 times. Why?

VFP has to determine what datatype the result of GetPart() is. So in setting up the result set, it makes an initial call to make the determination.
Bill Armbrecht
VFP MCP
Previous
Reply
Map
View

Click here to load this message in the networking platform