Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error on insert
Message
From
25/10/2007 17:37:15
 
 
To
25/10/2007 14:26:08
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01263375
Message ID:
01263850
Views:
14
>>That's a good question. The command is
>>
>>insert into tiplog (tip_id,employee,changedate,changetable,changefield,oldvalue,newvalue) values ;
>>(lnTIP_ID,employee,time(),tcAlias,lcFieldName,alltrim(transform(oldval(lcFieldName))),alltrim(transform(evaluate(lcFieldName))))
>>
>>tiplog is a plain vanilla dbf living in the dbc. There are no triggers in it or other relations, or relational integrity. So how could there be another table involved? Does multilocks on mandate buffering be enabled?
>
>I think it's the other way around, can't have table buffering (only record) with multilocks off. Also checked that oldval() doesn't error out when buffering is off - and it doesn't.
>
>If this is the audit log table... is then maybe the table which is audited to blame for the error?

You are correct, this is the audit log. The table being audited has buffering set to 3, as do all of the buffered tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform