Devart Forums

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

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

Ooopss...

sorry,..

the readonly property is set to True by accidentally.


the problem is solve...

thank'sss

Jigu