Lazarus

Programming => Databases => Topic started by: YanZhaoCun on August 13, 2022, 05:23:20 am

Title: sqldb field with alias can't create updatesql automatic correctly
Post by: 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.
Title: Re: sqldb field with alias can't create updatesql automatic correctly
Post by: Zvoni on August 15, 2022, 08:33:46 am
TSQLQuery 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
TinyPortal © 2005-2018