Information générale
Catégorie:
Codage, syntaxe et commandes
>>How to use the fontionality of Visual Foxpro to
>>add records
>>in a table without using SCATTER/APPEND
>>BLANK/GATHER?
>>I WANT TO change the property control source to
>>nothing AND USE INSERT SQL instead IS IT THE BEST
>>WAY.
>
>if buffering is on u can just append blank
>if u'd issue a TABLEREVERT the new record won't be
>in the
>file (as it only existed in the buffer)
>no scatter and gather needed becasu u work with
>the "actual data" (the changes u make though are
>stored in the buffer)
>if u have tablebuffering on - u can see the
>changed records
>(before a TABLEUPDATE/TABLEREVERT), they have
>negative record numbers
>
>make sure the RI code lets u have blank record if
>u use this approach
>
>HTH
>
>Arnon Gal-Oz
Thank you Arnon Gal-Oz, it is the second time you help me, I appreciate.
Did you look on the on line Help on the section performance hint?? It is write that INSERT SQL is faster than a append blank.
If I interstand, you mean that with buffering on, append blank,
does not add the record in the table immediatly, just when you
write TableUpdate and you can revert the change in the buffer with TableRevert().
How did you check that before a tableupdate/tablerevert they have negative record number?
Could you explain me, wath you mean by "RI code"
I hope I will be able to speak to you again(excuse my bad english!!!)
Précédent
Suivant
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