Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Edits to EditBox in child grid won't stick
Message
From
01/04/1998 12:05:33
Stephen Bridgett
Stephen Bridgett Consulting
Gloucester, Ontario, Canada
 
 
To
31/03/1998 09:06:36
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00088156
Message ID:
00088724
Views:
61
>>>>>>>>I have a one-to-many form with a grid representing the many side of the relationship. When I attempt (at run-time) to change the values in the EditBox controls on any line in the grid, everything works fine until I tab to the next column, when the value I've entered disppears from the grid and is never posted to the table.
>>>>>>>>All read-only attributes for table, grid and EditBox are set to .F.
>>>>>>>>
>>>>>>>>Any ideas?
>>>>>>>
>>>>>>>What is Grid.Recordsource?
>>>>>>
>>>>>>Thanks for your reply!
>>>>>>
>>>>>>RecordSource is an alias for the many-side table. I add new rows using APPEND BLANK and valuing the foreign-key field after selecting that alias.
>>>>>
>>>>>Usually, this situation assumes using of parameterized view as Grid.Recordsource
>>>>>When edit session is finished you can just issue Tableupdate() to get data back to table.
>>>>
>>>>Thanks for the tip, but I don't think it applies since I'm not using buffering.
>>>
>>>It's applied because you will use view.
>>
>>Check for code in the AfterRowColChange. As I was saying earlier in the day I am fighting the same problem. I found that code in the after row col change event was the culprit. I don't have a clear answer WHY but removing it fixed the problem.
>
>Why should i check it? My AfterRowColChange(s) work Ok.

Because:
"Thanks for your help. After further investigation of my code, I found the problem. Somehow I had placed an UNLOCK() in the BeforeRowColumnChange event and an RLOCK() in the AfterColumnChange event. Since the application is a single-user one, removing this code did the trick."
:-)
Stephen Bridgett
Hand Crafted Relational Database Solutions
Focusing on Visual Foxpro and Object Oriented Design
SBridgett@cyberus.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform