>>Hi,
>>
>>SQL can not do this, because SQL does not depend on the order records are stored.
>>In general even for dbx the order of records should mean nothing. This simply bad design
>
>True, but here I guess in this case it just is the line order of a txt/PS document fed into a vfp table, so the recnos achieved could be seem as a stream quality/representation ;-)
But then there we have better commands to do it directly on the string / file. I had this idea too, but he asks for table. :)
Anyway, I go with Rich's version. Better then mine. :)
>Via SQL the corresponding begin/end records can be found and ranges "in between" be deleted via single xBase or SQL command.
>Could be faster - either via begin/end plus recno() put into 2 arrays or into a cursor to build a single delete command...
How do you adress a range between records with SQL? RECNO() is not reliable. There are things that work with VFP, I agree, but I would never use this. The next code monkey tries to do gather the VFP code and use it on some SQL server ...
Basically it's against anything SQL was made for.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]