General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setup a relationship between 2Cursors
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only