Help with MSFLEXGRID

[nievesj]

Hello.

Somewhere here I saw that this could work

recs.Open "SELECT * FROM tblClient", DBCon, adOpenDynamic, adLockOptimistic
fgMySQLData.DataSource = recs

But it gives me a Type mismatch error, why?


Thanks in advance

[Dalceon]

which particular line give you the error??

[nievesj]

This one.

fgMySQLData.DataSource = recs

[Dalceon]

1. the datasource has to be a data control not a recordset.
2. you have to use the set statement.
3. It looks like you're trying to assign an ado recordset.
I believe the flexgrid only use DAO.

I may be wrong on # 3

you'll need to do something like this.

dim rs as recordset
 
'open the recordset here
 
set YourDataControl.recordset = rs

[brucevde]

Its the hierarchical flexgrid (MSHFLEXGRID) that supports ado recordsets as a datasource.

[nievesj]

Nice, if i edit come data on a MSHFlexGrid, will it update the database?