i have already posted similar question but i did not get any answer. I have spent whole week trying to find a solution, obviously, not successfuly :-)
I am trying to use ADO Data and DataGrid ActiveX controls and I have following problem:
when I insert controls (on a dialog), set all properties (among them, DataSource property of the DataGrid control reffers to ADO Data identifier) to and try to test a connection with database (through the underlying database provider) in Resources window i get what i want. But when i compile the project the ADO Data control is enabled and DataGrid control is not populated with data. I can get some basic properties (Title, etc) but if i want to set DataSource during run-time i get an error (the code of the error is unknown to Error Lookup tool).
i used following code
-to get idispatch interfaces:
-to get recordset
-and then to set DataSource prperty
one of the first tries was using rs:
rs=IAdodc_GetRecordset(ado,ret) - this fails!!!
one among others million tries was (using ADO 2.6 Type library - Connection, Recordset objects):
call $Connection_SetConnectionString(conn,'DSN=GOVNO',ret) !;-)
rs=$Connection_Execute(conn,"SELECT MyTable.* FROM MyTable;",$STATUS=ret)
call IDataGrid_SetDataSource(dgrid,ds,ret) !fails again
Does anyone know what should be second parameter for
call IDataGrid_SetDataSource ?
Has anyoune used DataGrid co