Ed
I have this problem in inserting data into FREE VFP tables from .NET.
Can you please post it to our forum, I may get a solution?

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. Any ideas how to
overcome this?
Thanks
Krishna

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ed Leafe
Sent: Tuesday, November 13, 2007 5:36 PM
To: [EMAIL PROTECTED]
Subject: Fwd: Copy of dbsalvage?

        Forwarding this for Chet Gardiner, who is having trouble with
his email.

Begin forwarded message:

> From: Chet Gardiner <[EMAIL PROTECTED]>
> Date: November 13, 2007 12:44:22 PM EST
> To: Ed Leafe <[EMAIL PROTECTED]>
> Subject: Copy of dbsalvage?
>
> Hey, Ed.
>
> I got cut off after moving here to Tucson and cutting off my old ISP.

> I couldn't get into my leafe account to change to my new email address

> but...
>
> That's not why I'm writing...
>
> I'm trying to get a copy of dbsalvage to try to save an old ex- 
> client's database.  Do you have a copy or could you inquire on the 
> list as to whether someone has a copy they could send me?
>
> Thanks in Advance...
>
> Chet Gardiner
> (Now finally thawing out in Tucson, AZ!)


-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com




[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
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.

Reply via email to