August 5th, 2013, 02:16 PM
Thanks jggtz
I made it
strSQL = strSQL & "WHERE " & ODBC1_FIELD_NAME & " = ' "& strKeyValue & "'"
August 5th, 2013, 01:35 PM
Also I'm going to look up creating a stored procedure and see if that looks better.
August 5th, 2013, 01:34 PM
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....
August 5th, 2013, 11:29 AM
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 &...
August 2nd, 2013, 03:16 PM
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...