SQLWindows 5.0.3 with SQLBase 810 and Long String

comp.databases.gupta (1995-2015)
Jörg Postma

SQLWindows 5.0.3 with SQLBase 810 and Long String

Post by Jörg Postma » 03 Jul 2003, 22:47

 Posted by:  =?ISO-8859-1?Q?J=F6rg_Postma?= <j.po...@phnxsoft.com> 

Hi,

we are using an "old" application with Gupta SQLWindows 5.0.3 PTF7
and now with SQLBase 8.1.0.

The only problem we have is update or insert with
*Long Bind Data, so *we get the error 116 if we try it.

00116 SQL MLB Programming Error: Missing long bind before write long
Reason: The application program is attempting to perform a write long
(sqlwlo) function call and no long data has been bound.

The statement looks like this:**

SELECT K_INFO, I_USER_NAME INTO :hWndForm.frmMAIN.dfK_INFO,
:hWndForm.frmMAIN.dfI_USER_NEW FROM <Table>
WHERE RID = &apos;1860&apos;
with <Table>.K_INFO LONG VARCHAR

UPDATE <Table> SET
K_INFO= :hWndForm.frmMAIN.dfK_INFO,
I_USER_NAME= :hWndForm.frmMAIN.dfI_USER_NAME
WHERE RID = :frmMAIN.dfRID

:hWndForm.frmMAIN.dfK_INFO
is a Data Field with DataType *Long String.

*If there is a simple solution please tell me....

--
Regards,
Jörg Postma

-----------------------------------------------------------------
Jörg Postma j.po...@phoenixsoftware.de
Phoenix Software GmbH Tel. +49 228 97199 0
Adolf-Hombitzer-Str. 12 Fax +49 228 97199 99
52337 Bonn, Germany http://www.phoenixsoftware.de

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 1 guest