sqldb field with alias can't create updatesql automatic correctly
lazarus / 16-Databases

----------------------------------------------------------------------
YanZhaoCun · 2022-08-13 03:23

TSQLQuery component SQL statement like this:

select A as aA, B as aB
from tablename

can not automaticaly generate UpdateSQL, InsertSQL, DeleteSQL
correctly.

----------------------------------------------------------------------
Zvoni · 2022-08-15 06:33

Quote from: YanZhaoCun on August 13, 2022, 05:23:20 amTSQLQuery
component SQL statement like this:

select A as aA, B as aB
from tablename

can not automaticaly generate UpdateSQL, InsertSQL, DeleteSQL
correctly.
Do it yourself?
In general, i don't trust auto-generated SQL-Statements.
Period