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

3 Comments

  1. Hi David,

    can you give us the

    $procerrorcontext.
    $dberror
     

    to allow a closer look.

    Success, Uli

     


    Author: ulrich-merkel (ulrichmerkel@web.de)
  2. 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)
  3. 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)