Convert to Varchar Problem

[Beatrix Willius]

Hi Ivan,

sorry my bad. The topic of the post is incorrect. I'm converting OTHER fields to varchar and THIS one from string to text. The data the field contains is unique, that's not the problem. But why wouldn't the data be unique after changing, this is the question?

On 23.06.2011, at 13:21, Ivan Smahin wrote:

> You are writing about converting to VarChar, but actually you are converting to the Text.
> Which statement is true?
> 
>> The old definition of the field MailboxPath is:
>> 
>>   dim MailboxPath as VString = new VString("MailboxPath",  1000)
>>   MailboxPath.IsUnique = true
>> 
> The old field was String(1000), the new field is Text(256) - actually any length with segment size  == 256.
> Probably some really not unique values there?
> BTW - you should not set unique flag in the loop.
> One more point - unique string field is not a best idea, but unique text field ... would you consider to redesign db?
> 
>> Where could the error message come from?
> Update record, add record._______________________________________________

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.