4gl problems
Posted in 1995
I have used Dave Snyders db4glgen v3.21 for the main table and 3 subtables. Even with modifications his code lends a consistency that makes it easy to make modifications once you understand the code. I think it's great! So I have added a 'Tables' selection to the main table's menu that when accessed opens up another window with menu selections for the 3 subtables. Each of the 3 subtables calls separate db4glgen modules for adding, updating deleting the appropriate row determined by the common one column key. This all works 100% of the time for adds. Updates of the subtables some times has a problem. The change is made to the column and the operator hits Escape, the change is negated (the original data comes back) and the error message shows at the bottom of the window: UPDATE table (%s) is not the same as the cursor table. I thought I had this fixed once when I 'free(d)' the cursurs in all the subtables modules. If the operator exits the program and comes back in it works fine (the update of the subtable). I have no idea where to look now. Any suggestions? Thanks ~