sqlite

[t57042]

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

Richard

Code: Select all

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

[skywalk]

typo tim[e]out

[t57042]

thanks, I feel stupid

[skywalk]

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

[t57042]

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