Adrian_Chimirel
Legendary Poster
Hi,
First thing first, I'm glad to see you were working (hard) the week I've had a (too) short vacation. Bravo!
Now let's get back to business; please, be patient (as you always are, anyway) and share with me the following:
In Xe, I'm looking for A WAY to fix the QBE on a Find/Browse form.
Whenever the user QBEs a field, the grids gets not only the successful querried records, BUT those with NULL values, too
Taking a snapshot onto the debug log, the SELECT clause looks like this:
"... WHERE (T1.ALADD1 LIKE 'DALLAS%' OR T1.ALADD1 IS NULL) ..."
The Form's View is a 3 tables (T0=F0101, T1=F0115 & T2=F0116) Left Outer Join, something like:
F0101.AN8 *= F0115.AN8
F0101.AN8 *= F0116.AN8
F0101.EFTB *= F0116.EFTB and it works fine in B732
Am I missing something here, like a switch or checkbox, somewhere, on the BSVW /Form Designer or ... ?
OR is it just (another) bug to be promptly, Denver(ly) reported?
TIA,
LIVE: B732.1 SP12.2, Oracle 806, FormScape 2.1
SANDBOX: Xe SP15 & Update2, Oracle 8i
RS/6000, Citrix
First thing first, I'm glad to see you were working (hard) the week I've had a (too) short vacation. Bravo!
Now let's get back to business; please, be patient (as you always are, anyway) and share with me the following:
In Xe, I'm looking for A WAY to fix the QBE on a Find/Browse form.
Whenever the user QBEs a field, the grids gets not only the successful querried records, BUT those with NULL values, too
Taking a snapshot onto the debug log, the SELECT clause looks like this:
"... WHERE (T1.ALADD1 LIKE 'DALLAS%' OR T1.ALADD1 IS NULL) ..."
The Form's View is a 3 tables (T0=F0101, T1=F0115 & T2=F0116) Left Outer Join, something like:
F0101.AN8 *= F0115.AN8
F0101.AN8 *= F0116.AN8
F0101.EFTB *= F0116.EFTB and it works fine in B732
Am I missing something here, like a switch or checkbox, somewhere, on the BSVW /Form Designer or ... ?
OR is it just (another) bug to be promptly, Denver(ly) reported?
TIA,
LIVE: B732.1 SP12.2, Oracle 806, FormScape 2.1
SANDBOX: Xe SP15 & Update2, Oracle 8i
RS/6000, Citrix