Re: Calling function from VFP changes character field to Memo

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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.klaver@xxxxxxxxxxx