Edit a Query >>>> NO Function at DelphiXE

Red-Flash · Post by **Red-Flash** » 12.10.2010, 07:39

This Function didn't works at Delphi XE

with Query do
begin
SQL.Clear,
SQL.add ('SELECT * FROM Tablename')
Open;
if RecordCount > 0 then
begin
Edit;
FieldByBName ('Field').asString := 'Hallo'; // ------> here comes an error-message
Post;
end;

Marius2 · Post by **Marius2** » 12.10.2010, 10:34

Editing a query result is useless.

Instead write an update sql.. update table set field=:value etc..

Red-Flash · Post by **Red-Flash** » 12.10.2010, 10:47

I know the UPDATE function,

BUT ist is very easy to edit a query, as an UPDATE...

and it works everytime with Delphi7.

but DelphiXE ????????

Marius2 · Post by **Marius2** » 12.10.2010, 10:51

Yes its easy, but it wil not work AFAIK.

Red-Flash · Post by **Red-Flash** » 12.10.2010, 11:25

Marius2 wrote:Yes its easy, but it wil not work AFAIK.

Why, didn't ist Work with XE ????