True DB Checkbox Question

[RSeliga]

Heres the scenario - any help is appreciated.

i have a recordset that is to a True DB (oledb) grid. One of the rows in the grid is a checkbox. The checkbox needs to be checked for all the records to start. So, i made my select statement something like:

select ..., -1 as letter from... where... etc

and then i bound the letter column on the grid (the checkbox) to the letter column in the recordset.

everything runs smoothly except that when i uncheck the checkbox and move to another record (via downarrow or mouse).. it checks itself again - like i never touched it.

ive also found that if i change the select statement so that part reads ..'1' as letter.. the screen will pull up, all the checkboxes will be checked and i can uncheck them. the problem here happens when i try to check them again. i get a 'data type mismatch' error

thanks for any assistance

[JMuller]

I think you should add a Yes/No column to the table which is the recordset's source. If you select a '-1' as a column, you are selecting a constant value, and it causes the error in the DBGrid.

[RSeliga]

That would work, but im in an Oracle environment. The letter field that the checkbox is for isn't really something thats going to be written back to a table... there will be other columns with information in the grid that will be written back, but the checkbox is just for printing letters.

[RSeliga]

Figured it out

what i did was:

set <recordsetname> = select field1, field2, null as letter ..<regularstuff>...

then once its created, loop through it and set the data = -1

with rstemp
for i = 1 to .recordcount
!letter = -1
.movenext
next i
end with

works like a charm - thanks again!