Problem writing field using alias (MSQuery)

[danilo.abranches]

Hello,

When i put a query in Msquery with a field using alias, it is not written.

Example:

Code: Select all

select upper(field) as field from table

Delphi:

Code: Select all

msQuery.Open;
msQuery.First;
msQuery.Edit;
msQuerycampo.AsString := 'test';
msQuery.Post;

Is that a problem? Know any solution?

Note: I'm replacing the use of TClientDataset by TMsquery

[azyk]

To generate an UPDATE SQL query, we use meta-information about a database object, that each field belongs to. For your SQL query, SQL Server doesn't return the name of the table containing the field. Therefore we don't use this field when auto-generating SQL queries in this case.

To solve the problem, you should manually generate an UPDATE SQL query for the TMSQuery.SQLUpdate.Text property. For example:

Code: Select all

  msQuery.SQLUpdate.Text :=
  ' UPDATE mytable1 ' +
  ' SET ' +
  '   MyField = :field ' +
  ' WHERE ' +
  '   id = :id ';

[danilo.abranches]

Thank you, i will do so.

[azyk]

Feel free to contact us if you have any further questions.