Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error on insert
Message
De
25/10/2007 12:13:41
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
25/10/2007 12:04:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01263375
Message ID:
01263665
Vues:
12
>>SQL-insert command is capable of inserting records into a table which wasn't opened - it can open it. You only need to supply a name it can use to open it - a sufficient path, or dbc!table syntax for an already open DBC. In the simple cases (filename equal to alias and visible on set("path")) it just works without need to explain. The need is there for weirder cases :).
>>
>>If table was already opened without buffering, now that may cause the error above. Or if it wasn't opened and VFP opens it without buffering by default (which would then defeat the purpose of the smart opening).
>
>Not sure what you mean by "smart opening".

What I said about Insert command opening the table where the filename may be implied in several ways.

>There are other tables open with buffering set to 3. Since this is an insert and not an edit I assumed buffering is not needed for this table. Plus we want the code to work whether the table is previously opened or not. Hence the syntax that includes the dbc.

Which is all fine, it's the error message that really shouldn't happen. Is there a tableupdate() implied somewhere (via trigger maybe)?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform