Passing a variable to a query

[EdLentz]

I have a MS Access 2000 front end (just creating) and I want to delete a record from my MySql db backend. I get a network connection failure when I try to use the usual method. I have a ODBC link established. So I would like to pass a ID number for the record to the Query to delete it from the backend. Any examples would be appreciated.

Thanks
Ed

 

[QatQat]

Run a pass-through query in MS Access and execute a


delete from tablename where ID = x



Bye


Qatqat

Life is what happens when you are making other plans.

 

[rudof]

You would have to concactinate the variable into your query.

E.g.

String VARIABLE = "00001"

"delete from TABLENAME where ID = \""+VARIABLE+"\""
so the above query would in actual fact yield

"delete from TABLENAME where ID = "00001"

The plus(+) sign is the concactination character.