Depending on your actual needs I see two ways. You can do it thru SQL or using a Alias
variable.
SQL:
Select * From MYTABLE
Where not DATECOLUMN
Alias (using MapBasic):
Fetch First From MYTABLE
Do Until EOT(MYTABLE)
aDate = MYTABLE.DATECOLUMN
If not aDate Then
'**No date given
End if
Fetch Next From MYTABLE
Loop
Replace MYTABLE with the name of your table and DATECOLUMN wit the name of your date
column
HTH,
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
Sidste frist for tilmelding til MapInfo Konferencen er den 6. august 2004.
Tilmelding samt yderligere information kan ses p�: http://www.cowi.dk/GIS
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 30, 2004 5:08 PM
To: [EMAIL PROTECTED]
Subject: MI-L date variable
Hello list,
how can I get to know if a field in a table that is declared as date has got a value
or is empty? Thanks in advance.
Ulrike
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe,
e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 12807
