True DB Grid

Apologies if this has been answered a bunch of times:

Im trying to use a grid on a form that will allow users to change data around, use combo boxes, etc.. the true db grid will do that. my problem is, the way that the program is written so far.. when using flexgrids, the data is pasted to the grid on a cell by cell basis:

for i = 0 to .rowcount - 1
.row = i
.col = 0
.text = <some_variable_from_a_recordset>
'and so on for more .col's
next i

flexgrid isnt this cut and dry. now i have to choose a data retrieval method and so on. is there any way with true db to create a recordset in code and employ a similar method as above? im not even sure what datasource im supposed to use. (unbound, unbound ext, app, storage)

any help is appreciated - thanks

Hi there,

Try Application as your data mode.

Finally - I tried the Application mode, and got a couple more errors, but the errors all led me to believe that it had to be the Bound set.

I set it to Bound, and said
grid.datasource = <recordsetname>

thanks so much!