SQL more... problem with <NULL> V4MD1

[Florian Bogeschdorfer]

Thank you Pierre!

Unfortunately this won't help because it means I have to check maybe a
100.000 records and several fields for a <NULL> and I want to avoid this. I
am looking for a solution before I get the recordlist in Valentina.
Unfortunately the IFNULL() syntax does not work.

best

Florian Bogeschdorfer

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net [mailto:valentina-
> bounces at lists.macserve.net] On Behalf Of Pierre Rossel
> Sent: Monday, November 06, 2006 11:39 PM
> To: 'Valentina Developers'
> Subject: RE: SQL more... problem with <NULL> V4MD1
> 
> Hello,
> 
> 
> > So far so good. The problem is <NULL>. As we have discussed a
> > year ago on
> > this list, this is no valid Director value, in Director it
> > should be VOID.
> 
> If it can help, someone gave me this code to test a NULL value in
> Director.
> I have not tested it so far, so I don't know if it really works. Maybe it
> should be adapted to latest Director version and its new ilk
> implementation.
> 
> on nullP a
>    return(ilk(a, #void) and not(voidP(a)))
> End
> 
> Pierre Rossel
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina