Bernie,
Check both:
IF (CVAL('database')) <> 'DataBaseName' +
OR (CVAL('database')) IS NULL THEN
Bill
On Sun, 17 Jun 2001 17:42:35 -0400, Bernard Lis wrote:
>I want to make sure I am connected to the right database so I do
>if (cval('database')) <> 'DataBaseName' then
>
>if no database is connected, cval('database') returns a null and will
>not do the compare to my data base name.
>It worked in dos 5.5 and I am trying to upgrade my client to 6.5
>Is this a bug or can't you compare a null in an if statement?
>
>Bernie Lis
>Megabytes, Inc.
>
