Subject | Strange SELECT FIRST 1 |
---|---|
Author | Mr. John |
Post date | 2012-09-12T10:18:24Z |
Hi,I'm using FB 2.5.1.26351 SS on XP SP3,I have one stored procedure,also inside
FOR EXECUTE STATEMENT loop I have this query
SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf AND numar=:wNUMAR INTO :xid_cf,:xnumar;
wNUMAR,wid_cf are also variables
declare xID_CF bigint;DECLARE xNUMAR NUMERIC(18,0);
declare wid_cf bigint; DECLARE wNUMAR NUMERIC(18,0)
to debug SP I write some data into a table GN_DEBUG
What I don't understand,for this query
...............
SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf AND numar=:wNUMAR INTO :xid_cf,:xnumar;
IF (wNUMAR=10739 and wid_cf=202) THEN
begin
INSERT INTO GN_DEBUG(MSG) VALUES(:wid_cf||' '||:xid_cf||' '||:wnumar||' ||:xNUMAR);
end..........................
I'm expecting on this query to have the same values for xnumar as wNUMAR also xid_cf=wid_cf as query condition,but I found into GN_DEBUG one record : 202 276 10739 10738, in other words :
wid_cf =202
xid_cf =276
wnumar=10739
xNUMAR=10738
Please I need some help,thanks !
[Non-text portions of this message have been removed]
FOR EXECUTE STATEMENT loop I have this query
SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf AND numar=:wNUMAR INTO :xid_cf,:xnumar;
wNUMAR,wid_cf are also variables
declare xID_CF bigint;DECLARE xNUMAR NUMERIC(18,0);
declare wid_cf bigint; DECLARE wNUMAR NUMERIC(18,0)
to debug SP I write some data into a table GN_DEBUG
What I don't understand,for this query
...............
SELECT FIRST 1 id_cf,numar FROM CB_FC WHERE ID_CF=:wid_cf AND numar=:wNUMAR INTO :xid_cf,:xnumar;
IF (wNUMAR=10739 and wid_cf=202) THEN
begin
INSERT INTO GN_DEBUG(MSG) VALUES(:wid_cf||' '||:xid_cf||' '||:wnumar||' ||:xNUMAR);
end..........................
I'm expecting on this query to have the same values for xnumar as wNUMAR also xid_cf=wid_cf as query condition,but I found into GN_DEBUG one record : 202 276 10739 10738, in other words :
wid_cf =202
xid_cf =276
wnumar=10739
xNUMAR=10738
Please I need some help,thanks !
[Non-text portions of this message have been removed]