From: | Ilija Vidoevski <ilija(dot)vidoevski(at)yahoo(dot)com> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: return values(table) from stored function from MS visual foxpro |
Date: | 2012-05-25 13:47:18 |
Message-ID: | 1337953638.78123.YahooMailNeo@web113103.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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 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(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 theproblem 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
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-05-25 18:32:26 | Re: return values(table) from stored function from MS visual foxpro |
Previous Message | Jean MAURICE | 2012-05-25 13:11:06 | Re: return values(table) from stored function from MS visual foxpro |