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

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