PureBasic Forums - English

the.weavster

Valentina Studio Pro has a Black Friday promotion on at the moment, you can get the universal version (Linux, Mac & Windows) for $200. https://www.valentina-db.com/images/valentinastudio/8/vs_report_editor_empty_sm.png Valentina Studio Pro enables you to visually design database reports, then e...

the.weavster

Don't overlook the fact SQLite's date functions are available to you

the.weavster

the first new library we are integrating for 6.10 is the WebView one

the.weavster

infratec wrote: ↑Thu Nov 09, 2023 9:31 pm
the.weavster wrote: ↑Thu Nov 09, 2023 12:06 pm Ooh, I missed that. Fingers crossed for a WebViewGadget
Here you are:
viewtopic.php?t=75898&start=135

Thanks but that looks like it's only for Windows.

the.weavster

skywalk wrote: ↑Wed Nov 08, 2023 4:04 pm Fred already said the next PB version will be feature driven.

Ooh, I missed that. Fingers crossed for a WebViewGadget

the.weavster

Did you have to do anything to make the Raspberry Pi boot from USB?

the.weavster

In the code above I've used a fixed-length string as the index but it's occurred to me you could abbreviate that too by using the name of the parameters instead, so you might end up with a json array like this:

Code: Select all

[
["XY", 10, 25],
["FRX", 100, 255, 350]
]

the.weavster

I think you can do it by using blocks of memory, you just need a little index to record which parameters are set: * edit - now revised to use a conventional structure rather than blocks of memory * #val_F = 0 #val_I = 1 #val_J = 2 #val_R = 3 #val_X = 4 #val_Y = 5 Structure fijrxy List k.b() List v.i...

the.weavster

mk-soft wrote: ↑Tue Oct 17, 2023 5:19 pm After a long search ... URI must be enable

Great work

Thank you both

the.weavster

I just tried this on my Windows PC and it's not working there ( db is zero and DatabaseError() returns an empty string ) :cry: That was the outcome I originally got on my MX Linux PC but it suddenly started to work and now it never fails but I have no idea what unblocked it :? It's not an unprintabl...

the.weavster

I just tried this again and it appears to be working now.
I don't know what's different

I initially copied and pasted the connection string from SQLite's web page and I think maybe it had picked up some unprintable character

Has anybody else tested it?
Is db > 0 for you?

the.weavster

db.i = OpenDatabase(#PB_Any, ":memory:", "", "", #PB_Database_SQLite) I don't think that works in a multi-threaded environment. It's not safe to share a connection between threads and if you do the above with separate connections they don't share the same database.

the.weavster

Why doesn't this work?:

Code: Select all

UseSQLiteDatabase()

db.i = OpenDatabase(#PB_Any, "file:memdb1?mode=memory&cache=shared", "", "", #PB_Database_SQLite)
Debug db

If db
  CloseDatabase(db)
EndIf

This on SQLite in-memory databases.

the.weavster

You could always consider using an in-memory sqlite database as an alternative to maps and structures if your sorting needs are complex.

the.weavster

Little John wrote: ↑Wed Sep 27, 2023 8:43 am That is a very special way of reading a text file, since the loop will stop reading at the first empty line.

You're right ...

Code: Select all

text.s = ""
If text
  Debug "true"
Else
  Debug "false"
EndIf

PureBasic Forums - English

Search found 1529 matches

Re: 2023 is almost over, is there a PureBasic Report Writer yet?

Re: Some date functions supporting also dates prior to 1970

Re: Blog post !

Re: PureBasic Pro

Re: PureBasic Pro

Re: Raspberry PI4 and SSD

Re: Different structures in LinkedList

Re: Different structures in LinkedList

Re: SQLite in-memory database

Re: SQLite in-memory database

Re: SQLite in-memory database

Re: SQLite in-memory database

SQLite in-memory database

Re: Sort a list alphanumerically

Re: A Walrus :=