selectdb return -1

Author: (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...?



  1. Hi David,

    can you give us the


    to allow a closer look.

    Success, Uli


    Author: ulrich-merkel (
  2. Hi Uli,

    $status = -1


    $dberror = 0


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

    Author: dammie (
  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 (