• Welcome, Guest. Please login.
 
July 16, 2019, 12:36:50 pm

News:

Welcome to the SQLitening support forums!


Recent posts

Pages 1 ... 8 9 10
91
Hello Fim,

Quote
RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.


RMChart is here and still being actively used other by programming platforms like XBase++
http://www.brothersoft.com/rmchart-35638.html
92
You've got Questions? We've got Answers! / Re: SQLitening & RMChart
Last post by Fim - November 03, 2018, 06:00:36 pm
RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.
/Fim
93
You've got Questions? We've got Answers! / Re: Messages suppression
Last post by cj - November 01, 2018, 03:28:19 pm
QuoteHow can I completely suppress every error message and let the library calls fail when there is a lock timeout?
Do I need to set the mods on every call?


slSetProcessMods "r" must be after slOpen (which you have done.)
Are you sure you need T1000 (1-second) which causes the problem and no retry?
The default of 10000 (10-seconds) works well so MSGBOX shouldn't appear.

Getting rid of the T option and the pops and pushes would be my suggestion.

Anyway, playing with this code might be useful.


#INCLUDE "sqlitening.inc"
FUNCTION PBMAIN () AS LONG
LOCAL hThread AS LONG
slSetProcessMods "E0"

slopen "junk1","CT1000"  'make busy-timeout extremely small (not suggested)
slSetProcessMods "r" 'required after slOpen so busy MSGBOX will not appear

slexe "create table if not exists t1(c1)"
THREAD CREATE LockDataBase(0) TO hThread
THREAD CLOSE hThread to hThread
SLEEP 1000 'so other thread locks before we attempt insert
slexe "insert into t1 values('one')
? "Done"

END FUNCTION

THREAD FUNCTION LockDataBase(BYVAL notused AS LONG) AS LONG
slOpen "junk1"
slExe "begin exclusive"
? "transaction active",,FUNCNAME$
slExe "end"
END FUNCTION
94
You've got Questions? We've got Answers! / Messages suppression
Last post by sbirrari - October 31, 2018, 04:29:05 am
Hello,

in my application I'm using two SQLite databases. The library version is 1.60.4.
I would like to suppress every message from SQLitening (errors and lock retries), and handle all the errors in the application.

This is how I open a DB:
- slSetProcessMods "E0 T1000" (to suppress messages while opening the DB)
- slsOpen
- slSetProcessMods "rE0 T1000"
- slPushDatabase

Every time I need to use a DB:
- slPopDatabase
- slsExe/slsSel

I read in the docs that mods are pushed/poped along with the database handle, but one of my customers saw this message


How can I completely suppress every error message and let the library calls fail when there is a lock timeout?
Do I need to set the mods on every call?

Thank you,
Riccardo
95
You've got Questions? We've got Answers! / SQLitening & RMChart
Last post by Fredrick Ughimi - October 30, 2018, 07:09:24 am
Hello Everyone,

Has anyone here worked with SQLitening & RMChart?

I am currently looking to the possibility of creating charts from SQLitening Data.

96
Hello CJ,

Thank you once a again for your response and suggestions.

Quote
I am currently trying read the cell contents of MLG into individual Textboxes.


I do that all the time with Listview. I do that mostly for the purpose of editing
and saving back changes to the database through the textboxes. I guess
I don't have to do that anymore with the Grid control. Users can edit the cells of a
row directly on the grid and then save back to the database.

Saving a row to the database is now something I need to find out.

Best regards.
97
You've got Questions? We've got Answers! / Re: Auto Populate Listview wit...
Last post by cj - October 09, 2018, 01:12:14 pm
If you don't mind using .NET or VB6 here are 2 great grids.

1. PowerBASIC code can be put into a DLL and loaded from VB6.
2. PowerBASIC code can use IPC (inner process communications) to talk between programs.
https://10tec.com/activex-grid  (many, features for grouping, etc.)  2  32-bit OCX's
http://grid2000.com (lot of features, but less samples)           1 32-bit OCX

I have Spread 7 somewhere and used it a long time ago.
I checked the current price at GrapeCity and about fell over.
98
Hello Bern,

Quote
I am using SQLitening in conjunction with a grid control (Farpoint's Spread).  I usually add a hidden column or two for each row to save the rowID (and possibly other data) when populating the grid control with data.  When any of the data is edited, it's easy to look up the corresponding rowID and update the database.


Thank you for your response. I use the RowID trick with the Listview. I guess it would work with MLG as well. Listview and MLG implementations are so very different. Trying to wrap my head around MLG. So far so good.

I am currently trying read the cell contents of MLG into individual Textboxes.
99
I am using SQLitening in conjunction with a grid control (Farpoint's Spread).  I usually add a hidden column or two for each row to save the rowID (and possibly other data) when populating the grid control with data.  When any of the data is edited, it's easy to look up the corresponding rowID and update the database.



100
Hello CJ,

I finally did got a response from Gary Beene.

I want to save a selected row from MLG to SQLitening. Any ideas?

I something similar to what Mike provided a while ago on the PB Forums

https://forum.powerbasic.com/forum/user-to-user-discussions/third-party-addons/61266-mlg-questions/page2

Post #36.

Looking now at the very insightful codes Mike wrote I see that the columns are predefined. It would always not be that way in the real world.



Pages 1 ... 8 9 10