• Welcome, Guest. Please login.
 
April 16, 2021, 09:42:08 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 - Fim

1
Many thanks for an exhaustive answer.
/Fim W.
2
Can a PDF file be stored in a database, if so how?
/Fim W.
3
Thanks for the advice and instructions. But I have decided to go another way to solve my problem, and it has gone well
4
How about this in SQlitening.bas
5
Many thanks. I should have read the manual better.
/Fim W.
6
Is there any way to find out what locks I have made with slSetRelNamedLocks?
/Fim W.
7
There is something wrong with this forum. Wise answers disappear. Recently, there was an answer that meant that a row would be added to one of the SQLitening programs. That answer has disappeared. What is going on?
/Fim W.
8
cj,
Thanks for that information
/Fim W.
9
I previously received some wise answers to my question. But they have disappeared now that I should take up the matter.
Fim W.
10
After a few changes to my program, everything works as it should. Which of the changes that corrected the error I do not know.
11
In my system, I handle all processing of a Sql database via a special IO module, a module for each table. Everything works as I had imagined. But in a special case I get error code 7. I have done some tests and it seems I do NOT get error if I make all SQL calls directly in a program without going through an io module.
I get the error after 3732 calls with function GU (get unique).

FUNKTION_GU:
'===========
'
GU_SELECT:
    slOpen TRIM$(KOM.DATABAS)
    SET_NUMMER = slGetUnusedSetNumber
    SEL_STRANG = "SELECT * FROM ART WHERE ARTNR= " + $SQ + TRIM$(ART.ARTNR) + $SQ
    SVAR = slSel(SEL_STRANG, SET_NUMMER) ' Ska ge noll
    IF SVAR <>  0 THEN
        KOM.FELTEXT = "SYSTEMFEL i ARTIO GU slSel=" + STR$(SVAR)  <<============
        GOTO SYSTEMFELHANTERING
        EXIT SUB
    END IF

Tips where to look for errors are gratefully received.
/Fim W.



12
Thank you, that looks good.
Right now I have other problems.
Will return.
13
You've got Questions? We've got Answers! / Re: slSelBind
December 29, 2019, 06:15:06 AM
Thanks,
I'll dig into this and see if I understand it.
/Fim W.
14
You've got Questions? We've got Answers! / slSelBind
December 28, 2019, 09:17:41 AM
What I'm getting is slSelBind is a method of using "Prepared Statement Object" in SQLite
In an ERP system there is something called "requirements explosion" and I have programmed it, works ok, but it takes time.
This slSel-sts is executed 220 times for a particular item:
"SELECT MTRLNR, POS, QUANT, FROM_VECKA, TOM_VECKA, SORT_1 FROM STR WHERE ARTNR =" + $ SQ + TRIM $ (ARTNR) + $ SQ + "ORDER BY MTRLNR"
Instead, I've tried this:
slFIX = slBuildBindDat ("$ SQ + TRIM $ (ARTNR) + $ SQ")
..
..
slSelBind ("SELECT MTRLNR, POST, QUANTITY, FROM_VECKA, TOM_VECKA, SORT_1 FROM STR WHERE ARTNR =? ORDER BY MTRLNR", slFIX, SET_NUMMER_TABELL (NIVA))

But it does not work, I think wrong, but I do not know what.
15
lSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.