Copy and paste is what I currently use, but it's "ugly."

Clay Shannon,
Dimension 4 Software

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Hans
Sent: Monday, June 27, 2005 10:31 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] * - ?

Have you considered a simple cut and paste process using something like
IBConsole or IBOConsole ?

----- Original Message -----
From: "Joe Martinez" <joe@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, June 27, 2005 10:51 AM
Subject: Re: [firebird-support] * - ?


> Here's what I wish was possible... I want to grab ALL the fields in one
> table, and only a couple of fields in a joined or subselected
> table. Something like:
>
> Select * from sales, custfname,custlname from customers...
>
> -Joe
>
> At 09:45 AM 6/27/2005, you wrote:
>>No.
>>
>>On Mon, 2005-06-27 at 11:42 -0500, Clay Shannon wrote:
>> > Is there some kind of syntax in SQL which allows you to select most of
>> > the
>> > columns from a table without selecting them all.
>> >
>> > IOW, if you have a table with 25 columns, and you want 22 of them in
>> > your
>> > result set, can you do something like:
>> >
>> >
>> >
>> > Select (* - SuperfluousVal, SuperfluousVal2, SuperfluousVal3) from .
>> >
>> >
>> >
>> > .rather than explicitly listing the 22 columns?
>> >
>> >
>> >
>> > Listing the 22 columns explicitly is a pain; grabbing all 25 using
>> > "SELECT
>> > *" is wasteful.
>> >
>> >
>> >
>> > Clay Shannon,
>> >
>> > Dimension 4 Software
>>
>>
>>
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Visit http://firebird.sourceforge.net and click the Resources item
>>on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>>Also search the knowledgebases at http://www.ibphoenix.com
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>Yahoo! Groups Links
>>
>>
>>
>>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links