return values(table) from stored function from MS visual foxpro
| От | Ilija Vidoevski |
|---|---|
| Тема | return values(table) from stored function from MS visual foxpro |
| Дата | |
| Msg-id | 1337856530.12329.YahooMailNeo@web113108.mail.gq1.yahoo.com обсуждение исходный текст |
| Ответы |
Re: return values(table) from stored function from MS visual foxpro
Re: return values(table) from stored function from MS visual foxpro |
| Список | pgsql-novice |
I want to migrate from MS Sqlserver 2008 r2 express to PostgresqlI use postgresql 9.1.3I create this stored function (on Postgres side)CREATE OR REPLACE FUNCTION public.a_getkonta_table ( mkontoa char, mkontob char)RETURNS TABLE ( kontochar, 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'VOLATILECALLED ON NULL INPUTSECURITY INVOKERCOST 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
ENDIFReturned result set contains correct row numbers but fields length is 254.Structure of table konta isKonto 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 ?
В списке pgsql-novice по дате отправления: