• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [OT] Selecting column names in FrontBase
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [OT] Selecting column names in FrontBase


  • Subject: Re: [OT] Selecting column names in FrontBase
  • From: David Holt <email@hidden>
  • Date: Fri, 19 Dec 2008 15:26:02 -0800

How about as an example

SELECT FirstName, LastName from User_Table;

That gives me a list of rows such as:

John Jones
Mary Kay

etc.

What I'd like to do is get

FirstName LastName
John Jones
Mary Kay

etc.



On 19-Dec-08, at 2:47 PM, Josh Paul wrote:

What is the SQL you are using for the SELECT? Can't you simply include the column names after the SELECT statement?

SELECT columnName FROM tableName ...

?

On Dec 19, 2008, at 11:20 AM, David Holt wrote:

Hello all,

Does anyone know how to select column names along with the data using SQL92 (FrontBase). I often do a quick Select and data export out of FrontBaseManager and I am surprised that there is no facility to select the column names as well. They are displayed in the interface, so I KNOW it's possible :-)

<column names.jpg>

I have googled and I asked on the FrontBase list and received no responses. I can't imagine that it is an unusual request?

David

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com


This email sent to email@hidden


_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
References: 
 >[OT] Selecting column names in FrontBase (From: David Holt <email@hidden>)
 >Re: [OT] Selecting column names in FrontBase (From: Josh Paul <email@hidden>)

  • Prev by Date: Re: [OT] Selecting column names in FrontBase
  • Next by Date: Re: Really, really OT: Professor Chaos supports EOF
  • Previous by thread: Re: [OT] Selecting column names in FrontBase
  • Next by thread: Replicating iTunes Smart List in WO?
  • Index(es):
    • Date
    • Thread