Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Add code SQL in the class method
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Big Numbers Math
by
woodybrison
[
Today
at 01:30:21 am]
Project fails on run but ...
by
jamie
[
Today
at 12:54:49 am]
Curling Pythagoras Tree: ...
by
Boleeman
[
Today
at 12:00:37 am]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[March 28, 2024, 11:51:31 pm]
Ribbon bar in Lazarus 3.2...
by
wp
[March 28, 2024, 11:29:17 pm]
Free AI to use in local
by
BSaidus
[March 28, 2024, 10:57:23 pm]
how to search in rxmemory...
by
rcmz
[March 28, 2024, 10:19:54 pm]
Configure JCF messages
by
GordonFindlay
[March 28, 2024, 10:16:19 pm]
Poll: Watches and Display...
by
Martin_fr
[March 28, 2024, 10:15:08 pm]
Dialog ShowModal and an i...
by
d7_2_laz
[March 28, 2024, 09:51:39 pm]
JEDI error but unit compi...
by
Thaddy
[March 28, 2024, 09:30:33 pm]
Understanding and adjusti...
by
circular
[March 28, 2024, 09:09:56 pm]
Controlling the behavior ...
by
wp
[March 28, 2024, 08:29:28 pm]
how to change the color f...
by
wp
[March 28, 2024, 07:23:58 pm]
Dynarray initialization p...
by
Thaddy
[March 28, 2024, 06:30:12 pm]
Zeos components. Had to c...
by
Fantablup
[March 28, 2024, 04:17:13 pm]
[SOLVED] Completion box s...
by
furious programming
[March 28, 2024, 04:12:26 pm]
[LAMW] How to create a ca...
by
af0815
[March 28, 2024, 03:48:16 pm]
Complex package installat...
by
wp
[March 28, 2024, 03:38:16 pm]
A "leisure" question on W...
by
gidesa
[March 28, 2024, 03:17:10 pm]
[SOLVED] Combined pointer...
by
CM630
[March 28, 2024, 02:48:41 pm]
Using KeyPress event, how...
by
Zvoni
[March 28, 2024, 02:24:42 pm]
a Unit problem?
by
Thaddy
[March 28, 2024, 01:56:12 pm]
Any upgrades to fpWeb pag...
by
marcov
[March 28, 2024, 12:50:25 pm]
Help needed with Cairo / ...
by
Roland57
[March 28, 2024, 12:25:16 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Add code SQL in the class method (Read 485 times)
carlos_am_2003
Newbie
Posts: 3
Add code SQL in the class method
«
on:
November 21, 2022, 01:15:49 pm »
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]
[+]
[-]
TCar
=
class
private
name
:
string
;
year
:
integer
;
end
How can I add code to save an object TCar in the database?
Code: Pascal
[Select]
[+]
[-]
TCar
=
class
private
name
:
string
;
year
:
integer
;
procedude SQL_InsertOrUpdate
;
procedude SQL_Delete
;
end
OR
Code: Pascal
[Select]
[+]
[-]
TCar
=
class
private
name
:
string
;
year
:
integer
;
end
;
TSQL_Car
=
class
procedure
SQL_InsertOrUpdate
(
car
:
TCar
)
;
procedude SQL_Delete
(
car
:
TCar
)
;
What do you think?
Help me!
Logged
Zvoni
Hero Member
Posts: 2319
Re: Add code SQL in the class method
«
Reply #1 on:
November 21, 2022, 02:30:57 pm »
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
Logged
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
MarkMLl
Hero Member
Posts: 6676
Re: Add code SQL in the class method
«
Reply #2 on:
November 21, 2022, 02:50:23 pm »
I think he's looking for a way to serialise an instance into a table.
Deserialisation costs extra :-)
MarkMLl
Logged
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories:
https://github.com/MarkMLl?tab=repositories
carlos_am_2003
Newbie
Posts: 3
Re: Add code SQL in the class method
«
Reply #3 on:
November 21, 2022, 03:12:16 pm »
Hi!
I would just like an opinion on the best way to go about it.
Logged
Zvoni
Hero Member
Posts: 2319
Re: Add code SQL in the class method
«
Reply #4 on:
November 21, 2022, 03:15:54 pm »
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)
Logged
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
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Add code SQL in the class method
TinyPortal
© 2005-2018