Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error on insert
Message
From
25/10/2007 13:16:44
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
25/10/2007 12:18:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01263375
Message ID:
01263707
Views:
12
>>>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)?
>
>The code in question is contained in a stored procedure which is called via update trigger. And yes, the trigger is firing when it shouldn't. I'm trying to track that down too. However, that doesn't explain to me why the error.

Are we sure that we know which table is this about? It may be trying to do something with some other table, which may need buffering.

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