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)