Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error on insert
Message
From
25/10/2007 12:13:41
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
25/10/2007 12:04:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01263375
Message ID:
01263665
Views:
11
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform