"Field" Is Null On sql statements generated from REGET with Oracle Accelerator

"Field" Is Null On sql statements generated from REGET with Oracle Accelerator

Post by ekanaki » Fri, 20 Feb 2004 19:48:47


I use Clarion 5b Oracle Accelarator and the Reget(View) command,
generates sql statements using <"Field" Is Null>, when the child field
is null. This very bad for performance on Oracle Database.
Is there any way to bypass this problem? It is very critical for me, and
I thing for everyone who uses Oracle Accelerator.

Thanks
Elias
 
 
 

1. Using an SQL statement to convert date format where the field is NULL???

2. Access query with IIF statements is null for a field and not null

I am trying to insert a comma between [name] and [section name] field if the
[name] field is not null - but I don't want the comma if the [name] field is
null

RPTNAME: IIf([name]=" ",[section name],IIf([name]>" ",[name] & ", " &
[section name]))

But the RPTNAME comes up blank if there is not data in the [name] field.

Any suggestions?

3. Null result when combining null field with non-null field in ADP View

4. SQL statement to insert a value generated by a SELECT statement?

5. Should SQL concatenation return a null value if one field is null?

6. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45302132408)

7. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45301953330)

8. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45300557607)

9. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45303632410)

10. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45303657609)

11. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45300232401)

12. convert ms access sql staement to oracle sql statement

13. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45301434694)

14. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45302432405)

15. US-TX-Austin: Oracle/ SQL DBA Developer, SQL DBA, Oracle DBA, Oracle Developer; (45300532411)