Search:

Thanks jggtz

I made it

strSQL = strSQL & "WHERE " & ODBC1_FIELD_NAME & " = ' "& strKeyValue & "'"

Also I'm going to look up creating a stored procedure and see if that looks better.

I wish I could try it now, but the db is at another customers location and while there I don't have accses to anything other than WinSQL to trouble shoot.

Thanks for the heads up on the spaces....

Thanks DataMiser

So would you think this should work?
I'm concerned about the FROM and WHERE.


strSQL = "SELECT TOP 1"
strSQL = strSQL & "ShipHead.PackNum,"
strSQL = strSQL &...

Hey I was wondering if someone here can help me. I have a very long sql statement but I'm running into errors when trying to run as part of my script. My normal sql statements are like

' Set SQL...