I am using VFP 7 and I'm new to a lot of this, so please be gentle.
I am trying to pull an undecided amount of records out of a single table. These records are decided on by the contents of a textbox. The problem comes in when I try to add a variable to the COPY TO line. I also have no clue how to make an array fit a varying amount of records.
*** search by gstnum, pull up all related files, sort selected files by date and use the most recent.
m.gstnum = x
LOCAL ARRAY REDRUM[3,3]
COPY TO ARRAY REDRUM FOR gstnum = x
APPEND FROM ARRAY REDRUM
SET ORDER TO 1 && ARRIVAL
rsvnum = m.rsvnum
arrival = m.arrival
any insight into this would be grealy appreciated.
select * from table1 ;
where table1.gstnum = m.gstnum ;
order by arrival descending ;
into cursor REDRUM
works like a charm, thank you very much.
( Topic last updated: 2008.02.20 10:31:37 AM )