Re: Calling function from VFP changes character field to Memo

[Adrian Klaver]

On 11/15/22 10:43 AM, Frank Cazabon wrote:

Please reply to list als.
Ccing list

SELECT * FROM public.testFunction();

SELECT firstname from FROM public.testFunction();

This has the same result.

How about?:

SELECT firstname::varchar(30) from FROM public.testFunction();

Then FirstName returns as a Memo field (similar to a Text field).

Any idea what I need to do to get it to return the character(30) type?

--
Adrian Klaver
adrian.kla...@aklaver.com