344 - Index not sorted

[Tim James]

  Thanks for your reply

1. In VISQL the error text is "Index not sorted"

2. I understand unique fields and flags but the point being that I am  
trying to add

a unique field that is NOT the same as any other value of the field in  
the table.

(I can't alter/remove the flag as the DB in question is on a remote  
site that I communicate with my own client server application based on  
SQLexecute/select's only)

Is it possible to add a null field to unique field and there may be  
another

null as well ?

Will removing the fieldisunique flag fix it - and can I then reapply  
the flag?
Thanks

Tim

On 06/04/2004, at 3:39 PM, Ruslan Zasukhin wrote:

> 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,TotalVal 
>> ue
>> ,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
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>