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
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: 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@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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
