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 1337953638.78123.YahooMailNeo@web113103.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  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-novice
Дерево обсуждения
Thank's
 
I will try to find solution.
If  I can not, I will have to stay on MS Sqlsrever 2008.
Maybe MS front-end app and MS back-end app is best choice.
 
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 3:01 PM
Subject: Re: [NOVICE] 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.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') < 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



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






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



В списке pgsql-novice по дате отправления:

Предыдущее
От: Jean MAURICE
Дата:
Сообщение: Re: return values(table) from stored function from MS visual foxpro
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: return values(table) from stored function from MS visual foxpro