SQLite Access

Post

Posted
Rating:
#1 (In Topic #2083)
Avatar
Trainee
vincedubeau is in the usergroup ‘unknown’

error trying to follow a website

Whenever I start with a new development environment the first I try is db access using SQLite. i found the following website: How To Open a SQLite connection and use it — Gambas Documentation. I typed in the code and I get the error shown in the attached screen capture. Screenshot from 2026-03-15 18-00-23.png
        
Online now: No Back to the top

Post

Posted
Rating:
#2
Avatar
Administrator
sholzy is in the usergroup ‘unknown’

Try "AS" instead of "=" in "Dim $con = New Connection"



sholzy
Gambas One Site Director

To help make creating posts and using the forum a little easier:
Tutorials - Website and forum and Playground 

To report bugs in the Gambas IDE:
Official Gambas Bug Tracker
Online now: No Back to the top

Post

Posted
Rating:
#3
Avatar
Enthusiast
GrayGhost is in the usergroup ‘Enthusiast’
do you have the SQLite Driver loaded ? Screenshot from 2026-03-15 18-43-05.png
Online now: No Back to the top

Post

Posted
Rating:
#4
Avatar
Administrator
sholzy is in the usergroup ‘unknown’
Without the database components, an "unknown identifier: connection" error would pop up.

The "syntax" error is from the line not being correctly written out, which I can reproduce by changing the  "AS" to "=".


sholzy
Gambas One Site Director

To help make creating posts and using the forum a little easier:
Tutorials - Website and forum and Playground 

To report bugs in the Gambas IDE:
Official Gambas Bug Tracker
Online now: No Back to the top
1 guest and 0 members have just viewed this.