Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
TMSSQLConnection: only one active TSQLQuery?
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
Forum Rules
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
AI assisted translation o...
by
schuler
[
Today
at 02:17:10 am]
FPC Unleashed (inline var...
by
440bx
[
Today
at 02:12:04 am]
Naming daemons during ins...
by
hrayon
[
Today
at 01:35:28 am]
Zipper: Addition of mult...
by
wp
[April 14, 2026, 11:13:48 pm]
[SOLVED] Can't pass strin...
by
mas steindorff
[April 14, 2026, 08:51:15 pm]
Fast Canvas Library V1.05...
by
Gigatron
[April 14, 2026, 08:39:38 pm]
Translation of Lazarus ID...
by
pmralbuquerque
[April 14, 2026, 07:47:01 pm]
PWM signals, atmega328p, ...
by
ccrause
[April 14, 2026, 07:26:20 pm]
GTK3: FillRect() mispaint...
by
zeljko
[April 14, 2026, 07:23:52 pm]
Necromancer's Dos Navigat...
by
Thaddy
[April 14, 2026, 06:26:29 pm]
TUpDown KeyDown event
by
LeP
[April 14, 2026, 06:01:57 pm]
I hope FreePascal can sup...
by
Thaddy
[April 14, 2026, 05:08:11 pm]
Trying to plot points, bu...
by
garymq
[April 14, 2026, 02:01:36 pm]
SPC Player Library
by
creaothceann
[April 14, 2026, 01:59:25 pm]
How to merge multiple cla...
by
cdbc
[April 14, 2026, 11:57:56 am]
Fractal of Mandelbrot
by
Boleeman
[April 14, 2026, 10:20:21 am]
Ann: DeCoperators
by
Thaddy
[April 14, 2026, 09:23:24 am]
My project to build and p...
by
krolikbest
[April 14, 2026, 09:07:12 am]
Weird error
by
xiyi0616
[April 14, 2026, 07:10:18 am]
Remote desktop software i...
by
Boleeman
[April 14, 2026, 12:59:14 am]
fp-h2pas: New C header tr...
by
Gustavo 'Gus' Carreno
[April 13, 2026, 06:32:22 pm]
Nezplug Library Player
by
Gigatron
[April 13, 2026, 04:15:33 pm]
Eschecs (UCI chess GUI) 5...
by
Roland57
[April 13, 2026, 04:10:12 pm]
[ANN] fpGUI Toolkit v2.0....
by
cdbc
[April 13, 2026, 03:14:21 pm]
Lazarus Bugfix Release 4....
by
dbannon
[April 13, 2026, 01:52:18 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: TMSSQLConnection: only one active TSQLQuery? (Read 858 times)
SymbolicFrank
Hero Member
Posts: 1315
TMSSQLConnection: only one active TSQLQuery?
«
on:
June 27, 2023, 02:11:21 pm »
If I open the second one (both for reading only), I get this error message:
Code: Text
[Select]
[+]
[-]
TMSSQLConnection : Error 20019 : Attempt to initiate a new Adaptive Server operation with results pending
Is there a setting somewhere I'm missing?
Logged
Чебурашка
Hero Member
Posts: 593
СЛАВА УКРАЇНІ! / Slava Ukraïni!
Re: TMSSQLConnection: only one active TSQLQuery?
«
Reply #1 on:
June 27, 2023, 03:05:25 pm »
I found this
https://forum.lazarus.freepascal.org/index.php/topic,32433.msg209322.html#msg209322
Where LacaK tells some bits about opening a second query while the previous is fetching, both on same conn
And this:
https://stackoverflow.com/questions/36706525/python-pymssql-attempt-to-initiate-a-new-adaptive-server-operation-with-results
«
Last Edit: June 27, 2023, 03:09:29 pm by Чебурашка
»
Logged
FPC 3.2.0/Lazarus 2.0.10+dfsg-4+b2 on Debian 11.5
FPC 3.2.2/Lazarus 2.2.0 on Windows 10 Pro 21H2
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
TMSSQLConnection: only one active TSQLQuery?
TinyPortal
© 2005-2018