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...
I will Study about the literature, just one question, what do you mean by Hard Commit ? ... Study the literature regarding transaction isolation. It is...
... Nope. Heck, "Select * " is **bad enough** !!! Did you know that IB_SQL has a nifty little helper in the Browse tool, which lists all of the columns of a...
Hi Michael, ... But what 1 field? What do you mean? SELECT EMPLOYEEID FROM EMPLOYEE Selects only 1 field, I can easily list all other fields except this one. ...
Well, then the result will be random amongst those finishing shared 22nd (o= r 21st) unless you have some other way of ordering them.
By nesting NOT...
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...
Hi Michael, ... Well, I kinda emailed right after your first post - it seems Yahoo is a bit slowish these days... :-) Anyway, you got the answer. -- Martijn...
Up until now we have been using Interbase 6.0 and are testing Firebird 1.5. We have a grid component that was written in-house and uses the "ORDER BY COLUMN...
Hi Glenn, ... The the word "COLUMN" - SELECT * FROM EMPLOYEE ORDER BY 1 With regards, Martijn Tonies Database Workbench - the developer tool for InterBase &...
hi, I am writting stored procedure which will fire many delete queries on the basis of the number as a input parameter.When in the stored procedure i use only...
I am not sure but I think that you need to order by the ordinal value of the field... So it would be ORDER BY 1 Probably wrong but heck, I may be able to...
Martin Dew
martin.dew@...
Sep 1, 2003 11:02 am
29289
hi, I am writting stored procedure which will fire many delete queries on the basis of the number as a input parameter.When in the stored procedure i use only...
hi, I am writting stored procedure which will fire many delete queries on the basis of the number as a input parameter.When in the stored procedure i use only...
Hi, ... Is the below part your actual code that you're trying to run? If so, ... END## ... SET TERM ; ## And then do a COMMIT. With regards, Martijn Tonies ...
Hi Martijn, ... Last night the delay was around 2 hrs. They must receive millions of Sobig-infected messages per day, I guess that's what's slowing them ...
Hi Michael ... I vaguely recall that there are SQL dialects, where you can dynamically generate a SQL statement by means of SQL, most usefully with queried...
Sorry I typed in the word COLUMN incorrectly. It shouldn't have been in my first post. From what I can see Firebird doesn't seem to have a problem with the ...
Hi, ... I kinda thought Sobig was cooling down a little - or at least, I'm not getting 50 of those per day anymore! ... *g* Better not send an email to those...
... You made your post double confusing. The word you are looking for is not "index" but "position". If this word isn't techie enough for you, then you can...
Hi, ... 2.4.21 ... Classic server, 64IO ... tarball from sourceforge and install script (no 1.0.3 or greater available yet via apt-get) ... HTH, Fabrice...
... Then it doesn't get compiled. Compilation happens *after* you commit the procedure declaration. This didn't commit, it failed. 1. Get rid of the aliases...
