How do I retrieve max_length from the following sql querySHOWFIELDS FROM tblX

[Bart Pietercil]

Hi Barry,

if I understand what your asking this should help you

select max_length FROM (show fields FROM tbl_users)

obviously tbl_users needs to be your table


But maybe I did not understand what you are asking :-)

This works from a 3.5b4 VStudio

hth

Bart

On 18-okt-07, at 14:03, Barry G. Sumpter wrote:

> I'm running 3.4 on win.
>
> Not happening.
>
>
>
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ivan Smahin
> Sent: Thursday, 18 October 2007 9:46 PM
> To: Valentina Developers
> Subject: Re[2]: How do I retrieve max_length from the following sql
> querySHOWFIELDS FROM tblX
>
> Hello Barry,
>
> Thursday, October 18, 2007, 2:31:43 PM, you wrote:
>
>> Nope not there.
>
>> And the following doesn't work either:
>> SHOW PROPERTIES OF FIELD tblX.fldY
>
> Seems you are running some version before 3.3.
> There are the features implemented in 3.3-3.5 versions.
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina