Nitin
1/24/2006 5:48:00 AM
Hi elton,
check it in following way also:
ttsbegin;
ItemTable _itemtable;
select forupdate _itemtable where _itemtable.Itemtype == ItemTable.Itemtype
and _itemtable.linenum ! = ItemTable.linenum;
if(_Itemtable){
_itemtable.itemtype = (ItemTable.ItemType == itemtype::A) ? itemtype::B :
itemtype::A;
_itemtable.update();
}
ttscommit;
ItemTable_ds.reread();
ItemTable_ds.refresh();
Regards
Nitin
"elton" wrote:
> Hi all,
> I have a Table containing a â??Item typeâ? field which is enum type with 2
> option "A" and "B".
> My idea : At the first row of this Table, I choose " A"v alue in "Itemtype"
> field. If I aslo choose "A" value at second row , â??Aâ? value of â??Item typeâ?
> field in the first row will change to B value( because my table only allows
> one row have "A" value but many "B" value).
> My code like this in modify method of Itemtype field :
>
> ttsbegin;
> ItemTable _itemtable;
> select forupdate _itemtable where _itemtable.Itemtype == ItemTable.Itemtype
> and _itemtable.linenum ! = ItemTable.linenum;
> if(_Itemtable){
> _itemtable.itemtype = itemtype::B;
> _itemtable.update();
> }
> ttscommit;
> ItemTable_ds.refresh();
>
> My trouble is: In the first row, Itemtype field is still "A" value . I
> close form and open it again , Itemtype field now changed to B value.
> it mean datasource was not refreshed.
> * How can Itemtype field of the first row change to B value instantly?
>
> Thanks for your helps.
>
>