Re: return values(table) from stored function from MS visual foxpro

wait, are you sure that you are running the right function?
the function is defined by it's input fields(incl types), so
a_getkonta_table(mkontoa character varying, mkontob character varying)
is a different function from
a_getkonta_table(mkontoa char, mkontob char)
so you would have 2 functions.

>Other fields contain data like name, adress ...
Other fields?? Oh, you mean you have a key-value approach?

i can't really say anything about odbc or foxpro
there is a seperate list for odbc by the way:
http://archives.postgresql.org/pgsql-odbc/

cheers,

WBL

On Fri, May 25, 2012 at 2:48 PM, Ilija Vidoevski
<ilija(dot)vidoevski(at)yahoo(dot)com>wrote:

> To varchar.
> I can not change this field to integer.
>
> Other fields contain data like name, adress (street, number), city,
> country etc... and must be char or varchar.
>
> I simply can not understand why when I retrive data from the stored
> function lenght of returnet fields based od char or varchar table field is
> 254 char.
>
> With this code:
> If SQLExec
>
> (Handle,"select * from konta",'kontaq') < 0
> Aerror(laError)
> Messagebox(laError[1,2])
> Endif
>
> lenght of returned fields are OK.
>
> Ilija
> *From:* Willy-Bas Loos <willybas(at)gmail(dot)com>
> *To:* Ilija Vidoevski <ilija(dot)vidoevski(at)yahoo(dot)com>
> *Cc:* "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
> *Sent:* Friday, May 25, 2012 12:58 PM
>
> *Subject:* Re: [NOVICE] return values(table) from stored function from MS
> visual foxpro
>
>
>
> On Fri, May 25, 2012 at 12:49 PM, Ilija Vidoevski <
> ilija(dot)vidoevski(at)yahoo(dot)com> wrote:
>
> I change table structure and input parametars, but the problem still
> exist.
>
> What did you change it to? Integer?
> --
> "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
>
>
>
>

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth