I had problems to save with adodc to a mysql database. Now I solved that problem with the normal data. But now my question. I had this with adodc to select:
Dim sSQL As String
Dim tSQL As String
Dim uSQL As String

tSQL = "Select * from vis_tb_rep WHERE Company_ID = " & Vis_id
Adodc2.CommandType = adCmdText
Adodc2.RecordSource = tSQL
Adodc2.Recordset.Refresh
uSQL = "Select * from bas_tb_object WHERE company_id OR relatie_id = " & Vis_id
Adodc3.CommandType = adCmdText
Adodc3.RecordSource = uSQL
Adodc3.Recordset.Refresh
sSQL = "Select * from klantenbestand WHERE CompanyID = " & Vis_id
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = sSQL
Adodc1.Recordset.Refresh

How can I reach that in normal data??

thanks

Remco Ploeg
[email protected]