Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setup a relationship between 2Cursors
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00387476
Message ID:
00387585
Vues:
15
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform