344 - Index not sorted

[Ruslan Zasukhin]

On 4/7/04 8:04 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:

Hi Tim,

> Thanks for your reply
> 
> 1. In VISQL the error text is "Index not sorted"

Strange, based on 1.10 ?

> 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 ?

Yes, into unique field you can insert many NULLs
> 
> Will removing the fieldisunique flag fix it - and can I then reapply
> the flag?

You can do this only if field DO NOT have unique values.
Otherwise Valentina will refuse set this flag.

I still think you have some the same value.
May be you have BaseObject methods in table and they produce duplicates?

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