SV: [V4RB] insert into select quirk

[Ruslan Zasukhin]

on 3/3/04 10:53 AM, niklas wormann at nwoe at privat.utfors.se wrote:

>> Agree Niklas,
>> 
>> Probably no error because of this is batch mode...
>> 
>> So you do INSERT INTO table that have BaseObject method?
>> Of FROM this table?
>> 
>> If you try write INTO BaseObject method..then
>> I think Valentina should ignore your values, and insert into other real
>> fields.
>> 
> 
> i am inserting into table that has baseobject method.
> because of poor design by me of method field
> concat(nodeid,caseid)-- gives duplicate values for e.g nodeid 11, caseid 1
> and nodeid1, caseid 11.
> 
> 
> so when i try to insert,i am not trying to insert inte the method (!), into
> caseid and nodeid,
> i dont get any errors, although the insert fails completely. no records are
> inserted.
> 
> everything seems to work out ok from err and errstring, but it isn?t.

I see.

BaseObject method get not unique value, and stop work of command.

I see. 

Yes, in ideal we must get error Value not 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
-------------------------------------------------------------