Recent

Author Topic: sqldb field with alias can't create updatesql automatic correctly  (Read 447 times)

YanZhaoCun

  • Newbie
  • Posts: 1
TSQLQuery component SQL statement like this:

select A as aA, B as aB
from tablename

can not automaticaly generate UpdateSQL, InsertSQL, DeleteSQL correctly.
« Last Edit: August 13, 2022, 05:26:26 am by YanZhaoCun »

Zvoni

  • Hero Member
  • *****
  • Posts: 2300
Re: sqldb field with alias can't create updatesql automatic correctly
« Reply #1 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
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

 

TinyPortal © 2005-2018