Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1545:Table buffer for Alias contains uncommitted c
Message
From
30/05/2002 11:00:23
Angela Haws
Seminole County Tax Collector
Debary, Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00662535
Message ID:
00663021
Views:
19
Hi Sebastian!
>>>>Excluding the key field from the updatable fields may cause the problem of impossibility of creating new records - who and how fills the candidate key field if you creating new records?

Well, in the free table, I have customer number (custnum) as candidate key. Since it is a free table, not contained within a .dbc, the index builder will not let me build a "primary", only a "regular" or "candidate". With a new record, Customer number is filled in by opening a control file, locking record, replacing "custnum" with this value, incrementing the control file value by one, then unlocking the record. It should always be unique because of this.

> I have added REPLACE commands to replace the View.fieldnames with thisform.txtboxs.values.
<

>>>>There is no need to do so, because the controls are bound directly to the view fields!

Yeah, I tried different things and that seemed to do the trick, but I know that it doesnt have to be done. It was the only thing that kept me from getting this 1545 error. But I want it done right, not just working.

>>
and the table that I'm using for the view is has table buffering set to 1.
<<

>>>>How did you do this? DO you deal with row buffering or table buffering?

I did this by cursorsetprop() -- I deal with table buffering only.

Thanks and Have a great day!
Angie



Previous
Next
Reply
Map
View

Click here to load this message in the networking platform