- At 07:07 AM 1/09/2003 +0000, you wrote:
>HiYes. Use a column list and just omit the one(s) you don't want:
>Can I in a select statement select evrything but 1 field ?
select Col1, Col2, .... LastCol
- Hi Michael,
> Can I in a select statement select evrything but 1 field ?But what 1 field? What do you mean?
Selects only 1 field, I can easily list all other fields except
Please explain a bit more.
Database Workbench - the developer tool for InterBase & Firebird
- Hi Helen
I did know that much but I was wondering if I could something like
Select * except feild1 from MyTable......
Because I have a table that has 48 fields, and I would like to select
them all except 1 field.
Its not a big deal, but I was just wondering.
Thank you anyway.
- At 07:52 AM 1/09/2003 +0000, you wrote:
>Hi HelenNope. Heck, "Select * " is **bad enough** !!!
>I did know that much but I was wondering if I could something like
>Select * except feild1 from MyTable......
>Because I have a table that has 48 fields, and I would like to select
>them all except 1 field.
>Its not a big deal, but I was just wondering.
Did you know that IB_SQL has a nifty little helper in the Browse tool,
which lists all of the columns of a table in "copy-paste" format, so that
you can just lift them out and drop them straight into your query string?
If you have IB_SQL, open the Browse tool and select your table. Then click
the "Field Names List" tab at the right, then the "Comma and Space" radio
button - and there is your ready-to-go fieldlist.
You can can IB_SQL free from www.ibobjects.com
- Hi Martijn
I think Helen got my point.
But to explain some more, then lets say I have a table of 50 fields
(field1, field2, field3, etc).
I would then like to select all fields except field37 i.e.
I thought it was imposible, and as Helen explained it is.
And since I was just wondering, thats ok.
- Hi Michael,
> I think Helen got my point.Well, I kinda emailed right after your first post - it
seems Yahoo is a bit slowish these days... :-)
Anyway, you got the answer.
- Hi Martijn,
> Well, I kinda emailed right after your first post - itLast night the delay was around 2 hrs. They must receive millions of
> seems Yahoo is a bit slowish these days... :-)
Sobig-infected messages per day, I guess that's what's slowing them
(just generated 100.000 non-existing Germans with DBW :-))
- Hi Michael
--- In firstname.lastname@example.org, "Michael Vilhelmsen"
> I would then like to select all fields except field37 i.e.I vaguely recall that there are SQL dialects, where you can
dynamically generate a SQL statement by means of SQL, most
usefully with queried metadata tables.
Pseudo-SQL which will certainly work nowhere:
'SELECT ' ||
(SELECT colname FROM meta$columns
WHERE table = 'tbl1' AND colname != 'field37
AS STRING DELIMITER ',') ||
'FROM tbl1' ;