Subject | Re: [IBO] serious design problem: update queries |
---|---|
Author | L.M. Bemmelmans |
Post date | 2003-07-21T08:39:04Z |
Svein,
No that's not what I mean, and no I don't think my question has been
answered yet. So I think my question was not very clear. I'll try again:
I just want IBobject to generate an UPDATE SQL based on the actual changed
fields of my dataset
So when I change only "lastname" I would IBobjects to produce the following
update statement:
UPDATE orders SET lastname = :lastname WHERE orderID = ID
in stead of
UPDATE orders SET lastname =:lastname,
firstname=:firstname,orderID=:id,achived=:archived WHERE orderID = ID
Greetings,
Leon
No that's not what I mean, and no I don't think my question has been
answered yet. So I think my question was not very clear. I'll try again:
I just want IBobject to generate an UPDATE SQL based on the actual changed
fields of my dataset
So when I change only "lastname" I would IBobjects to produce the following
update statement:
UPDATE orders SET lastname = :lastname WHERE orderID = ID
in stead of
UPDATE orders SET lastname =:lastname,
firstname=:firstname,orderID=:id,achived=:archived WHERE orderID = ID
Greetings,
Leon