Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding records to a view based grid
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00222265
Message ID:
00222314
Views:
21
>Hi all!
>
>I have a grid based on a parameterized view. I want to set the AllowAddNew property set to .T. and add records to the view. The view uses two keyfields to be unique, one is Keyfield, the other is subkey. The parameter for the view is based on ?lcKeyfield. These keys are filled programmably.
>
>If a new record is added to the view keyfields are empty. If I try to fill the keyfields in a save method I get an update conflict.
>
>How can I programmably fill the key fields in the view for new records added on the grid before my tableupdate() without getting an update conflict? I suspect this probably would be done best in the rules expression on the keyfields in the table. Is that right?
>
>TIA!
>
>Rob

There are the three things I would like you to look at first.

1. When do you generate the KEY fields? As soon as you add the record or when user saves the record?

2. What is WHERE Type in view definition? Key Fields only,Key and Modiified Fields or the rest one?

3. Which buffering mode have you applied? TABLE or ROW?

Bye
Jayesh
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform