[RBASE-L] - RE: Last (x) rows

[Kenny Camp]

I sometimes limit a cursor loop by using ...where count > 100000 and limit = 150000.   This starts with row 100001 and stops at row 150000.   Kenny Camp IT Manager Electro Enterprises Oklahoma City, OK ----- Original Message ----- From: Walker, Buddy To: RBASE-L Mailing List Sent: Monday, August 02, 2004 1:09 PM Subject: [RBASE-L] - RE: Last (x) rows Rob    That is exactly what I would do      DEL ROWS from table WHERE COUNT > XXXXX      should work for you as long as you know how many rows were in the table before your load.   Buddy     -----Original Message----- From: Rob Vincent [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 2:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Last (x) rows What would be the correct query command for returning the Last (x) number of rows entered/(loaded) into an Rbase table?   I have just discovered a need to delete imported rows, where I know the number of records that were loaded.   Perhaps using the WHERE COUNT > {last_valid_record} would work?   Thanks, Rob