[Gambas-user] Error ODBC

Christof Thalhofer chrisml at deganius.de
Wed Jul 14 10:39:31 CEST 2021


Am 14.07.21 um 09:51 schrieb Hans Lehmann:
> Am 13.07.21 um 17:20 schrieb Christof Thalhofer:
>> Can you tell the number of 'DbResult.Count'?
> 
> 1
> Lutz Lama ---▶ 1989-02-25
> 
> 
> Obviously dbResult contains only one data set. But why?

It should depend on your query or your data. Are you really sure your 
query delivers more than one tuple?

Just try queries like that directly on the sqlite database on the 
commandline:

"SELECT vorname, nachname, gebdatum FROM contacts
WHERE id < 7"

or

"SELECT count(id) FROM contacts
WHERE id between 4 and 7"

Alles Gute

Christof Thalhofer

-- 
Dies ist keine Signatur

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 840 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20210714/1dc40509/attachment-0001.sig>


More information about the User mailing list