Printable View
Hi i need help with this problem look im trying to find a specific record using ADO and sql ("Select name where code=" & txtcode") when i use the aplication on my machine its work fine, but when i install it in another machine it doesn't find records that they really exist in the database, for example its find record that i create on my machine but records that i create in the other machines it doesn't find it. i really dont know what its happening with this
You may want to try changing your statement to something like:
strSQL = "SELECT * FROM mytable WHERE code = " & chr(34) & txtcode.text & chr(34)
That method above always seems to work for me.
Also, what version of ADO are you using? You may have to install MDAC on your other "test" computer. It's amazing the errors you do NOT get on the developmental computer and get on test computers.
Good luck :-)
Eric
Thanks for your help, but as i know u use chr(34) when the key that you are looking for in the database is a character key, but in this case is an integer, if its so i think im using the select statemente in a good way, the other things its, i have not Instal MDAC, i thougth that the setup was in charge of all of this, i really dont know what MDAC its, can u explain what its means
Sorry... I didn't know you were looking for an integer. You are right, obviously you do not use the chr(34) then.
An MDAC setup file *may* be be bundled in a subdirectory with your setup program after you use the Setup & Deployment wizard. I am not 100% sure though.
MDAC is a part of the Windows data access services. If you are using Windows 95/98 and using ADO 2.5, I think you need to download the latest MDAC program. And I'm sure there are other examples about OS versions & ADO versions that require the 2.5 or higher MDAC.
You can get MDAC here: http://www.microsoft.com/data/
Eric