344 - Index not sorted

Ruslan Zasukhin sunshine at public.kherson.ua
Tue Apr 6 08:39:52 CDT 2004


On 4/6/04 3:42 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:

> I am getting this error when I attempt to execute the following
> 
> INSERT INTO CRheaders
> (Number,DateIssued,DateReceived,DateCompleted,Status,Supplier,TotalValue
> ,TotalUnits,Comments) VALUES
> ("16","6/4/04","00/00/00","00/00/00","0","241","0.00","0"," ")
> 
> The only field that is indexed is number which is also defined as unique
> 
> There is only one row in the table with a number value of "8999001".
> 
> I have reindexed the BO, deleted the db.ind file but all to no avail

Hi Tim,

    kFBL_FieldIsUnique            = 344,

344 -- means field is uniquie.

And this error means that you try add second time the same value.
This is mistake.


Check your values.
Or remove flag unique.



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list