You can use the NVL function, like this:
insert into myfreetable(code,company,purchasedate) values(
nvl(nCode,0),nvl(cCompany,''),nvl(dPurchDate,{})
Rafaell Copquin
----- Original Message -----
From: Ed Leafe
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2007 2:00 PM
Subject: Re: Copy of dbsalvage?
On Nov 15, 2007, at 11:33 AM, Davuluri, Murali K. wrote:
> When trying to insert into a FREE VFP table using the following SQL
> code
> "Insert into table1(field1,field4,field5,field6) values
> (value1,value2,value3,value4)"
> I get error like this "Field12 doesn't accept NULL values".
> I can over come this by making Field2 and filed3 to accept NULL values
> by altering the table. But this one breaks calculations in VFP code. I
> can't always default values for the omitted fields in the INSERT
> statement. Some of the omitted fields are Date fields. Those omitted
> fields would be updated later as the necessity arises.
Free tables cannot have default values; they must be in a DBC to use
that feature. So you either have to ensure that valid, non-null
values are inserted, or you have to update your calcs to check for
and deal with null values.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
