Den 2013-03-20 01:06 skrev Helen Borrie såhär:
At 02:08 a.m. 20/03/2013, rosssmith55 wrote:
Hello! I am fairly new to learning SQL, I am attempting to learn how
to do a Join Delete using flamerobin and was told this is a great
place to learn good stuff :) Any way this is what i got so far.
SELECT a.INV_PARTNUMBER, a.INV_ALTPARTNUMBER, b.INVSUP_SUPPNUM,
a.INV_DESCRIPTION1, a.INV_DESCRIPTION2, a.INV_LOCATIONID, a.INV_UOMID,
a.INV_DEPTID, a.INV_STOCKONHAND, a.INV_COUNTEDDATE FROM INVENTORY a
join INVENTORY_SUPPLIER b on a.INV_ID = b.INVSUP_INVID where
a.INV_COUNTEDDATE
instead I resorted to execute block, like this (in general terms, not
adapted to your specific case):
And, yet another option.
I don't know if it's good or bad, but I do this frequently and have no
problems with performance or results.
If this is not a run-once command, but most likely is
Hello,
with this code I get an sql error, but it works until today perfect :o(
with wgetnextprio as (select prio, count(*) as kount from tfachzuordnung
where le is null and gesperrt = 0
and elementtyp = 1 and paltyp = :paltyp_anfrage group by prio)
select first 1 prio from
On 2013.03.20 11:34 AM, Olaf Kluge wrote:
select first 1 prio from wgetnextprio where kount = (select max(kount)
from wgetnextprio)into :prio_to_find;
I can't say anything about your error but i think this query can get
better results :
select first 1 prio from wgetnextprio
order by kount desc
But now I get: Token unknown, column 1 line 24 (
Without seeing at least 24 lines of code, it is hard to tell why it doesn't
understand the parenthesis at the beginning of line 24 ;o)
with this code I get an sql error, but it works until today perfect :o(
What has changed? Have you upgraded
I have Firebird 2.1.x database with UTF8 character set, collation is not
specified for varchar fields.
It is surprising to see, that varchar comparison is not diacritic sensitive,
e.g. both the following selects return rdb$databse row in FB 2.1.x (no row was
returned for FB 1.5.x):
select *
