Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Query with no result
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
CORDIC algorithms
by
MaxCuriosus
[
Today
at 12:34:43 am]
How to detect if a String...
by
jamie
[December 04, 2023, 11:38:49 pm]
License Agreement
by
RayoGlauco
[December 04, 2023, 11:33:44 pm]
How to print a DrawGrid
by
wp
[December 04, 2023, 11:29:20 pm]
virus with lazarus-3.0RC2...
by
rvk
[December 04, 2023, 11:11:01 pm]
Feature announcement: Fun...
by
amerou
[December 04, 2023, 10:18:18 pm]
Online Package Manager
by
wp
[December 04, 2023, 07:57:56 pm]
i can't inatall Dam dialo...
by
wp
[December 04, 2023, 07:55:42 pm]
(new Topic) i can't inata...
by
majid.ebru
[December 04, 2023, 07:43:23 pm]
Lazarus Release Candidate...
by
dedrasta
[December 04, 2023, 05:39:19 pm]
Flock of Birds
by
Dzandaa
[December 04, 2023, 05:30:05 pm]
https page download
by
BubikolRamios
[December 04, 2023, 04:11:51 pm]
Anyone interested in test...
by
Thaddy
[December 04, 2023, 02:44:32 pm]
Unable to write "/usr/sha...
by
Thaddy
[December 04, 2023, 02:26:11 pm]
[SOLVED] TStringGrid.Colu...
by
wp
[December 04, 2023, 11:03:07 am]
Advance Record operators ...
by
Thaddy
[December 04, 2023, 07:51:12 am]
Installing Lazarus on a R...
by
dbannon
[December 04, 2023, 06:45:40 am]
Un-register an LCL Compon...
by
dbannon
[December 04, 2023, 06:07:39 am]
Creating a "compressed" s...
by
maurobio
[December 03, 2023, 11:19:01 pm]
Lazarus 3.9.9 Variable Wa...
by
Martin_fr
[December 03, 2023, 09:27:11 pm]
TCustomShellTreeView.GetF...
by
Alexx2000
[December 03, 2023, 07:22:01 pm]
Can TreeView Node Colours...
by
Bart
[December 03, 2023, 07:21:27 pm]
Two paintbox, how to set ...
by
krolikbest
[December 03, 2023, 06:38:39 pm]
Error: -macosx_version_mi...
by
Koenijn
[December 03, 2023, 06:03:37 pm]
[SOLVED] TPanel slider po...
by
Pe3s
[December 03, 2023, 05:46:45 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Query with no result (Read 361 times)
Miflon
New Member
Posts: 10
Query with no result
«
on:
August 26, 2023, 02:26:01 pm »
Hi every one.
W10 win64; Lazarus 2.2.2; fpc 3.2.2; postgresql
What is the postgresql error code when a query returns no result?
Thanks for your replies.
Logged
Чебурашка
Sr. Member
Posts: 487
СЛАВА УКРАЇНІ! / Slava Ukraïni!
Re: Query with no result
«
Reply #1 on:
August 26, 2023, 03:03:35 pm »
There is no error as it is normal that certain queries have 0 records of result. Simply you have to check query.EOF before accessing the fields of the result.
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
TRon
Hero Member
Posts: 1852
Re: Query with no result
«
Reply #2 on:
August 26, 2023, 04:59:46 pm »
As stated by Чебурашка, there is no error code returned because a query returning zero results is perfectly valid so use the suggested method or alternatively you could use
IsEmpty
Logged
Miflon
New Member
Posts: 10
Re: Query with no result
«
Reply #3 on:
August 27, 2023, 10:46:20 am »
Thanks to you both. I think I'l do a try to IsEmpty.
«
Last Edit: August 27, 2023, 10:48:17 am by Miflon
»
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Query with no result
TinyPortal
© 2005-2018