Re: return values(table) from stored function from MS visual foxpro
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: return values(table) from stored function from MS visual foxpro |
| Дата | |
| Msg-id | CAHnozTgYwB+6kqRCdMxwNSpa9SSik6ra3zcvgKf-UEN7uxse3A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: return values(table) from stored function from MS visual foxpro (Ilija Vidoevski <ilija.vidoevski@yahoo.com>) |
| Ответы |
Re: return values(table) from stored function from MS visual foxpro
|
| Список | pgsql-novice |
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
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
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.vidoevski@yahoo.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') < 0Aerror(laError)Messagebox(laError[1,2])Endiflenght of returned fields are OK.IlijaFrom: Willy-Bas Loos <willybas@gmail.com>Sent: Friday, May 25, 2012 12:58 PM
To: Ilija Vidoevski <ilija.vidoevski@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Subject: Re: [NOVICE] return values(table) from stored function from MS visual foxproOn Fri, May 25, 2012 at 12:49 PM, Ilija Vidoevski <ilija.vidoevski@yahoo.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
В списке pgsql-novice по дате отправления: