How do I assign a null value to Paradox Date Field using Delphi

Scott

Delphi Developer

Tue, 10 Jul 2001 03:00:00 GMT

How do I assign a null value to Paradox Date Field using Delphi

I want to allow the user to blank out a date field in a static table.

Example:
tableNameFieldName.value := null

gives an EVariantError exception

Steve Koters

Delphi Developer

Tue, 10 Jul 2001 03:00:00 GMT

Re:How do I assign a null value to Paradox Date Field using Delphi

Quote

On Fri, 22 Jan 1999 14:48:24 -0500, "Scott" <sco...@advret.com> wrote:
>I want to allow the user to blank out a date field in a static table.

>Example:
> tableNameFieldName.value := null

> gives an EVariantError exception

Use the TField.Clear method.

tableNameFieldName.Clear;

//////////////////////////////////////////////////////////////////////////
Steve Koterski "For people who like peace and quiet:
Technical Publications a phoneless cord."
INPRISE Corporation -- Unknown
http://www.inprise.com/delphi

Team

Delphi Developer

Tue, 10 Jul 2001 03:00:00 GMT

Re:How do I assign a null value to Paradox Date Field using Delphi

TableNameFieldName.Clear;

will assign null to the field.

Bill

--
Bill Todd
(Sorry but TeamB cannot answer questions received via email)
(Remove nospam from my email address to contact me for any other reason)

Other Threads

1. Using the Date value for assigning Today's date to a field

2. URGENT: Date field with index and NULL values.

3. Assign NULL value to TParam (TIBStoredProc IBX4.52) in Delphi

4. Date Fields in Paradox and Dbase when using Delphi 2

5. BDE fails when accessing null date fields using Oracle 8.1.6 ODBC driver

6. Setting a date field to null using a query

7. Using CAST(), I want to assign null value to type of Date field.

8. Assign (null)-value

9. How to assign NULL to the Params value of the TQuery

10. error assigning NULL to a TSQLDataSet parameter - dbExpress (Error msg: No value for parameter FldDate)