RE: Cannot Insert

Author: Jerry Foote

Posted: 2012-03-01 at 13:59:06

-----Original Message-----

From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of Stephen Russell

Sent: Thursday, March 01, 2012 1:32 PM

To: ProFox Email List

Subject: Re: Cannot Insert

On Thu, Mar 1, 2012 at 1:11 PM, Jerry Foote <jerryfoote@bellsouth.net>

wrote:

> When I attempt to insert blank on a table opened exclusive with VFP9  I

get

> error message..

>

> INSERT cannot be issued when row or table buffering is enabled or when

> integrity constraints are in effect.

>

>-----------------

>

>You probably have :

>

> integrity constraints are in effect.

>

>Primary key probably not but FKey to other table is what might be biting

>you.

>--

>Stephen Russell

>901.246-0159 cell

I deleted the indexes I had on the file and I was able to insert.

Thanks Jerry

_______________________________________________

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/10FAF4630D504D00B2F6CBFBC8D0F6A8@jerryfootePC

** 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.

©2012 Jerry Foote