Roy,

<< Thank you Oh mighty one, but let me guess clob IS NULL still wouldn't be
the same as clob = ''? >>

No, that's a different issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy

>>let me guess clob IS NULL still wouldn't be the same as clob = ''?

But that's not absolutely necessary. Write 2 Delphi functions for replacing Field.isNull
and Field.Clear. If you plant them into subclassed TEDBQuery and TEDBTable components,
there is minimum code to change, can maybe even done fully automated with regex. Or get
GExperts, use the Grep Search (I love it), search for ).isNull and ).Clear, replace it
with your functions.

For the queries, search for =null, and replace the CLOB and varchar ones with =''.

Done that today, will finish tomorrow...and in comparison it was much less work than
rewriting all those "update from" queries...

Heiko

Tim


Not complaining, just making doubly sure.

Roy Lambert

Heiko


>But that's not absolutely necessary. Write 2 Delphi functions for replacing Field.isNull
>and Field.Clear. If you plant them into subclassed TEDBQuery and TEDBTable components,

Its easy enough to write a couple of utility routines, and I may eventually do so.  But they would have to take the form IsItEmpty(field) rather than field.IsItEmpty.

Functions like .IsNull and .Clear go back to TField in DB and eventually TDataSet. I doubt that subclassing TField, or TDataSet would achieve anything without ElevateDB source (Tim?) so it would mean hacking DB which is something I'd prefer to avoid.

>there is minimum code to change, can maybe even done fully automated with regex. Or get
>GExperts, use the Grep Search (I love it), search for ).isNull and ).Clear, replace it
>with your functions.

I use a utility I wrote when I first moved from BDE to DBISAM

Roy Lambert

Enrico

I've posted the code into the extensions ng. Not a great deal to it though


Roy Lambert

> I've posted the code into the extensions ng. Not a great deal to it though
>


TNX ^^