HP3000-L Archives

January 2008, Week 1

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: ODBC (MB Foster) INSERT and Numeric types
From:
Ray Shahan <[log in to unmask]>
Reply To:
Ray Shahan <[log in to unmask]>
Date:
Wed, 2 Jan 2008 13:17:37 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (89 lines) 
Kent,  

	Your error text, "Unrecognized SQL command", indicates that the
syntax of the SQL command is incorrect.  Do you need to end the SQL
statement with a semi-colon?

RETURN_D (serv#,STATUS,AMTCHCL,YMDTRANS) VALUES('07347F4640270100','02P
',10400,'20080102');

 


Raymond Shahan
Information Systems
 REPUBLIC TITLE OF TEXAS, INC.
  2701 W Plano Parkway 
Plano, TX 75075
 

direct 214.556.0202
main 972.578.8611
fax 972.424.5621
 www.republictitle.com
[log in to unmask]
Life is not a journey to the grave with the
intention of arriving safely in a pretty and
well preserved body, but rather to skid in
broadside, thoroughly used up, totally worn out,
and loudly proclaiming: 
-- WOW!!! What a Ride!!!

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Kent Wallace
Sent: Wednesday, January 02, 2008 12:15 PM
To: [log in to unmask]
Subject: [HP3000-L] ODBC (MB Foster) INSERT and Numeric types

Everyone

I am using ColdFusion to INSERT a IMAGE detail dataset record using my
MB Foster ODBC.

I get the following error in ClodFusion:

Error Executing Database Query. 	
[Macromedia][SequeLink JDBC Driver][ODBC Socket][ODBCLINK
Host]Unrecognized SQL command 	

<<snipe>>

SQLSTATE	  HY000	
SQL	   <!-- remove extra characters from numbers ---> INSERT INTO
RETURN_D (serv#,STATUS,AMTCHCL,YMDTRANS) VALUES('07347F4640270100','02P
',10400,'20080102') 	
VENDORERRORCODE	  -1	
DATASOURCE	  HP3000Test	

<<End CF  error>> 


1.  The dataset is:

Database: COAL.DATA.AMITEST

    RETURN-D         Detail                  Set# 9
       Entry:                     Offset
          SERV#                X16     1  (!SERV-A)
          STATUS               X10    17
          AMTCHCL              I2     27
          YMDTRANS             X8     31
    Capacity: 13098 (111)  Entries: 0  Highwater: 0  Bytes: 38
>

1.  The field AMTCHCL is an I2, do I need to send a field already
converted to a binary number and not the display number 10400?

Thanks
Kent Wallace




* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2