Subject | Re[2]: [firebird-support] How SET AUTODDL works? |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-06-23T18:31:52Z |
Hello, W!
Sunday, June 23, 2013, 10:26:17 PM, you wrote:
WO> I had tried it and still doesnt work:
WO> SET AUTODDL ON;
WO> INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2);
WO> INSERT INTO MyTable (Column1, Column2) VALUES (OtherValue1, OtherValue2);
WO> QUIT;
WO> And when I return to ISQL and write SELECT * FROM MyTable the two previous
WO> inserts are not there.
well, this is not DDL. DDL is CREATE/ALTER/DROP, etc.
INSERT/DELETE/UPDATE/EXECUTE is DML, not DDL.
--
Dmitry Kuzmenko, www.ib-aid.com
Sunday, June 23, 2013, 10:26:17 PM, you wrote:
WO> I had tried it and still doesnt work:
WO> SET AUTODDL ON;
WO> INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2);
WO> INSERT INTO MyTable (Column1, Column2) VALUES (OtherValue1, OtherValue2);
WO> QUIT;
WO> And when I return to ISQL and write SELECT * FROM MyTable the two previous
WO> inserts are not there.
well, this is not DDL. DDL is CREATE/ALTER/DROP, etc.
INSERT/DELETE/UPDATE/EXECUTE is DML, not DDL.
--
Dmitry Kuzmenko, www.ib-aid.com