Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicates in a table
Message
From
10/09/2003 11:44:39
 
 
To
10/09/2003 10:59:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00827861
Message ID:
00827887
Views:
12
Hi Steven,

- i suppose it is a queue.
- i suppose you want process with FIFO rule

pseudocode
SELECT queue
SET ORDER TO FIFOORDER
SCAN
 <save> fieldExp <into> duplexExp
 STORE RECNO() TO iRec
 LOCATE FOR fieldExp< equal to >duplexExp
 IF RECNO()#m.iRec
     DELETE RECORD m.iRec
 ELSE
     GO m.iRec
 ENDIF
ENDSCAN
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform