Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error on insert
Message
De
25/10/2007 12:23:45
 
 
À
25/10/2007 11:59:24
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:
01263670
Vues:
14
>>>A command like
>>>insert into tipdatabase!tiplog (tip_id) values (1.00)
>>>seems to work whether the table is open or not. However under some conditions the insert command produces an error that says either row or table buffering must be enabled. What is the condition that might be causing this?
>>>
>>>Thanks
>>
>>Don
>>
>>Do you actually need to put in the dbc name? I mean, you don't, and I wasn't aware that it would work with it, but is it necessary here. What happens if you do just:
>>
insert into tiplog (tip_id) values (1.00)
?
>>
>>Maybe because you do include the dbc this is causing some dbc-based side-effect.
>
>The command is in a stored procedure. The reference to the dbc was included to allow it to work even if the table was not open. I tested your premise by removing the reference to the dbc and substituting code to force it to open and close appropriately. The result is the same. I get an error that says buffering needs to be enabled.

You might need to make sure SET MULTILOCKS ON is in effect. Also, you can force all tables to be opened with buffering via:
CURSORSETPROP("Buffering",5,0)
Requires SET MULTILOCKS ON.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform