# Sqlite Abfrage-Problem

**URL:** <https://forum.xojo.com/t/sqlite-abfrage-problem/88162>\
**Category:** Deutsch\
**Created:** [April 27, 2026, 3:50pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162 "2026-04-27T15:50:51Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Dinse](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@Michael\_Dinse](https://forum.xojo.com/u/Michael_Dinse)\
**Post date:** [April 27, 2026, 3:50pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/1 "2026-04-27T15:50:51Z")

</div>

Hallo Ihr Lieben!

Ich habe jetzt das erste mal mit einer Splite Abfrage ein Problem!

Beispiel:

Var Tag as string

Var rs as rowset

Tag=”Hallo Welt”

sq=“select \* from Alben where Name=‘”+Tag’+“’”  
rs=db.SelectSQL(sq)

Normalerweise funktionierte das immer!!!

Plötzlich wird das letzte Hochkomma einfach nicht angenommen. Somit schlägt die Abfrage fehl.

Was kann ich tun? Ich bin wirklich verzweifelt.

---

<div class="post-metadata">

**Author:** ![Christian\_Schmitz](https://forum.xojo.com/user_avatar/forum.xojo.com/christian_schmitz/32/158_2.png) [@Christian\_Schmitz](https://forum.xojo.com/u/Christian_Schmitz)\
**Post date:** [April 27, 2026, 4:00pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/2 "2026-04-27T16:00:20Z")

</div>

Da sind drei hochkomma, eins zu viel direkt nach Tag.

---

<div class="post-metadata">

**Author:** ![Michael\_Dinse](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@Michael\_Dinse](https://forum.xojo.com/u/Michael_Dinse)\
**Post date:** [April 27, 2026, 4:24pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/3 "2026-04-27T16:24:33Z")

</div>

Hallo Christian!

Ja, Du hast recht, sorry ich bin etwas nervös

Ich habe das Hochkomma jetzt entfernt. Es sieht folgendermassen aus:

var sq as string  
var level as integer  
var rs as RowSet

Tag ist eineString-Variable

sq=“select \* from Alben where Name=‘”+Tag+“’”  
rs=db.SelectSQL(sq)  
Level=rs.Column(“level”).IntegerValue

select \* from Alben where Name='Hans  
’

Das Hochkomma rutscht einfach in die nächste Zeile???

---

<div class="post-metadata">

**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\
**Post date:** [April 27, 2026, 4:29pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/4 "2026-04-27T16:29:14Z")

</div>

![image](https://forum.xojo.com/uploads/default/original/3X/e/6/e6f2e8ec9efc3ff6eafc40ec5538a89f6406cbb0.png)

???

---

<div class="post-metadata">

**Author:** ![brian\_franco](https://forum.xojo.com/user_avatar/forum.xojo.com/brian_franco/32/156_2.png) [@brian\_franco](https://forum.xojo.com/u/brian_franco)\
**Post date:** [April 27, 2026, 4:30pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/5 "2026-04-27T16:30:43Z")

</div>

Hello @Michael_Dinse

Consider using a tool like [https://sqlitebrowser.org/](https://sqlitebrowser.org/)

It can help you find errors in SQL commands to sqlite 😁

---

<div class="post-metadata">

**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\
**Post date:** [April 27, 2026, 4:43pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/6 "2026-04-27T16:43:37Z")

</div>

This compile:

```auto

Var Tag As String
Var sq As String
Var db As New SQLiteDatabase
Var rs As RowSet

Tag = "Hallo Welt"

sq="select * from Alben where Name=" + Tag
rs=db.SelectSQL(sq)

```

---

<div class="post-metadata">

**Author:** ![Thomas\_Roemert](https://forum.xojo.com/user_avatar/forum.xojo.com/thomas_roemert/32/827_2.png) [@Thomas\_Roemert](https://forum.xojo.com/u/Thomas_Roemert)\
**Post date:** [April 27, 2026, 4:46pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/7 "2026-04-27T16:46:43Z")

</div>

Probier doch mal eine etwas modernere Syntax:

_rs = db.SelectSQL("SELECT_ \* FROM alben WHERE name = ?", Tag)

Das erspart die Mühe mit den diversen Hochkommata und härtet ausserdem die Abfrage gegen SQLInjections….

Edit: corrected syntax from SQLSelect to SelectSQL

---

<div class="post-metadata">

**Author:** ![brian\_franco](https://forum.xojo.com/user_avatar/forum.xojo.com/brian_franco/32/156_2.png) [@brian\_franco](https://forum.xojo.com/u/brian_franco)\
**Post date:** [April 27, 2026, 4:50pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/8 "2026-04-27T16:50:47Z")

</div>

@Thomas_Roemert

Excellent advice

---

<div class="post-metadata">

**Author:** ![Michael\_Dinse](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@Michael\_Dinse](https://forum.xojo.com/u/Michael_Dinse)\
**Post date:** [April 27, 2026, 5:07pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/9 "2026-04-27T17:07:46Z")

</div>

Vielen Danke, Ihr Lieben.

Der Fehler lag, wie immer bei mir. Ich habe die variable Tag, dummerweise aus, einem Textfeld mit key=chr(13) übergeben.

Trotzdem, vielen Dank an alle!!!

---

<div class="post-metadata">

**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\
**Post date:** [April 27, 2026, 5:09pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/10 "2026-04-27T17:09:45Z")

</div>

> [@Thomas\_Roemert](#):
>
> db.SQLSelect

This API 1, so 7 years old while what op code shared is API2 (SelectSQL)

Nice screen shot for the eyes:

 ![image](https://forum.xojo.com/uploads/default/original/3X/a/5/a5580a6762ffc15f718de167a880f54841604c24.png)

---

<div class="post-metadata">

**Author:** ![Thomas\_Roemert](https://forum.xojo.com/user_avatar/forum.xojo.com/thomas_roemert/32/827_2.png) [@Thomas\_Roemert](https://forum.xojo.com/u/Thomas_Roemert)\
**Post date:** [April 27, 2026, 5:27pm UTC](https://forum.xojo.com/t/sqlite-abfrage-problem/88162/11 "2026-04-27T17:27:46Z")

</div>

You’re right, I did correct the post.