Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
whether SQLQuery do script with many instructions INSERT INTO .......?????
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
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
WIKI Timeout issues
Please read here if you have trouble connecting to the wiki
Recent
Layout problem by nested ...
by
Nicole
[
Today
at 05:12:36 pm]
Lazarus 4, What's wrong w...
by
Thaddy
[
Today
at 05:11:07 pm]
Loading an image from an ...
by
Thaddy
[
Today
at 04:42:00 pm]
Build failure
by
wp
[
Today
at 04:36:02 pm]
IDE Lazarus 4.0 on Window...
by
Martin_fr
[
Today
at 03:47:30 pm]
Lazarus 4.0 RC3
by
paxnet_be
[
Today
at 02:34:23 pm]
Firebird 5 remote login v...
by
LacaK
[
Today
at 02:07:34 pm]
CEF component - the first...
by
salvadordf
[
Today
at 12:40:53 pm]
Compile errors in MacBook...
by
Thaddy
[
Today
at 11:46:06 am]
LAMW - UTF-8 character in...
by
Alcatiz
[
Today
at 11:36:29 am]
How to run an external pr...
by
vsajip
[
Today
at 08:50:34 am]
lazbuild command line swi...
by
n7800
[
Today
at 04:21:35 am]
dBGRidController and Erro...
by
essence-ciel
[
Today
at 01:15:11 am]
"LCLVersion" in *.lfm fil...
by
zeljko
[June 17, 2025, 11:05:36 pm]
FPC for high-performance ...
by
Thaddy
[June 17, 2025, 09:42:33 pm]
How to stop macro executi...
by
440bx
[June 17, 2025, 09:19:45 pm]
x86_64-win64 annoys me
by
Nicole
[June 17, 2025, 08:28:16 pm]
OpenDialog and mouse even...
by
Martin_fr
[June 17, 2025, 07:37:19 pm]
InstallAware 2025 Sources...
by
msintle
[June 17, 2025, 06:49:04 pm]
Sqlite & Zeos
by
CharlyTango
[June 17, 2025, 05:01:43 pm]
Strict Aliasing Rule
by
nixbody
[June 17, 2025, 04:19:41 pm]
Lazarus 4 - I give up and...
by
Nicole
[June 17, 2025, 04:01:40 pm]
LazUtils, FileUtil.CopyDi...
by
AlexTP
[June 17, 2025, 02:52:02 pm]
Help needed setting up LA...
by
silvercoder70
[June 17, 2025, 12:12:06 pm]
Font character being clip...
by
Coxy
[June 17, 2025, 12:04:54 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: whether SQLQuery do script with many instructions INSERT INTO .......????? (Read 4256 times)
abmservice
Jr. Member
Posts: 69
whether SQLQuery do script with many instructions INSERT INTO .......?????
«
on:
April 13, 2010, 07:49:04 pm »
whether SQLQuery do script with many instructions INSERT INTO .......????
Logged
Lacak2
Guest
Re: whether SQLQuery do script with many instructions INSERT INTO .......?????
«
Reply #1 on:
April 14, 2010, 06:21:18 am »
IMHO it depends on backend database if it support batch SQL commands.
for example in case of MySQL it requires setting flag CLIENT_MULTI_STATEMENTS at connection time (which is not done now)
Logged
bobo
Full Member
Posts: 171
Re: whether SQLQuery do script with many instructions INSERT INTO .......?????
«
Reply #2 on:
April 16, 2010, 08:58:58 am »
in MySQL you can do
insert into TABLENAME VALUES (field1, field2...,fieldn), (field1, field2, field3), ...
as one SQL statement to insert multiple records.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
whether SQLQuery do script with many instructions INSERT INTO .......?????
TinyPortal
© 2005-2018