RealSQLDatabase

[dave_duke]

Can someone confirm this for me.

Using sqlexecute(“create temporary table test(name text)”)

Gives an error unable to open database?

I read online that this was a known bug in an old version of the sqllite libs. Has it crept into XOJO? was working ok in RS I think.

Dave

[Paul_Lefebvre]

This code seems to run fine for me:

[code] Dim db As New SQLiteDatabase

If db.Connect Then
db.SQLExecute(“CREATE TEMPORARY TABLE test(name TEXT)”)

If db.Error Then
  MsgBox("Error: " + db.ErrorMessage)
Else
  MsgBox("Table created.")
End If

End If[/code]

[Paul_Lefebvre]

@12345:@dave duke

I think Xojo should bring up in the IDE that realsqldatabase is depreciated in compile.

Deprecation warnings are only shown when you use the Analyze Project feature (in the Project menu). RealSQLDatabase does display as deprecated with a note that SQLiteDatabase is recommended instead.