Date   
BBCSDL poll #poll

Richard Russell
 

Have you tried 'BBC BASIC for SDL 2.0' (BBCSDL) and if so on what platform(s)?  You can select more than one answer.

Results

See Who Responded

Re: BBCSDL poll #poll

J.G.Harston
 

I've downloaded the Linux version, but haven't had the chance to reboot my PC into Linux yet. I'm planning on testing the Raspberry Pi version, but my Pi is currently being a PiTube and I don't have a minitor for it.

Re: SQLite For BBC Basic

 

Same issue from me too!
I guess there is nobody at home on this subject matter.

Re: SQLite For BBC Basic

Richard Russell
 

I expect Jon's library simply provided a wrapper around the SQLite function calls to present a rather more 'BASIC-like' interface, so whilst its loss may be an inconvenience it's not something that actually prevents the use of SQLite with BBC BASIC.

Assuming that SQLite is ODBC-compliant, which I'm pretty confident it is with the right drivers, my suggestion would be to go the ODBC route rather than to write any code which is specific to one particular database manager.  For a long time an ODBC library for BBC BASIC has been on the 'wish list' and it should not be difficult to write.  If somebody would like to volunteer to do that it would be useful, but if not I'll do it myself!

Can you confirm that an ODBC library would meet your needs?

Richard.

Re: SQLite For BBC Basic

Richard Russell
 

On Fri, Oct 13, 2017 at 05:50 am, Richard Russell wrote:
Can you confirm that an ODBC library would meet your needs?
Well?  I have confirmed that an ODBC library would be able to access a SQLite database, but if there is no interest I won't pursue it any further.

Richard.

Re: SQLite For BBC Basic

 

Many thanks Richard for chipping in on this thread.
For me yes indeed. An ODBC library would be ideal indeed.
Many thanks for the offer.

Re: SQLite For BBC Basic

 

Richard,

though at this moment I have no immediate use for the ODBC library, I definitely would have used it in the past. A year or so ago I had a need for it but had to find a simpler, less flexible/less powerfull solution to deal with my data.

I think the ODBC library really would be an asset to the BB4W programming environment in general (and for my own future programming needs)

regards,
Eddy


On Sunday, October 15, 2017, 11:26:50 PM GMT+2, Richard Russell <news@...> wrote:


On Fri, Oct 13, 2017 at 05:50 am, Richard Russell wrote:
Can you confirm that an ODBC library would meet your needs?
Well?  I have confirmed that an ODBC library would be able to access a SQLite database, but if there is no interest I won't pursue it any further.

Richard.

Re: SQLite For BBC Basic

Richard Russell
 

On Mon, Oct 16, 2017 at 01:30 am, Edja wrote:
A year or so ago I had a need for it but had to find a simpler, less flexible/less powerfull solution
It's a shame you didn't choose to write your own ODBC library, which you could have shared with the rest of us!  From the experimentation I've done so far, ODBC is perfectly straightforward to interface with in BBC BASIC (no pesky COM/OOP functions or anything like that, just ordinary C-style functions which can be trivially converted to SYS statements).  There's lots of code examples on the web that can be translated to BBC BASIC 'methodically' without needing any understanding.

Anyway, if I write a simple ODBC library - even though anybody else could do it - would you (or somebody else) be prepared to test it?  I have no personal experience of working with databases so although I can translate the code I can't devise test routines to exercise it thoroughly.

Richard.

Re: SQLite For BBC Basic

 

Sure. Just sling it across and I shall try and fit in some time to test it.
Cheers,
Chandra

Re: SQLite For BBC Basic

 

Richard,

It's a shame you didn't choose to write your own ODBC library .....

It was not so much a matter of choice. The idea of using a database approach to solve my problem never came out of the conceptual stage. I seem to remember that I searched for SQLLite, found some bits and pieces but no (clear) documentation and/or programming examples. Pls. don't take this all too literally, this is already a distant memory. But bottom line : at the time this potential solution, that never came to fruition,  was way above my programming skills and I resorted to a simpler solution being a file reading/writing approach in conjunction with Excel with the help of COMLIB. And it worked fine.

would you (or somebody else) be prepared to test it?
Short answer : Yes
Long answer : 

I have never worked with SQL, databases (yes, once, but it was not a success), ODBC and the likes. I wouldn't know where to start. I occasionally use a saw and a screwdriver. That doesn't make me a carpenter. The same goes for my programming skills. Sometimes I surprise myself by writing a really nice program. But all in all you would be horrified looking at my code. On the bright side :  I'm having fun.
All the above just to make you aware  that, while I'm prepared to help out in testing the ODBC library, you may end up disappointed. Therefore others better participate to come to useful test results.


FYI :  I have Excel 2007 and LibreOffice Base on my PC. No Oracle or other sofisticated databases.

Eddy

Re: SQLite For BBC Basic

Richard Russell
 

I disagree, but it won't achieve anything to argue the point.

I've uploaded an initial attempt at a library (ODBCLIB.BBC), and a test/demonstration program (ODBCTEST.BBC), to the Files area of this group as odbclib.zip.  I should say that two days ago I had not the slightest idea about databases and how to access them, so these have been cobbled together in a very short time from information gleaned from the web (which luckily is extensive).  Literally anybody could have done this.

Richard.

Re: SQLite For BBC Basic

 

Hi Richard,

Many thanks for your efforts thus far on this.
Will take a look at the library over the weekend when time permitting.

Regards,
Chandra

Re: SQLite For BBC Basic

Richard Russell
 

On Tue, Oct 17, 2017 at 07:48 am, Richard Russell wrote:
I've uploaded an initial attempt at a library (ODBCLIB.BBC), and a test/demonstration program (ODBCTEST.BBC), to the Files area of this group as odbclib.zip
Naturally I would encourage as many people as possible to try this.  Even if you have no immediate need for (or interest in) accessing a database, it would be helpful to know whether it works for you, and whether you find the explanation clear and the library easy to use.  The ODBCTEST program includes instructions for downloading a test database and installing the necessary SQLite3/ODBC driver.  Needless to say you will need admin privileges to copy ODBCLIB.BBC into your BB4W LIB folder (if you copy it using Windows File Explorer, with UAC enabled, it will prompt you for permission).

Richard.

Re: SQLite For BBC Basic

 

Richard,

I've downloaded ODBCLIB.BBC and ODBCTEST.BBC to the right directories. I've then downloaded the chinook.db from http://www.sqlitetutorial.net/sqlite-sample-database/ and the SQLite ODBC driver 'sqliteodbc.exe'  from  http://www.ch-werner.de/sqliteodbc. All as per your instructions.
I then executed ODBCTEST.BBC, typed in the path name to chinook.db ..... and it  all worked fine.

Just a warning to others who may participate in the testing. As I have Win64 installed, I've first downloaded the 64-bit driver  sqliteodbc_w64.exe. This may seem logic at first, but it didn't work. So I've re-checked your instructions and loaded the 32-bit driver  'sqliteodbc.exe' . This one worked first time.

OK, so far, so good. I will now go through the tutorial on http://www.sqlitetutorial.net/
Together with your REM comments in the test program, the tutorial should help me figure out what the test program does and moreover what kind of testing would be helpful.

 

Eddy

Re: SQLite For BBC Basic

Richard Russell
 

On Thu, Oct 19, 2017 at 03:43 am, Edja wrote:
As I have Win64 installed, I've first downloaded the 64-bit driver  sqliteodbc_w64.exe. This may seem logic at first, but it didn't work.
Yes.  BB4W is (of course) a 32-bit application so needs 32-bit DLLs and drivers.  Fortunately Windows provides excellent support for 32-bit applications (with no plans to remove it, unlike certain other OSes!).  It's worth remembering that Visual Studio is a 32-bit app!

> I will now go through the tutorial on http://www.sqlitetutorial.net/

I am personally unclear how 'universal' SQL commands are, and therefore whether you can assume that native SQLite3 commands documented there will always be identical to the 'DBMS agnostic' SQL commands accepted by ODBC.  I did wonder whether I should prefix the library function names with SQL rather than ODBC and would welcome your opinion on this.

Richard.

Widor Toccata

Richard Russell
 

Another blast from the past. This is BBC BASIC for SDL 2.0 performing Widor's Toccata, as originally transcribed for my Z80 Music Program by David King (dated February 1981); it is best appreciated with good bass speakers! I will include it with the next release of BBCSDL.

Richard.

Re: Widor Toccata

Ric
 

A blast from the past is right😃 sounds like the music of my childhood, including The Black and White Tag (Repton) etc.....

Ric

----- Reply message -----
From: "Richard Russell" <news@...>
To: <bb4w@groups.io>
Subject: [bb4w] Widor Toccata
Date: Fri, Oct 20, 2017 13:49

Another blast from the past. This is BBC BASIC for SDL 2.0 performing Widor's Toccata, as originally transcribed for my Z80 Music Program by David King (dated February 1981); it is best appreciated with good bass speakers! I will include it with the next release of BBCSDL.

Richard.

Extracting emails

as7200@...
 

I want to extract emails and place them them in access. This is a project for work where we use outlook.
Is this possible using BBC Basic for windows?

Re: Extracting emails

Richard Russell
 

On Fri, Oct 20, 2017 at 02:35 pm, <as7200@...> wrote:
I want to extract emails and place them them in access. This is a project for work where we use outlook.
Is this possible using BBC Basic for windows?
I'm not familiar with how Outlook stores emails, but assuming the file format is documented (or you can discover it by experiment) it sounds straightforward enough.  Remember that one of the strengths of BBC BASIC is that it can handle any file format.  Access is definitely accessible (!) via ODBC so the new library should be suitable for that.

Richard.

Re: Extracting emails

as7200@...
 

Presumably you could access excel in the same way. I have just looked up what ODBC means. I need a driver and need to learn SQL.
This may take a while i think.
Thank you for pointing me in the right direction.