[AccessD] Select statements to get column definitions?

DWUTKA at marlow.com DWUTKA at marlow.com
Wed May 19 10:41:09 CDT 2004


Yeah, wrote that before my first cup of coffee.  Sorry.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid
Sent: Wednesday, May 19, 2004 10:21 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Select statements to get column definitions?


Wouldn't that be 'That would create a field called SomeOtherName' instead of
'That would create a field called MyField'?

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com
Sent: Wednesday, May 19, 2004 11:13 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Select statements to get column definitions?


As far as I know, the only 'options' you have with a SELECT statement is the
AS keyword.  ie, you can say SELECT MyField AS SomeOtherName FROM
tblMyTable.  That would create a field called MyField, which would be the
'caption' of a field.  Not sure what you are actually trying to do though,
so if you explain what you are trying to accomplish, I may be able to help a
little more.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller
Sent: Wednesday, May 19, 2004 10:01 AM
To: AccessD
Subject: [AccessD] Select statements to get column definitions?


Is there a way to write a SELECT statement so that its result looks similar
to the display you see when you design a table? That is, column name, type
and description -- I don't care about the other attributes at the moment. I
know you can use the Documenter but I want the results as a table if
possible.

TIA,
Arthur

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list