Re: return values(table) from stored function from MS visual foxpro
| От | Ilija Vidoevski |
|---|---|
| Тема | Re: return values(table) from stored function from MS visual foxpro |
| Дата | |
| Msg-id | 1337950133.91398.YahooMailNeo@web113102.mail.gq1.yahoo.com обсуждение исходный текст |
| Ответ на | Re: return values(table) from stored function from MS visual foxpro (Willy-Bas Loos <willybas@gmail.com>) |
| Ответы |
Re: return values(table) from stored function from MS visual foxpro
Re: return values(table) from stored function from MS visual foxpro |
| Список | pgsql-novice |
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@gmail.com>
To: Ilija Vidoevski <ilija.vidoevski@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Sent: Friday, May 25, 2012 12:58 PM
Subject: Re: [NOVICE] return values(table) from stored function from MS visual foxpro
To: Ilija Vidoevski <ilija.vidoevski@yahoo.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.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.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
В списке pgsql-novice по дате отправления: