SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

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

Pages: [1] 2 3 ... 31
2
General Board / Re: Forum just moved to new web host
« on: April 04, 2018, 04:14:27 PM »
You're welcome guys. It's great see Fred's awesome work continue to live on.

3
General Board / Re: Forum just moved to new web host
« on: April 03, 2018, 05:58:31 PM »
Perfect! Thanks
Had some issues with the main planetsquires site but overall the movement of sqlitening to the new site was pretty painless.

4
General Board / Forum just moved to new web host
« on: April 02, 2018, 01:01:17 PM »
I finished moving the forum to a new web host. This forum is now served as a subdomain of PlanetSquires.
http://www.sqlitening.planetsquires.com/index.php

If you find any problems then please let me know. I think that you might have to re-upload any custom avatars that you were using. The attachments should be okay.

5
You've got Questions? We've got Answers! / Re: Many Insert's
« on: March 05, 2018, 02:05:07 PM »
If I were to take a guess... I bet you need to wrap all of the inserts into one begin/end transaction. That should speed things up immensely even more so than the compilation time of the sql statement.

6
I never use NULL either. I find that it complicates things unnecessarily.

7
General Board / Re: Is Fred OK?
« on: March 11, 2017, 10:53:40 PM »
Thanks for sharing the link. Fred was truly a great man. Greatly missed indeed.

8
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.

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

10
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

11
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.

12
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

13
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.

14
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.


15
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

Pages: [1] 2 3 ... 31