Studio Stable Database works with our SQLite Extension
Today I tested it. I can install my SQLite extension by simply copying the extension file into the extensions folder. Once that is done, I can use the SQL commands and enjoy my functions.
See this example code which connects to a local server and performs the UsernameMBS function:
Sub Open()More information here: studiostable.com/Database.
dim address as string = "127.0.0.1"
dim port as integer = 3100
dim applicationName as string = "TestApp"
dim password as string = "test" // this is the server password.
// connect to SSD Server
dim ssdb as new SSDatabase(address, port, applicationName, password, false)
if ssdb.Connect then
// run a function
dim r as SSRecordSet = ssdb.SQLSelect("select UserNameMBS()")
if r<>nil then
// show result of function
MsgBox r.IdxField(1).StringValue
else
MsgBox ssdb.errorMessage
end if
else
MsgBox ssdb.errorMessage
end if
End
PS: There is a special offer available this week (until 27th February) for the license with source code. Maybe a good chance?
With source code you can modify the whole server to your needs.