Hello All:

  I am converting an app from DBISAM Version 1.

   In version 1 I could do a filter such as NUD<>'U' and get all records
where the NUD field did not contain capital U even if the NUD field is null.
Will this change under the new elevateDB ??? How did other users handle this
change in behavior ???


Neil
Profit Monster Data Systems

huhtaman


You have two options

1. Create the columns with a default of emptyspace so there is ALWAYS something there
2. Add AND IS NOT NULL to the filter

If you use option 1 then never call field.Clear in Delphi always use field.AsString := '' .

Roy Lambert

Roy,

<< If you use option 1 then never call field.Clear in Delphi always use
field.AsString := '' . >>

Actually, if you just set the column so that it is required (NOT NULL) by
altering the table, then you don't have to worry about that, at least not in
terms of a NULL value getting into the table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< If you use option 1 then never call field.Clear in Delphi always use
>field.AsString := '' . >>
>
>Actually, if you just set the column so that it is required (NOT NULL) by
>altering the table, then you don't have to worry about that, at least not in
>terms of a NULL value getting into the table.

Interesting thought. What's ElevateDB going to do silently convert it to empty string or throw a wobbly. If the latter I believe my comment stands. If the former very interesting.

Roy Lambert [Team Elevate]

Roy,

<< Interesting thought. What's ElevateDB going to do silently convert it to
empty string or throw a wobbly. If the latter I believe my comment stands.
If the former very interesting. >>

Of course it's going to throw an exception.  My point was that just saying
"don't do this" isn't quite enough to make sure that your database integrity
stays intact.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Of course it's going to throw an exception. My point was that just saying
>"don't do this" isn't quite enough to make sure that your database integrity
>stays intact.

and I never mentioned database integrity <vbg>

Roy Lambert