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