Update Database via SQL

[mkinzler]

It's the same for SQL as without. Just leave the key field unset:

SQL-Code:

insert into <Tablename> (FirstName) values ( :firstname);

[DeddyH]

I am not familiar with Absolute Database, so I cannot say if an autoinc-key can start with 0 there, but you can use this key as condition in the above example:

SQL-Code:

UPDATE <tablename> SET FirstName = 'John', LastName = 'HeyHo', Sallary = 20100 WHERE EmployeeID = 1

[nanix]

You mean like this right,

Delphi-Quellcode:

ABSQuery1.SQL.Clear;
ABSQuery1.SQL.Add('UPDATE <tablename> SET FirstName = 'John', LastName = 'HeyHo', Sallary = 20100 WHERE EmployeeID = 1');
ABSQuery1.SQL.Open;

[mkinzler]

This updates Lisa with John.

[nanix]

I ment the string it has to be like this,

Delphi-Quellcode:

ABSQuery1.SQL.Add('UPDATE <tablename> SET FirstName = John, LastName = HeyHo, Sallary = 20100 WHERE EmployeeID = 1');

Otherwise not compile?

[DeddyH]

Use parameters.

[nanix]

Thanks i will.

You all probably asked why does he need this.

Well to tell you the truth i need it becouse i have to load DB items to listview.Becouse there isn't a DB listview that also supports groups.

[mkinzler]

It compiles even with wrong statements. At runtime an error is then reported

[nanix]

Is this good idea for creating&updating items from DB to non data aware listview

[nanix]

I ment for creating and updating DB efficiently.Anyways this is my full code.If someone can peak to it and look if something could be improved.Mainly the procedure CreateUpdateSensors

http://www.mediafire.com/?tzeiu44mmdn