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

From: Ilija Vidoevski <ilija(dot)vidoevski(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: return values(table) from stored function from MS visual foxpro
Date: 2012-05-24 10:48:50
Message-ID: 1337856530.12329.YahooMailNeo@web113108.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to migrate from MS Sqlserver 2008 r2 express to Postgresql
I use postgresql 9.1.3
I create this stored function (on Postgres side)
CREATE OR REPLACE FUNCTION public.a_getkonta_table (
  mkontoa char,
  mkontob char
)
RETURNS TABLE (
  konto char,
  naziv char
) AS
$body$
begin
    return query
    SELECT
    konta.konto,
    konta.naziv
    FROM konta
    WHERE konta.konto between mkontoa and mkontob;
end ;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100 ROWS 1000;
I call this function with this code (from Microsoft VisualFoxPro side)
mkontoa = '000000000'
mkontob = '099999999'
If SQLExec(handle,"select *
from a_getkonta_table(?mkontoa,?mkontob)",'temp101') < 0
   Aerror(laError)
   Messagebox(laError[1,2])
   return
ENDIF
Returned result set contains correct row numbers but fields length is 254.
Structure of table konta is
Konto char(9)
Naziv char(45)
 
I use this connection string:
Connstr="DRIVER={PostgreSQL odbc driver(unicode)};server=localhost;Port=5432;Database=mydatabase; Uid=postgres;Pwd=mypwd;UseServerSidePrepare=1;MaxVarcharSize=254;UnknownsAsLongVarchar=0;TextAsLongVarchar=0;"
OS Window 7
profesional
 
Any
solutions ?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Willy-Bas Loos 2012-05-25 08:41:55 Re: return values(table) from stored function from MS visual foxpro
Previous Message Susanne Ebrecht 2012-05-24 09:14:09 Unknown winsock error 10061