PureBasic Forums - English

5 years and still going.

Forum threads for PB have a longer lifespan than most JavaScript frameworks.

Have you tried using the Regular Expression library?

https://www.purebasic.com/documentation ... index.html

There's a post in the Visual Studio forums for nearly the exact same error in Visual C++ code: https://social.msdn.microsoft.com/Forums/vstudio/en-US/4a571217-1f3b-44cc-adb2-96cf39c876e3/lnk4229-warnings?forum=vcgeneral

The answer there is that there is a bad pragma comment: https://docs.microsoft ...

If the Contact Types are fixed then a separate join for each type will do the job. Then it's just a simple 121 mapping between query and columns.

If you want it to be dynamic you can generate the SQL. It follows a clear repeating pattern.


-- Create The Tables

Drop Table If Exists People;
Create ...

Hi GedB,

You've demonstrated how to concatenate strings in SQL but you haven't demonstrated how to marshall the contactdetails into the relevant contacttype column in a ListIconGadget. So what's the next stage, using PB to chop apart and parse subsections of the string you've just concatenated?

I ...

Hi Fangbeast,

Let me pitch a SQL approach to this problem. Creating a single string out of multiple joined lines is super easy, barely and inconvenience.

What you need is SQLite's group_concact function: https://www.sqlite.org/lang_aggfunc.html#groupconcat

I'm just going to share the SQL with you ...

skywalk wrote:
I am drooling over what v6 might offer(LLVM,ARM targets,RaspberryPI), but I still crank along nicely with all incarnations to date.

Just give us LLVM - can you imagine the possibilities?


Sent from my iPhone using Tapatalk

Format like sprintf
Link: https://www.purebasic.fr/english/viewtopic.php?f=12&t=32026


Define column.s = "Pron_1_Pers_Sg"
Define goal.s = "gender"
Define constrain.s = "Mann"

sql.s= Format("SELECT %s FROM Data where %s = '%s'", @column, @goal, @constrain)
Debug sql
;DatabaseQuery(..., sql ...

Here’s a recent video of a talk by games developer Jonathan Blow: https://m.youtube.com/watch?v=pW-SOdj4Kkk

He talks about how science and craft go into decline. He shows how this happened in the past, and how it is happening to software right now.

I’ve witnessed this happening over my two ...

Hello everyone,,
I have a form with data from SQLite. Vertically on the left I am showing all of the fields for a single record. As I can only do a Next and not a Previous in SQLite I have a ListIconGadget() to the right containing all of the records from the database showing just three or four ...

Hi Joakim,

I’ve been on a similar journey myself. I hope you have great success with TypeScript and JavaScript.

I’ve come back to PB now. The big problem I have with JavaScript are the dependencies. They’re insane.

Look at this list of 16 frameworks: https://www.google.com/amp/s/hub.packtpub ...

The problem is not Goto itself, the problem is that Goto is very often ab used , producing unreadable spaghetti code.
It's like using a sharp scalpel: an experienced surgeon knows when and how to use it properly. But when untrained people use it all the time anywhere and anyhow, nothing good comes ...

You are right and should provide validation.


Hi Gurj,

It isn’t about verification or validation. It’s about exploration.

You start with your hypothesis - the thinking you believe is correct - and look for ways to explore that hypothesis by trying something and seeing what the results are ...

gurj wrote:No, I just think that my logical thinking is right.

When optimising code the outcome can be counter-intuitive. You don't know until you have the benchmark numbers.

Interesting. Have you got any benchmarks to show the performance impact?