PureBasic Forums - English

Posted: **Mon Dec 18, 2017 5:21 pm**

Why is this not working?
I want to set the busy_timeout, but I can't even read it!
searched whole day.

Richard

UseSQLiteDatabase() 
OpenDatabase(0, "test.db", "", "")
DatabaseQuery(0,"pragma busy_timout")
While NextDatabaseRow(0)
  col$= GetDatabaseString(0,0)
  Debug col$
Wend

Posted: **Mon Dec 18, 2017 5:30 pm**

typo tim[e]out

Posted: **Mon Dec 18, 2017 5:54 pm**

thanks, I feel stupid

Posted: **Mon Dec 18, 2017 6:19 pm**

Why are you altering the timeout?
My defaults to 20sec, which handles antivirus locks or scans of database.
Do you need to timeout faster?

Posted: **Mon Dec 18, 2017 6:36 pm**

When the timout is too high i have to wait too long while testing.
It has to be set each time the database is connected.

I am playing with multiple users.
I know Sqlite is not made for multiuser use but am trying it anyway.
I use MariaDB (mysql) as well, but would like to have a "serverless, zeroconfiguration db", capable of concurrency)

I have it working in harbour, so it should work in Purebasic as well.

When I have it running I'll post a demo
regards

R. Peeters

PureBasic Forums - English

sqlite

sqlite

Re: sqlite

Re: sqlite

Re: sqlite

Re: sqlite