General information
Category:
Coding, syntax & commands
>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. :)
;-))
>>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.
Being workable only in .dbf: True of course - safest would be to use the xBase command on the table, not the SQL. Code monkey safety net ;-)
xBase quite fitting to this way of string/stream reading. Solution by Rich shortest in code and most of the work done in C-engine.
I added SQL as that was asked for in the OP and technically it is working as well in .dbf.
Feeding the text stream into a real DB with a record counter could work as well - and that would reflect the "position" aspect of the stream, so in part "tuning" SQL set usage to "stream" use case ;-))
Previous
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