I am totally confused about what is going on here. (3.0.1 on Sybase).
I have a form with a related tab form. I have a method on the tab form called newRecord, which correctly picks up the PK from the master record and stores it in the child on screen. I can then complete all the other fields but…when I navigate to the next master record I get a sybase error telling me didnt complete all the fields.
Checking with sybase - I have received an error indicating I tried to insert NULL into every field for the child record so it has been rejected. So there is no child record (in Sybase).
but
if I navigate back to the master record in servoy the child record is still there(!) until I go into design mode and then back into data entry and then it is gone; so it was never really in the database…
so what the heck is happening…?
why doesnt the child record write into the synase db given that all the required fields have been completed?
why does servoy think that the record is still there?
is there some transaction issue I have missed?
Help