Question for ADO control(VB6)

來源: 於 2004-01-15 16:32:00 [舊帖] [給我悄悄話] 本文已被閱讀：次

I have a ADO control on a form. It's connected to a Access table. Now ADO control's Recordsource, we can type a table name or a SQL statement. If I type a sql statement like

Select *from table where ID = myValue

But it doesn't work, I tried many different ways to put "my Value" or "& myvalue &", nothing worked. Can anyone help? myValue is dynamic and from input.

Thanks.



--文學城www.wenxuecity.com--