Information générale
Catégorie:
Codage, syntaxe et commandes
>Shoud I replace the use of : SEEK,REPLACE,DELETE and use SELECT * FROm where, Update WHERE, and DELETE FOR
Like John said, SQL should give you knoweldge to work off of if you ever need to go right to a SQL database. As far as the immediate benifits?
Well, REPLACE is faster than UPDATE when you're dealing with multiple records. The reason is REPLACE locks the whole table, UPDATE locks and unlocks each record. So while UPDATE might be slower, it could be safer.
SELECT can do a whole lot more for you than Seek(), but when you're using SELECT to do the same thing as a seek() (find a single record in 1 table), I find little advantage to either, execept maybe to put the result in an array or something.
As for DELETE, teh xBase version according to the Hacker's Guide respects already deleted files, so should be faster in that case.
Finally, xBase commands allow you to use specfic scopes (NEXT 5, REST, ect) and the WHILE clause, SQL doesn't, so those might be reasons to using xBase.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement