hi..
myQuery string like this
Select iPriode, left(iPriode,4) as iYear, right(iPriode,2) as iMonth from tPriode
when i wanna insert, the sql show the readonly message.
i already choice only iPriode field will update from SQL Generator
INSERT INTO tPriode
(iPriode)
VALUES
(:iPriode)
but fail, i already try using MyUpdateSql.. but still fail...
right now i am using MyCommand to Update,Delete and Insert.
and good solution ???
Jigu Jigu
Can't Update Query...
We couldn't reproduce the problem.
Please send us (mydac*crlab*com) a complete small test project to reproduce
the problem; include definition of your own database objects; don't use
third party components.
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL Server and MySQL client. You can see it in Info sheet of TMyConnection Editor
Please send us (mydac*crlab*com) a complete small test project to reproduce
the problem; include definition of your own database objects; don't use
third party components.
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL Server and MySQL client. You can see it in Info sheet of TMyConnection Editor