I change table structure and input parametars, but the problem still exist.
When I sent SQL script from Foxpro side, result data types are OK. Strange!
It is not problem to fix this on Foxpro side, but many times thousands of rows are returned from server.
I want almost everything to do on server side.
I try within same function to create temp table on server side and alter fields structure, but nothig is changed.
Maybe this is ODBC problem ?
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 10:41 AM Subject: Re: [NOVICE] return values(table) from stored function from MS visual foxpro
The result data type is not related to your existing table. You're using the datatype char for both result columns. That type is padded with spaces. I would always advise to use varchar(n) or "text" unless you need the result to be exacly some length, like 254.
However you seem to be using numbers, why don't you use the "integer" data type?