again select

[remcoploeg]

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
ploegr@promar-agencies.nl

[Andrew_Fryer]

what do you mean 'normal data'?

[remcoploeg]

before I used adodc but now data. I don't now the other name

Remco Ploeg
ploegr@promar-agencies.nl

[Sephozzy]

I would like to help but I also don't know what you mean by 'normal data'. Are you trying to tell that you're not using the ado-data control anymore? If so, please explain what you are trying to use.

If anything in this post makes sense it was written by me, if not I don't know who wrote it