Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setup a relationship between 2Cursors
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00387476
Message ID:
00387585
Views:
16
Kelly,
This may be a typo, but when you set a relation you use the field name:

Set relation to ticket into itemdata

Barbara

>I'm trying to setup a relationsship between 2 cursors. What I want to do is when I'm scrolling through 1 grid I want the other one to update its records occording to which record im currently on in grid 1. Here is my code
>SELECT Tickets.ticket, Tickets.loandate, Tickets.loanamt,;
> Tickets.paiddate, Tickets.paidamt, tickets.ptype, tickets.trnstype;
> FROM tickets;
> WHERE Tickets.custnr = "SD00357";
> into cursor ticketdata
>index on tickets.ticket tag tick
>
>SELECT item.ticket, Item.item;
> FROM item INNER JOIN ticketdata ;
> ON Item.ticket = Ticketdata.ticket;
> into cursor itemdata
>index on item.ticket tag tick
>
>select ticketdata
>set relation to tick into itemdata
>
>I get an error tha says "varibal ticket not found" in my set relation to tick into intemdata code.
>
>Thanks
>Kelly
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform