Forum > Databases

sqldb field with alias can't create updatesql automatic correctly

(1/1)

YanZhaoCun:
TSQLQuery component SQL statement like this:

select A as aA, B as aB
from tablename

can not automaticaly generate UpdateSQL, InsertSQL, DeleteSQL correctly.

Zvoni:

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

select A as aA, B as aB
from tablename

can not automaticaly generate UpdateSQL, InsertSQL, DeleteSQL correctly.

--- End quote ---
Do it yourself?
In general, i don't trust auto-generated SQL-Statements.
Period

Navigation

[0] Message Index

Go to full version