Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Paul Squires

Pages: [1] 2 3 ... 31
1
General Board / Re: PowerBASIC has been sold!
« on: February 01, 2017, 03:51:18 PM »
Hey, some good news....finally. I'll be watching with hope and fingers crossed for a new beginning for the product.

2
I would also like to hear these stories! Hopefully SQLitening is being used in many different ways.

3
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 12, 2017, 02:48:46 PM »
cj, I believe that I am using the 1.70 source files as per this post: http://sqlitening.com/support/index.php?topic=9427.0

4
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 11, 2017, 10:10:31 PM »
I have edited Post #7 http://sqlitening.com/support/index.php?topic=9635.msg25492#msg25492

Corrected libSQLitening.dll.a import file. Recompiled all DLL's and EXE's. Downloaded latest sqlite DLL. Created a FB port of ExampleB.bas example file.

5
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 11, 2017, 06:21:07 PM »
Thanks, Paul.
Made changes to above source.

I'm trying to get rid of the warning implicit conversion

SUB showit(s AS STRING)
 DIM hFile  AS LONG
 DIM sFile  AS STRING *32
 sFile = "test.txt"
 hFile = FREEFILE
 OPEN sFile FOR OUTPUT AS #hFile
 PRINT #hFile, s
 CLOSE #hFile
 hFile = ShellExecuteA(BYVAL 0, "open", BYVAL sfile, BYVAL 0,BYVAL 0,sw_normal)  'implicit conversion
END SUB

rem FUNCTION ShellExecuteA(BYVAL hwnd AS HWND, BYVAL lpOperation AS LPCSTR, BYVAL lpFile AS LPCSTR, BYVAL lpParameters AS LPCSTR, BYVAL lpDirectory AS LPCSTR, BYVAL nShowCmd AS INT_) AS HINSTANCE

Here is one way to fix it:
Code: [Select]
SUB showit(s AS STRING)
 dim as HINSTANCE hInst
 DIM as long hFile = freefile
 DIM as string sFile = "test.txt"
 OPEN sFile FOR OUTPUT AS #hFile
 PRINT #hFile, s
 CLOSE #hFile
 hInst = ShellExecute(BYVAL 0, "open", BYVAL sfile, BYVAL 0,BYVAL 0,sw_normal)
END SUB

6
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 11, 2017, 06:13:03 PM »
I recompiled all sqlitening source and downloaded the latest sqlite.dll so at least now everything is 100% current for the testing.
If you are running in local mode then I believe you need to issue a:
slSetProcessMods("E0")
Otherwise the popup error box message will display when sqlitening attempts to issue the slExe on an sql statement.

7
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 11, 2017, 03:22:44 PM »
Not sure how to get rid of the console flashing for a second.
Use the compiler switch "-s gui" (without the quotes of course). This sets the application to use gui rather than console.

Quote
Not sure, yet if there is a FREEFILE function.
There sure is. Works the same as PowerBasic.


8
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 11, 2017, 03:16:56 PM »
Hi guys, thanks for the posts and followup information. Appreciate it. I will get slRunProc implemented.

i also noticed that linking failed when slClose is used in my code. This might be similar to the slDisconnect issue. Maybe I need to regenerate the libsqlitening.dll.a linking file. I will look at that.

An easy way to work with FreeBasic is to use my WinFBE editor. That's what I am using for all my FB projects now.
https://github.com/PaulSquires/WinFBE/releases

I am trying to create enough test code that all of the sqlitening functions are covered and working correctly. Also, if you need code that emulates all of PowerBasic's awesome string handling then take a look at my ANSI versions (search my forum for FF_JOIN for example), or use the unicode enabled versions that are packaged with Jose Roca's CWindow package (also found in my forums). http://www.planetsquires.com/protect/forum/index.php?board=39.0

9
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 10, 2017, 08:25:38 PM »
Conversion to FreeBasic done (well, about 99% done). I have not converted the slRunProc function yet because, quite frankly, I don't yet totally understand the calling parameters.

The attached package contains the FreeBasic Include file, called "SQLiteningFB.bi"

You will need to ship the universal dll with your applications SQliteningU.dll, in addition to SQLitening.dll and SQLite.dll

Also in the package are two library import files libSQLitening.dll.a and libSQLiteningU.dll.a. You need to copy those to the \lib\win32 folder of your FB installation or you won't be able to compile without errors. You do not ship those files with your application. They are only needed for compiling.

I have included an FB version of the ExampleA.bas test code so you can see that everything works in local and remote modes.

Please let me know if you come across anything that doesn't work correctly.

EDIT: Jan 11, 2017:  Corrected libSQLitening.dll.a import file. Recompiled all DLL's and EXE's. Downloaded latest sqlite DLL. Created a FB port of ExampleB.bas example file.


10
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 09, 2017, 10:43:07 PM »
Firstly, I am going to try to get it working just using a standard console window. From there it is trivial to put it into FireFly.

11
You've got Questions? We've got Answers! / Re: FreeBasic
« on: January 09, 2017, 10:10:53 PM »
I am working on a FreeBasic version now. Just need to modify the include file and get it to work with the universal version of sqlitening. Also need to create the .a linking file. I will report back once I get this all working.

12
You've got Questions? We've got Answers! / Re: FreeBasic
« on: November 02, 2016, 04:24:06 PM »
I haven't used SQLitening with FreeBasic. It would be nice to have an interface to FreeBasic, I just haven't had an overriding need to work on such a beast. :)

13
Unless you can get SQLitening to work using Wine under Linux then you might be out of luck trying to get it to work in Ubuntu.

14
You've got Questions? We've got Answers! / Re: Sqlite Password in slOpen
« on: September 24, 2016, 08:44:14 AM »
$BS is a constant that represents the ASCII character for "backspace" which is ASCII character decimal 8.

15
You've got Questions? We've got Answers! / Re: Sorting before loading
« on: April 04, 2016, 06:01:18 AM »
It does not matter. I would load the data and then create the index. Sorting the data first may actually slow down the process because SQLite uses btree indexes and indexing already sorted data is inefficient for btree indexing.

Pages: [1] 2 3 ... 31