Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: DBGrid + ADQuery + AdUpdateSQL why update work ?
DBGrid + ADQuery + AdUpdateSQL why update work ?
Posted: 2007/10/24 12:53
 
AnyDac 2.0.5 + Delphi 2007 SP1 + MySQL 5.0.41

Put to form DBGrid + ADQuery + AdUpdateSQL etc....


 ADUpdateSQL1.ModifySQL.Clear; ADUpdateSQL1.ModifySQL.Append('call `Upd_Links` (:NEW_link_id, :NEW_link_ancestor_id, '+   ':NEW_node_id, :NEW_link_terminal, :NEW_link_level, :NEW_link_shortcut, '+   ':NEW_link_show_order, :NEW_link_name, :NEW_Del)');



Use AdUpdateSQL for Stored Proc.... work perfect!!! th, but,
i'm edit in grid some value, just was "1" change to "1"

hm... its strange because Data not changed, but Update Work! Why ?
Re:DBGrid + ADQuery + AdUpdateSQL why update work ?
Posted: 2007/10/24 20:25
 
Hello

1) Is UpdateOptions.UpdateChangedFields = True ?
2) If yes, then could you send me test application, please ?

Regards,
Dmitry
Re:DBGrid + ADQuery + AdUpdateSQL why update work
Posted: 2007/10/25 04:22
 
1. Yes
2. Yes http://mmm.ho.com.ua/secret/Sources.rar

P.S. I'm use not standart DBGrid, i'm use DevExpress 6 cxGrid, already check/// realy, if use standart DBGrid update not work, good. Then its some bug with cxGrid, shit
Re:DBGrid + ADQuery + AdUpdateSQL why update work
Posted: 2007/10/25 04:22
 
Maby need use some adapters from addons ?

Post edited by: MMM_Corp, at: 2007/10/25 04:24
Re:DBGrid + ADQuery + AdUpdateSQL why update work
Posted: 2007/10/25 06:56
 
Hi

1) Adapters - may be ...

2) I will check later - very busy at moment. You can check how AnyDAC generates UPDATE. Open daADPhysCmdGenerator.pas, find there TADPhysCommandGenerator.GenerateUpdate. There you see call of ColumnChanged. If it returns True, then columnd value is changed.

Regards,
Dmitry