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

SpiderBasic 2.20 final is out !

by Fred Wed Oct 11, 2017 3:19 pm

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: 267
Joined: Wed Aug 19, 2015 3:02 pm
Location: United Kingdom

Re: SpiderBasic 2.20 beta 1 is available !

by SparrowhawkMMU Wed Oct 11, 2017 3:43 pm

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: 35
Joined: Tue Feb 25, 2014 2:13 am
Location: Boston, MA

Re: SpiderBasic 2.20 beta 1 is available !

by skywalk Wed Oct 11, 2017 4:38 pm

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: 546
Joined: Mon Feb 24, 2014 10:17 pm
Location: 127.0.0.1

Re: SpiderBasic 2.20 beta 1 is available !

by Peter Wed Oct 11, 2017 5:54 pm

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 !

by woki Wed Oct 11, 2017 7:01 pm

Hello Peter,

see Help - commands index - database :)

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

Re: SpiderBasic 2.20 beta 1 is available !

by Peter Wed Oct 11, 2017 7:17 pm

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: 269
Joined: Mon May 05, 2014 9:49 pm
Location: France

Re: SpiderBasic 2.20 beta 1 is available !

by falsam Wed Oct 11, 2017 8:29 pm

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

➽ Windows 10 - JDK 1.8 - SB 2.20 - Android 5.5
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 !

by woki Wed Oct 11, 2017 9:15 pm

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: 1018
Joined: Mon Feb 24, 2014 10:51 am

Re: SpiderBasic 2.20 beta 1 is available !

by Fred Thu Oct 12, 2017 6:44 am

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

Re: SpiderBasic 2.20 beta 1 is available !

by Fred Thu Oct 12, 2017 7:27 am

I just pushed a new beta 1, so just download it again and it should be fine (database included and some fixes)
Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest