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

61
Now it is solved.
Here it is, in Swedish.

SELECT ART.ARTNR, ARTBEN, SUM(LPL.LSALDO_ANT) AS SALDO, ART.BESTPKT, PARTISTORLEK, ART.LEVNR FROM ART, LPL WHERE LPL.ARTNR = ART.ARTNR GROUP BY ART.ARTNR ORDER BY ART.LEVNR

The rest of my problems I will solve in the program not using SQL.

It had taken years to solve this on its own.
Thank you for your help.

/Fim W.


62
I will have a look at it in some days.
/Fim
63

Thank you, That looks very interesting, will look closer to it.
/Fim
64
I have two tables. One ART with all data (except inventory on hand) about all parts.
The other table is LPL with inventory on hand with one record for each part and each stock location.
Now I want a list, for each part where total inventory on hand for each part is less then the reorder point.
Is it possible to put these two SQL-statement into one statement?
SELECT PARTNO, SUM(QOH) AS QOH_SUM FROM LPL GROUP BY PARTNO
SELECT PARTNO, REORDEP, QOH_SUM FROM ART WHERE QOH_SUM < REORDP
As you see QOH_SUM a computed term and not a term in any table.

/Fim W.
65
I did not intend to have two databases open at the same time. Instead, I had thought to be able to switch between them. But thanks for the tips.
/Fim W.
66
Thanks.
/Fim W.
67
Can I have two databases simultaneously on a server, such as "Winova.db3" and "Winova-test.db3" without doing anything special on the server? In my progarm, I open one or other database. I think right?

Fim W.
68
I will test slKill
/Fim W.
69
I will test it.
/Fim W.
70
Is there any way to unlock a locked database from a client besides going to the server and stopping the service?
/Fim W.
71
In the version of SQLitening.Bas that I have, dated 24-Nov-2015 17:20, Frank's code is already inserted, but not Bern's correction.
And if I do the call as follows, I will not get a display of error message.
ANSWER = slSetRelNamedLocks ("+" + PA_NR_X, "E0", "", 0, "E0")

Thus, the problem is resolved.
Thanks for the help.
/Fim W
72
How to avoid slSetRelNamedLock displaying an error message?
I will only have a ReturnCode -11, no display.

    SlSetProcessMods ("E0")
    SVAR = slSetRelNamedLocks("+" + PA_NR_X)
    MSGBOX "SVAR=" + STR$(SVAR)

73
Cj and Bern,
Thanks for help and new ideas.
Because I have a background in COBOL, I thought of another way.
I will have a table with a record for each year, with year as a key.
In each record there are 366 groups, one for each day.
Each group includes date, week, weekday, work-free, bank-free ach daglopnr.
/Fim W.
74
Bern, Cj
Thanks a lot.
/Fim W.