Something with unique fields V4MD

[Ruslan Zasukhin]

on 11/28/03 11:45 AM, Florian Bogeschdorfer at fb at memedia.de wrote:

Hi Florian,

1) I wonder, do you have around this UNIQUE field some BaseObject methods?

2) does this methods also marked as UNIQUE?

If yes, then your bug is similar to reported by Jon.

Let me know formula of that BaseObject method please.


> Hi Ruslan,
> 
> I think we had this before and you fixed it, but somehow something is weird.
> 
> Say I have a table with some fields and one field which is unique
> kTypeString
> 
> It is indexed, unique and nullable.
> 
> Now I add a record with
> 
> set addRecordCursor = new( xtra "VCursor", GetRef(VAL[#ID]), "select
> RecID, * from "&tableName,2,1,2)
> x=addRecord(addRecordCursor, recDataList)
> .
> .
> In the list I write some fields BUT NOT TO THE UNIQUE FIELD!
> 
> Fine, all works, I can add hundres of records, of which the unique field
> will always be NULL.
> 
> Now the user takes a record enters a string in the unique field and saves
> it. Then he edits the field again and saves an empty string. The field value
> should now be "".
> 
> But after that if I try to add a new record, I get an error message "field
> is unique". Hmmm. The new record should have NULL in this specific field,
> the "old" record "" or if not changed also "NULL".
> 
> So where does the error come from?
> 
> Next I take the record where the unique field is "" and enter something else
> e.g. "test".
> 
> Now I can add records again.
> 
> Looks like a bug 4 me??

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