Skip to main content

selectdb return -1

Author: dammie@seznam.cz (dammie)

Hello, there is table "DATA" with text fiel "TEXT" larger then varchar255, so there exists overflow table "ODATA"...

if I try

selectdb (TEXT) from "DATA" u_where ( my_condition )

I get error -1....

If I rewrite this code to retrieve/e, everything works fine... I thought that there is same communication procedure used, so data should be retrieved reagrderess the way I use...?

David

selectdb return -1

Author: dammie@seznam.cz (dammie)

Hello, there is table "DATA" with text fiel "TEXT" larger then varchar255, so there exists overflow table "ODATA"...

if I try

selectdb (TEXT) from "DATA" u_where ( my_condition )

I get error -1....

If I rewrite this code to retrieve/e, everything works fine... I thought that there is same communication procedure used, so data should be retrieved reagrderess the way I use...?

David

Hi David,

can you give us the

$procerrorcontext.
$dberror
 

to allow a closer look.

Success, Uli

 


Author: ulrich-merkel (ulrichmerkel@web.de)

selectdb return -1

Author: dammie@seznam.cz (dammie)

Hello, there is table "DATA" with text fiel "TEXT" larger then varchar255, so there exists overflow table "ODATA"...

if I try

selectdb (TEXT) from "DATA" u_where ( my_condition )

I get error -1....

If I rewrite this code to retrieve/e, everything works fine... I thought that there is same communication procedure used, so data should be retrieved reagrderess the way I use...?

David

Hi Uli,

$status = -1

$procerrorcontext = ERROR=-1101;MNEM=<UPROCERR_FIELD>;DESCRIPTION=Field not valid;COMPONENT=TEST;PROCNAME=51\\DTLF;TRIGGER=DTLF;LINE=1

$dberror = 0

 

(I tried another table - non overflow - and it is going OK)


Author: dammie (dammie@seznam.cz)

selectdb return -1

Author: dammie@seznam.cz (dammie)

Hello, there is table "DATA" with text fiel "TEXT" larger then varchar255, so there exists overflow table "ODATA"...

if I try

selectdb (TEXT) from "DATA" u_where ( my_condition )

I get error -1....

If I rewrite this code to retrieve/e, everything works fine... I thought that there is same communication procedure used, so data should be retrieved reagrderess the way I use...?

David

Hi David,

in Uniface, only the first of ther variable fields is used as a column in the table.

All the variable fields are stored together in this column (or the overflow segments).

Therefore, a straight SQL statement may not reach the TEXT column.

and even if the TEXT is the first of some fields, the contents of the file may be a bit strange (either TRX or XML syntax).

Success, Uli


Author: ulrich-merkel (ulrichmerkel@web.de)
Terms & ConditionsAccessibility statement