General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only