Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Real SQL - get column sizes (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: How to advance the focus in a window
Next thread: OT USB EDGE Modem


Reading *CSV Files versus *.Txt Files   -   Claude Stone
  Real SQL - get column sizes   -   David Hart
   Re: Real SQL - get column sizes   -   Norman Palardy
   Re: Real SQL - get column sizes   -   Mike Bailey

Real SQL - get column sizes
Date: 24.11.08 18:57 (Mon, 24 Nov 2008 11:57:25 -0600)
From: David Hart
I need to pragmatically find varchar column sizes. Is there a way to do
this for Real SQL databases?


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Real SQL - get column sizes
Date: 24.11.08 19:31 (Mon, 24 Nov 2008 11:31:14 -0700)
From: Norman Palardy

On 24-Nov-08, at 10:57 AM, David Hart wrote:

> I need to pragmatically find varchar column sizes. Is there a way
> to do this for Real SQL databases?

TableSchema and FieldSchema should be what you need

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Real SQL - get column sizes
Date: 25.11.08 15:31 (Tue, 25 Nov 2008 08:31:06 -0600)
From: Mike Bailey
On Nov 24, 2008, at 11:57 AM, David Hart wrote:

> I need to pragmatically find varchar column sizes. Is there a way
> to do
> this for Real SQL databases?

Do you need to find the size of the column that was specified in the
schema, or the size of the data? If you need the column size then you
can use Database.FieldSchema and look at the length field that is
returned.

To get the size of the data contained in that column then you can use
the length function:

select length( name ) from customers

Hope this helps.