• Welcome, Guest. Please login.
 
October 21, 2019, 02:32:35 am

News:

Welcome to the SQLitening support forums!


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

16
Quote from: cj on January 11, 2017, 07:33:03 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:

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

17
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.
18
Quote from: cj on January 11, 2017, 01:09:46 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.

QuoteNot sure, yet if there is a FREEFILE function.

There sure is. Works the same as PowerBasic.

19
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
20
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.

21
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.
22
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.
23
You've got Questions? We've got Answers! / Re: FreeBasic
November 02, 2016, 06:54: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. :)
24
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.
25
$BS is a constant that represents the ASCII character for "backspace" which is ASCII character decimal 8.
26
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.
27
Quote
#====================<[ Version 1.7 November 24, 2015 ]>====================
1. Fixed code in SQLiteningServer.BAS : ProcessRequest() and the %reqConnect handler.
    Was not adding the required data (for bytes 7-?).
2. Added new slKill function that allows a connection to be killed via program code.
3. Updated the slExeBind documentation to correct the "CN" flag in slBuildBindDat to "CE".
4. Updated code to correct error handling in slSetNamedLocks.
5. Fix for issue with slDisconnect causing lock ups (added Reset thMutex in SQLiteDisconnect).


28
Hi guys,

Version 1.70 is attached to this post. I will post it to the regular download section once you are happy with it.


[attachment deleted by admin]
29
I have not screwed around with the Rijndael Encryption code. I feel uncomfortable changing/updating that code for fear of breaking existing user databases.
30
Okay, all changes have been added to the source code. I am now updating the version numbers and will compile using PB10. I will post the zip file later today for you guys to look at.

Also, I want to ask how you feel about me putting the code base on GitHub ?