SpiderBasic 2.20 final is out !

Everything else that doesn't fall into one of the other categories.
Fred
Site Admin
Posts: 1506
Joined: Mon Feb 24, 2014 10:51 am

SpiderBasic 2.20 final is out !

Post 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
User avatar
SparrowhawkMMU
Posts: 281
Joined: Wed Aug 19, 2015 3:02 pm
Location: United Kingdom

Re: SpiderBasic 2.20 beta 1 is available !

Post 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?
User avatar
skywalk
Posts: 47
Joined: Tue Feb 25, 2014 2:13 am
Location: Boston, MA

Re: SpiderBasic 2.20 beta 1 is available !

Post 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?
When working toward the solution of a problem, it always helps if you know the answer. ~ ?
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing. ~ Weber
User avatar
Peter
Posts: 1086
Joined: Mon Feb 24, 2014 10:17 pm
Location: 127.0.0.1:9080
Contact:

Re: SpiderBasic 2.20 beta 1 is available !

Post 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
woki
Posts: 13
Joined: Tue Feb 25, 2014 7:52 pm

Re: SpiderBasic 2.20 beta 1 is available !

Post by woki »

Hello Peter,

see Help - commands index - database :)

Wolfgang
User avatar
Peter
Posts: 1086
Joined: Mon Feb 24, 2014 10:17 pm
Location: 127.0.0.1:9080
Contact:

Re: SpiderBasic 2.20 beta 1 is available !

Post 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
falsam
Posts: 280
Joined: Mon May 05, 2014 9:49 pm
Location: France
Contact:

Re: SpiderBasic 2.20 beta 1 is available !

Post by falsam »

I think the databases functions don't exist. The library database is missing.

➽ Windows 11 - JDK 1.8 - SB 2.40 - Android 13
http://falsam.com

Sorry for my poor english
woki
Posts: 13
Joined: Tue Feb 25, 2014 7:52 pm

Re: SpiderBasic 2.20 beta 1 is available !

Post by woki »

Hallo Peter,

have not tested db jet, but falsam seems to be right, the library is missing
but sql.js exists.

Wolfgang
Fred
Site Admin
Posts: 1506
Joined: Mon Feb 24, 2014 10:51 am

Re: SpiderBasic 2.20 beta 1 is available !

Post by Fred »

I forgot to build the database lib on build server, will do a beta 2 soon :)
Fred
Site Admin
Posts: 1506
Joined: Mon Feb 24, 2014 10:51 am

Re: SpiderBasic 2.20 beta 1 is available !

Post by Fred »

I just pushed a new beta 1, so just download it again and it should be fine (database included and some fixes)
Post Reply