Re: Query Trouble

Article View: borland.public.vdbase.data.sql

Article #27

Back to borland.public.vdbase.data.sql Previous Next

#27

From: Bert Vergeer
Date: Thu, 11 Feb 1999 00:00

19 lines
1260 bytes

Sorry for not being specific enough.  I have been working in both the
ISQL(part of SQL Server) and this statement below works, but using this in
Vdbase, this doesn't work.  I am building my SQL statement in the SQL
property of the query object.  My SQL statement goes like this:

select * from "...\specserve.dbf" where compldate = Null

except I am getting an error in the where clause.


Bert Vergeer wrote in message <79ur35$jg92@forums.borland.com>...
>I am doing this query which involves a condition that is checking to see if
>a date field in my table is blank.  In the table it is set to a date field.
>I have tried many different things to try and get it but none of them work.
>Any help would be greatly appreciated.  Thanks in advance
>
>Scott
>
>

Technical Details

Message-ID: <79v7c2$l3g2@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <79ur35$jg92@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e92ddfa7d52fce8f
X-Google-Attributes: gidff5a1,public
From: "Bert Vergeer" <av-base.sys@sympatico.ca>
Subject: Re: Query Trouble
Date: 1999/02/11
Message-ID: <79v7c2$l3g2@forums.borland.com>
X-Deja-AN: 443301274
References: <79ur35$jg92@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message