Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Columns Count in querry 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
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
Interesting video
by
backprop
[
Today
at 07:42:40 am]
If FileExists(
by
Xenno
[
Today
at 07:16:00 am]
TDWEdit
by
Ed78z
[
Today
at 06:38:28 am]
Lazarus Bugfix Release 4....
by
jamie
[
Today
at 03:51:07 am]
Death of the Power User
by
wp
[
Today
at 01:29:18 am]
IndySecOpenSSL is now ava...
by
TheMouseAUS
[
Today
at 01:02:40 am]
Implementing an Elo ratin...
by
n7800
[
Today
at 12:44:10 am]
how to add a ForEach call...
by
mas steindorff
[June 11, 2026, 11:42:24 pm]
How to define a type of ...
by
PascalDragon
[June 11, 2026, 09:24:45 pm]
Gitlab site history date.
by
Martin_fr
[June 11, 2026, 08:46:17 pm]
Arkanoid
by
lazarusprogrammer
[June 11, 2026, 08:14:21 pm]
[New Component] ExtTabCtr...
by
d7_2_laz
[June 11, 2026, 05:01:49 pm]
Conscious Artificial Inte...
by
schuler
[June 11, 2026, 04:39:11 pm]
Pdf Viewer in Pascal
by
Tomxe
[June 11, 2026, 03:52:37 pm]
Eye Candy TESCheme
by
Dzandaa
[June 11, 2026, 11:51:52 am]
P.I.S.S. a PlugIn-framewo...
by
cdbc
[June 11, 2026, 11:35:42 am]
I found an actual use for...
by
marcov
[June 11, 2026, 11:35:23 am]
Who can explain this ?
by
J-G
[June 11, 2026, 11:30:42 am]
XLibre, finally and fortu...
by
Fred vS
[June 11, 2026, 06:20:26 am]
WEBP, no DLLs
by
Tomxe
[June 11, 2026, 04:04:37 am]
Discipline your AI coding...
by
440bx
[June 11, 2026, 02:44:06 am]
Version 4.8 was recently ...
by
Ten_Mile_Hike
[June 11, 2026, 01:43:17 am]
FPC Unleashed (inline var...
by
Fibonacci
[June 11, 2026, 12:03:13 am]
Trayslate 1.3.1 - Free tr...
by
AlexanderT
[June 10, 2026, 08:12:24 pm]
TShellListView
by
Ed78z
[June 10, 2026, 07:59:41 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Columns Count in querry result (Read 1036 times)
Middlecope
Jr. Member
Posts: 92
Columns Count in querry result
«
on:
March 22, 2024, 04:25:10 pm »
openSUSE, SQLite3
How to determine the count of columns in a querry result set?
I found this in
https://sqlite.org/c3ref/column_count.html
Quote
int sqlite3_column_count(sqlite3_stmt *pStmt);
Unfortunately no instructions how to use it
Logged
rvk
Hero Member
Posts: 7045
Re: Columns Count in querry result
«
Reply #1 on:
March 22, 2024, 04:28:39 pm »
Just read out the field count from your dataset.
If TSQLQuery then TSQLQuery.Fieldcount.
You can access them via TSQLQuery.Field array.
Logged
Handoko
Hero Member
Posts: 5545
My goal: build my own game engine using Lazarus
Re: Columns Count in querry result
«
Reply #2 on:
March 22, 2024, 04:42:38 pm »
This works for me:
Code: Pascal
[Select]
[+]
[-]
Query
.
SQL
.
Text
:
=
'SELECT COUNT(*) FROM tblData;'
;
Query
.
Open
;
TotalRows
:
=
Query
.
Fields
[
0
]
.
AsInteger
;
TotalFields
:
=
Query
.
FieldCount
;
«
Last Edit: March 22, 2024, 04:44:42 pm by Handoko
»
Logged
Middlecope
Jr. Member
Posts: 92
Re: Columns Count in querry result
«
Reply #3 on:
March 22, 2024, 04:51:14 pm »
Thanks I was to fixed on the word Column that I forget to look at Field,
Sory
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Columns Count in querry result
TinyPortal
© 2005-2018