TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

General discussion forum about all databases other than SqlBase.
MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by MSchmidt » 01 Oct 2014, 09:35

Yesterday we made an update from SP2 Upd 1 to SP2 Upd2

After starting our main application we've got a SQL Error message without any description.

After some hours we've found the reason why:

Inside the SQL select statement there were 3 columns defined as text on the SQL Server
If we reduce the SQL select to only 1 text colum the SQL is working.


So I've made a test case.

inside the zip-file there is a SQL script file for the building of a table which is used in the test case.

In the test case you can see the Problem under the pink coloured push Buttons.
the green coloured Buttons are workarrounds.

If we make a SQL-update in the testcase, the application crashes.

The Workarounds are not a solution for us, cause we are not able to find all locations in our code, where more than one text column are used in a SQL Select

Conclusion:
SQL Select with more than 1 Text column is not possible any more.
The application crashes (!) in case of a SQL update with a text column inside.

We are not able to work with this version of TD!

I think Gupta should make an EMP for this Problem

Thank you
M.Schmidt
You do not have the required permissions to view the files attached to this post.
Last edited by Anonymous on 01 Oct 2014, 22:17, edited 3 times in total.

lorenzf

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by lorenzf » 01 Oct 2014, 15:46

Unfortunatly we have the same problem:
SQL Error 20054, no error text.

kind regards
franz

VEspinal

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by VEspinal » 01 Oct 2014, 22:28

Hi All:

The reprocase that you've sent is working for me.

I took the liberty to add a small function to clear the multines and the datafield every time you press any pushbutton in order to have a better view of the information.

I was able to click the 4 pushbuttons with no crashes. Unless there is something else that I something that I am missing.

Please see attached video.

Thanks

Best Regards,
Victor Espinal
You do not have the required permissions to view the files attached to this post.

MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by MSchmidt » 01 Oct 2014, 23:17

thank you for testing and for the quick Response

I checked my SQL.ini

There was a high value for the longbuffer keyword in section of [odbcrtr]


dealing with this value SQL is working!!!!!!!!!

We set the value higher than the standard value 32000 cause we are saving files in the database.

With a value of 55000000 the SQL is working fine

But with 755000000 the SQL doesn't work.

So I think it would be a big help for all of us, to have the limitations of the value of longbuffer.

In the help file I've found only this:
longbuffer Keyword in SQL.INI File

If you connect natively to Oracle, Informix, or Sybase System 10 and System 11, the longbuffer keyword in the SQL.INI file specifies the maximum number of bytes of long data type columns to read from or write to the database, and truncates excess bytes.


Maybe the development of Gupta can give us a statement to the longbuffer value and it's limitations.

Thank you
M.Schmidt
Last edited by Anonymous on 25 Dec 2014, 23:11, edited 1 time in total.

ianrudge

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by ianrudge » 29 Oct 2014, 15:31

+1

MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by MSchmidt » 08 Dec 2014, 13:57

after more than 2 months, I ask again about the function and the limits of the LONGBUFFER value
in SQL.ini file

thank you

M.Schmidt

User avatar
H3PO4
Germany
Posts: 241
Joined: 10 Mar 2017, 07:53
Location: Rohlstorf, Germany

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by H3PO4 » 09 Nov 2016, 11:16

+1

frevelundfey

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by frevelundfey » 09 Nov 2016, 12:30

Hi,

this is not the answer to you question but maybe it's helpful:

Besides setting longbuffer in SQL.ini which affects all cursors you connect to the db
you can set the longbuffer-size per cursor programmatically:
Call SqlSetParameterAll( hSql, DBP_LongBuffer, nDesiredBufferSize, '', TRUE )
We use that when we have to fetch large blobs or texts from db.

Regards Thomas

PeterFr

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by PeterFr » 21 Nov 2016, 16:29

Hello,

I tried to set it with:
Call SqlSetParameterAll( hSql, DBP_LongBuffer, nDesiredBufferSize, '', TRUE )
but DBP_LONGBUFFER or DBP_LongBuffer is not a valid constant (got a compile error).
I found it in the help documentation but it seem it's not a valid constant. Strange.
Using TD63SP2.
Thx!

frevelundfey

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by frevelundfey » 22 Nov 2016, 09:54

Hi Peter,
you are right. This constant is not available in Gupta Runtime.
But in help I found it and defined it in my .apt:
Number: DBP_LongBuffer = 5112 ! Konstante - Quelle: Gupta-Help

Regards Thomas

PeterFr

Re: TD 6.2 SP2 Up2 SQL Problem Text Columns SQL Server

Post by PeterFr » 07 Dec 2016, 15:18

Thanks Thomas!

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest