Add code SQL in the class method

[carlos_am_2003]

Hello!
I have a class, for example, TCar and I need to save the data of the class TCar to any database.

Code: Pascal  [Select][+][-]

1. TCar = class
2. private
3. name: string;
4. year : integer;
5. end
6.  

How can I add code to save an object TCar in the database?

Code: Pascal  [Select][+][-]

1. TCar = class
2. private
3. name: string;
4. year : integer;
5. procedude SQL_InsertOrUpdate;
6. procedude SQL_Delete;
7. end
8.  

OR

Code: Pascal  [Select][+][-]

1. TCar = class
2. private
3. name: string;
4. year : integer;
5. end;
6. TSQL_Car = class
7. procedure SQL_InsertOrUpdate(car : TCar);
8. procedude SQL_Delete(car : TCar);
9.  

What do you think?

Help me!

[Zvoni]

Do you have code using SQL at all? That's not in a class? that works?

Because right now, i don't get it, what the problem is

[MarkMLl]

I think he's looking for a way to serialise an instance into a table.

Deserialisation costs extra :-)

MarkMLl

[carlos_am_2003]

Hi!

I would just like an opinion on the best way to go about it.

[Zvoni]

How about reading the documentation?
https://wiki.freepascal.org/SQLdb_Programming_Reference

I'd start with "How to set up the SQL-Trinity" (Connection-, Transaction-, Query-Objects)