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--