I am selecting information from multiple tables into a cursor 'cur'.

I need to bind these fields to textfields. My problem occurs when I try to
move the cursor.
When i use skip or go I dont know what table alias to use.

'cur' doesnt work.

Bobber

RE: Cursor across multiple tables by Leemi

Leemi
Tue Jun 28 15:50:40 CDT 2005

Hi Bobber:

What error do you get?
Try placing a SET command in your code or type it into the Command window
to invoke the Data Session window. You can then see all the open tables.
This might tell you what the cursor is called.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>I am selecting information from multiple tables into a cursor 'cur'.

>I need to bind these fields to textfields. My problem occurs when I try
to
>move the cursor.
>When i use skip or go I dont know what table alias to use.

>'cur' doesnt work.

>Bobber


Re: Cursor across multiple tables by Lightning

Lightning
Wed Jun 29 10:45:11 CDT 2005

I'm new to VFP and I just made a rookie mistake, your comment helped
me find it.

Thanks Lee


On Tue, 28 Jun 2005 20:50:40 GMT, Leemi@online.microsoft.com (Lee
Mitchell) wrote:

>Hi Bobber:
>
>What error do you get?
>Try placing a SET command in your code or type it into the Command window
>to invoke the Data Session window. You can then see all the open tables.
>This might tell you what the cursor is called.
>
>I hope this helps.
>
>This posting is provided "AS IS" with no warranties, and confers no rights.
>
>Sincerely,
>Microsoft FoxPro Technical Support
>Lee Mitchell
>
>*-- VFP9 HAS ARRIVED!! --*
>Read about all the new features of VFP9 here:
>http://msdn.microsoft.com/vfoxpro/
>
>*--Purchase VFP 9.0 here:
>http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
>69-4500-8bf2-3f06689f4ab3&type=ovr
>
>Keep an eye on the product lifecycle for Visual FoxPro here:
>http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>I am selecting information from multiple tables into a cursor 'cur'.
>
>>I need to bind these fields to textfields. My problem occurs when I try
>to
>>move the cursor.
>>When i use skip or go I dont know what table alias to use.
>
>>'cur' doesnt work.
>
>>Bobber