Re: ODBC / SQL ERROR SQL0010

[MWalter@xxxxxxxxxxxxxxx]

I've always coded the double quotes as the delimiter. Probably because I
use VB. Are VHINVN and VHCLID alpha?


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \




                    "Hatzenbeler, Tim"
                    <thatzenbeler@clini        To:     
"'midrange-l@midrange.com'" <midrange-l@midrange.com>
                    tech.net>                  cc:
                    Sent by:                   Subject:     ODBC / SQL ERROR 
SQL0010
                    midrange-l-admin@mi
                    drange.com


                    12/27/2002 02:47 PM
                    Please respond to
                    midrange-l






This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
This is from the ODBC trace... Any idea, what would cause this error?  If I
copy and paste this command into the SQL script function it works...

thanks, tim

                     HSTMT               00C02988
                     UCHAR *             0x00E70BB0 [      97] "UPDATE
EXDBFA.EXPPLVH SET VHVEXP = 4624 WHERE VHINVN = '187538810001' AND VHCLID =
'187538810001'"
                     SDWORD                    97

                     DIAG [37000] [IBM][Client Access Express ODBC Driver
(32-bit)][DB2/400 SQL]SQL0010 - String constant beginning '18753881' not
delimited. (-10)

This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.