Re: ECPG selecting into char arrays

Leif Jensen wrote:
>
> With that note in mind, how do I select from a table field of type 'text' ?

If the type is text and you have no idea how long it will be have ecpg/libpq
allocate a buffer for you by using a pointer set to NULL as the variable:

    exec sql char *val = NULL;

    /* Use an indicator here if you allow the field to be a DB NULL */
    exec sql
      select text_field into :val
        from table
        where condition;

    /* Check sqlca.sqlcode here */

    /* val will now contain the address of an area allocated by ecpg
     * holding the contents of the DB field.  You can use it and then
     * pass val to free() after you're done with it
     */
    (do something with val)

    /* Clean up */
    free(val);

    /* Live happily ever after */

HTH

Bosco.