dwhawley
Jun 25th, 2000, 08:08 PM
i'm using the ded to query three tables and combine them into one. however, before a record is written to this new table, i want to be able to check the new table to see if that data has already been written. to do this, i have to be able to pass variables to the ded. with access, i've always just written something like the following:
sqlStatement = "SELECT * FROM tblTable WHERE field1 = '"
sqlStatement = sqlStatement & strVariable & "'"
rsTable.Open sqlStatement, Currentproject.Connection
is there something similar that i can do in vb6? in all honesty, whenever i approached this problem before in vb6, i just found a way of avoiding it. there is probably a way i could avoid this too, but i really want to know how to use the ded effectively. any suggestions?
sqlStatement = "SELECT * FROM tblTable WHERE field1 = '"
sqlStatement = sqlStatement & strVariable & "'"
rsTable.Open sqlStatement, Currentproject.Connection
is there something similar that i can do in vb6? in all honesty, whenever i approached this problem before in vb6, i just found a way of avoiding it. there is probably a way i could avoid this too, but i really want to know how to use the ded effectively. any suggestions?