aargh (even more confused with servoy/sql)

Classic Servoy
1

I have lots of sql experience but very little servoy exp. Using V3.0.1 against sybase.
I have a form that has a tab panel on it. The form in the tab panel triggers an error when trying to insert data into the SQL table:

run some Sql debugging and can see that sybase is complaining that sessionid cannot be NULL - which is true as it is the PK on the table! BUT sessionid has a numeric value in my form - I can see it!
Further logging of the record.exception.getSQL string shows:

Sat Nov 18 2006 16:32:31 GMT+1100 (EST) SQL: insert into people_sessions ( peopleid, episodesid, joinsession, leavesession, participationtypeid) values ( ? , ? , ? , ? , ? )

see how sessionid is NOT in the insert string. No wonder sybase is upset:)
Why is sessionid NOT included in the SQL insert written back to the DB if I can see a value in it in the servoy form (yes I have checked that it is linked to the correct dataprovider).

Note: I dont know whether the ? values in the .getSQL exception string indicates a problem or whether it just can display the data properly?

???
Al.

2

How did you create the db’s? with Servoy or Sybase Central?
what system are you using voor sequencing? servoy? or db-autoincrement?

3

all my own fault…when I was doing some db maintenance yesterday I must have mistakenly checked the ‘db auto-increment’ for the sessionid column…which of course tells servoy not to bother updating it…which causes the db to refuse the insert command as it doesnt contain a value for sessionid…

so all my fault…took me 3 hours to work out what I had done :(

4

yes, :) I have been there! ;-)

5

all my own fault…when I was doing some db maintenance yesterday I must have mistakenly checked the ‘db auto-increment’ for the sessionid column…which of course tells servoy not to bother updating it…which causes the db to refuse the insert command as it doesnt contain a value for sessionid…

so all my fault…took me 3 hours to work out what I had done :(