Okay...my other problem which i haven't resolved:
I have some DTC listbox in a form which represent data with a specific record.
When I use rs.addRecord to create a new record and then INSERT it into the db table via rs.updateRecord, all the data for each DTC is put into the insert except for the data within the listboxes--they are somehow excluded.
But, if I call updateRecord a second time (two times in a row, after explicitly setting the record's data with whats in the current selection of the listbox), the data is then put into the record in the database.
The problem is, the workaround of calling updateRecord twice won't solve the problem if the data represented by the listbox is for a field that doesn't allow NULLs into the table. So the first updateRecord will FAIL on the INSERT call because nothing is being passed to the SQL command for these fields.
So, the question is, why doesn't the field data for the record get set by whats selected by the DTC listbox imbetween the call to addRecord and updateRecord. I want to be able to have non-NULL fields in my table.
Thanks in advance,
Lehel
I have some DTC listbox in a form which represent data with a specific record.
When I use rs.addRecord to create a new record and then INSERT it into the db table via rs.updateRecord, all the data for each DTC is put into the insert except for the data within the listboxes--they are somehow excluded.
But, if I call updateRecord a second time (two times in a row, after explicitly setting the record's data with whats in the current selection of the listbox), the data is then put into the record in the database.
The problem is, the workaround of calling updateRecord twice won't solve the problem if the data represented by the listbox is for a field that doesn't allow NULLs into the table. So the first updateRecord will FAIL on the INSERT call because nothing is being passed to the SQL command for these fields.
So, the question is, why doesn't the field data for the record get set by whats selected by the DTC listbox imbetween the call to addRecord and updateRecord. I want to be able to have non-NULL fields in my table.
Thanks in advance,
Lehel