SQL Columns over 32 Char

SQL Columns over 32 Char

Post by G. Bradley » Thu, 26 Jan 2006 07:53:12


I seem to be having an issue with Client Data Sets based on Providers /
SQL DataSets (dbExpress).

The CDS seems to have an issue with fields over 31 characters in length.
Is this a known problem? Or perhaps something I have managed to ***
up? If it is known - any work arounds?



--

G. Bradley MacDonald
bradley_AT_telus_DOT_net
 
 
 

SQL Columns over 32 Char

Post by Craig Stun » Fri, 27 Jan 2006 01:51:47


Yes it is, and no, I'm unaware of any workarounds.

--
Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
Delphi/InterBase Weblog : http://www.yqcomputer.com/
All the great TeamB service you've come to expect plus (New!)
Irish Tin Whistle tips: http://www.yqcomputer.com/

 
 
 

SQL Columns over 32 Char

Post by Iman L Cra » Fri, 27 Jan 2006 02:32:59


@newsgroups.borland.com:

You need to read http://www.yqcomputer.com/


--
Iman
 
 
 

SQL Columns over 32 Char

Post by Kevin Frev » Fri, 27 Jan 2006 02:33:19


Alias the field in the SQL statement

Select
MyLongFieldNameThatIsLongerThanThirtyTwoCharacters [Bob]

Just curious, why would you have a field name longer than 32 characters?
What is it?

krf
 
 
 

SQL Columns over 32 Char

Post by Craig Stun » Fri, 27 Jan 2006 02:45:12


Oh, do note that although you can't make TClientDataset accept > 31
char names, you can alias column names in SQL:

SELECT
FOO_123456789012345678901234567890 AS FOO,
[...]

--
Craig Stuntz [TeamB] Vertex Systems Corp. Columbus, OH
Delphi/InterBase Weblog : http://www.yqcomputer.com/
All the great TeamB service you've come to expect plus (New!)
Irish Tin Whistle tips: http://www.yqcomputer.com/
 
 
 

SQL Columns over 32 Char

Post by G. Bradley » Fri, 27 Jan 2006 03:32:23

>
It is a series of tables we are converting from another system.

I agree - why use over 31 characters. But then again - that may be one
of the reasons why they are now out of business <g>

--

G. Bradley MacDonald
bradley_AT_telus_DOT_net