Page 1 of 3
SpiderBasic 2.20 final is out !
Posted: Wed Oct 11, 2017 3:19 pm
by Fred
Hi folks,
- final version is out, thanks a lot for the testing and feedback !
- beta 2 is available on your online account and brings some important fixes !
The new version of SpiderBasic is available on your online account and brings some nice new features, and many bug fixes !
Code: Select all
- Database library, based on sqlite (client side)
- Added #PB_LocalStorage support for CreateFile(), OpenFile() and ReadFile() to easily create persistent files
- Added #PB_HTTP_Put, #PB_HTTP_Patch, #PB_HTTP_Delete support for HttpRequest()
- Added ExportFileMemory() to return the full file content as a memory buffer
- Added 'End' keyword support to quit an application
Have fun and don't hesitate to report anything wrong so we can have a great release !
The Fantaisie Software team
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 3:43 pm
by SparrowhawkMMU
Local SQLite & HTTP verbs.... THANK YOU!
Update: I'll test this over the weekend.
PS - should this not be in the Announcements section rather than Topics?
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 4:38 pm
by skywalk
Nice!
But I get an error on compile: "Icon copy file failed (C:\dev\sb\)."
Where do I set/disable the Icon load?
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 5:54 pm
by Peter
Hello Fred,
Fred wrote:Code: Select all
- Database library, based on sqlite (client side)
i suppose I should be able to use the same commands as in PureBasic, right?
SpiderBasic 2.20 beta 1 Win/Lin wrote:OpenDatabase() is not a function, array, list, map or macro.
DatabaseUpdate() is not a function, array, list, map or macro.
DatabaseQuery() is not a function, array, list, map or macro.
...
Greetings ... Peter
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 7:01 pm
by woki
Hello Peter,
see Help - commands index - database
Wolfgang
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 7:17 pm
by Peter
Hello Wolfgang,
then this code works for you?
Code: Select all
UseSQLiteDatabase()
DB = OpenDatabase(#PB_Any, ":memory:", "", "", #PB_Database_SQLite)
If DB
DatabaseUpdate(DB, "Create Table SuperHeroes (Prename TEXT, Surname TEXT)")
DatabaseUpdate(DB, "Insert Into SuperHeroes (Prename, Surname) Values ('Peter', 'Parker')")
DatabaseUpdate(DB, "Insert Into SuperHeroes (Prename, Surname) Values ('Bruce', 'Wayne')")
DatabaseUpdate(DB, "Insert Into SuperHeroes (Prename, Surname) Values ('Clark', 'Kent')")
If DatabaseQuery(DB, "Select * From SuperHeroes Where Prename = 'Peter'")
While NextDatabaseRow(DB)
Debug GetDatabaseString(DB, 1) + "," + GetDatabaseString(DB, 0)
Wend
FinishDatabaseQuery(DB)
EndIf
CloseDatabase(DB)
EndIf
Greetings ... Peter
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 8:29 pm
by falsam
I think the databases functions don't exist. The library database is missing.
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Wed Oct 11, 2017 9:15 pm
by woki
Hallo Peter,
have not tested db jet, but falsam seems to be right, the library is missing
but sql.js exists.
Wolfgang
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Thu Oct 12, 2017 6:44 am
by Fred
I forgot to build the database lib on build server, will do a beta 2 soon
Re: SpiderBasic 2.20 beta 1 is available !
Posted: Thu Oct 12, 2017 7:27 am
by Fred
I just pushed a new beta 1, so just download it again and it should be fine (database included and some fixes)