Search:

Don't use a SELECT-Recordset to update stuff
Untested


db2.Execute("UPDATE CLIENTI SET RAG_SOC='PIPPO' WHERE CODICE='100'", dbFailOnError)

"Fool of a Took" :D

Yes, your Problem are the NULL's

Question: In your Data, is it possible, that both "Control"-Fields are NULL at the same time? Or that both are NOT NULL? Or MUST one of them be NOT NULL?
Because...

I'm calling your "only advantage of a dictionary" and raise "you have to set an error-trap for the collection in case you add a key which already exists in the collection" :D
and i'm going all in...

You sure?
I think to remember, that the Collection-Class of VB6 is a double-linked-List, and a binary tree only makes sense if the user DOES provide a Key, and wants to access the collection-items...

Well, adding to it:
2D-Lookup-Array comes to mind immediatly (no ext. references needed, either):
1st Dimension: Name of Month
2nd Dimension: Season


Dim LookupArray(1 to 12, 1 To 2) As String...

Rediscovered this one recently


https://www.youtube.com/watch?v=q8ir8rVl2Z4

CultureInfo missing as second argument in ToString?

What Type is rs.Zins?

You don't. A double is a numeric float value. Period.

Because you are overwriting it
(untested)


If text1(Day(Rs!Cal_ID)).Text = "" Then
text1(Day(Rs!Cal_ID)).Text = "Period" ...blablablabla
Else
text1(Day(Rs!Cal_ID)).Text =...

You should know your own Data.
"2" refers to Afternoon

EDIT: Here's an updated version of how i would do it
https://www.db-fiddle.com/f/gbu7v9msesk9qxBLQKSEtU/1

btw: Which DBMS are you using?
My Example was for SQLite

EDIT: And your sample is wrong.
According to your INSERTS, you don't have any appointments in the evening

1) You don't need to separate Slot_time and Worktime. Those belong together in one Table
2) You need a "Calendar-Table". You will have days where there is no appointment set, yet
3) You need a Left...

Didn‘t we have that some weeks ago, where I presented a Regex solution?

…. and nevermind using a loop in the frontend if you can let sql do it.

that is: if it’s not Access…

At a guess: to avoid „versioning“ of the interface.
a once defined interface should stay immutable, so in your case: if user wants to access GetMetrics in Font1, return the „original“

And that’s the problem: there is none, since you sum up everything
this is not making any sense whatsoever

that said: i‘m on vacation the next 10 days

I‘m out. Wanted to give him another chance, but he should know by now, that
“doesn’t work“ is not an error message or a problem description

whipped up a small sample
There is also a Query inside

Just looking at his image above, why has noone told OP that his setup is wrong?
and even his explanations are crystal clear: it’s a „1:m“ scenario

master table GENERATIONS
1. Detail table SETS...

if you want to see totalpayment just leave out the WHERE…. =0 of your query (not mine)

Leave out the left join, remove tbl_student, and select directly FROM SP

i‘m currently out of office and preparing for a 10 day vacation.
no idea if i‘ll be able to look at it

EDIT: Found it....

Really?
I was under the impression, only "Objects" (Classes) can have Properties

Color me surprised.
Since when can you do a
Private Property Get in a BAS-Module?!?!?!

More or less my question, too.
What defines which 4 cards to be a set?

EDIT: Coming from a Poker-Cards-Deck:
You need a qualifier which defines which cards belong to which set
1) "i have all 4...

OK, i did a Test with my Data, and added Adam Sandler to Physics with Steven Spielberg (duplicate Subject, but different teacher).
Returns correct Sum

Same with teacher.
So no idea what you're...

You do realize that in your post you’re talking about teachers, but the query is for students?

not possible.
how do you want to get the fully paid teachers, when you want the SUM across teachers?
same with students.

this will only work, if you ignore teachers/students to receive a total...

TimeValue expects a (quoted?) Time-String

OK, got a few minutes to look at it

Students

The first query above returns this (for the Values i have)



Student
SubjectName

Will be thursday, since i‘m traveling the next two days

Did you uncomment the green lines?
And you have to pass a String-Variable as the second Argument (it's byref) for TokenizePages

?!?!?!?!


WITH
SC AS (SELECT SC.Class_ID, SUM(COALESCE(SC.Price, S.SubjectPrice)*SC.NumOfSessions) As TotalPrice,
TS.TeacherPercentage, SUM(SC.NumOfSessions) As...

Uh.... wrong.....
It's called a decision-tree.
We do it pretty much every second/minute of our life

"If it rains Then take Umbrella with me Else a Coat is enough"

Computers (and in that way:...

How do you figure that????!?

well, in that case:
you know what valid "input-characters" are: digits and "delimiters"
e.g. you only want to support two valid delimiters: "-" and ","
I'd probably throw the "input-String" at...

WITH
TR AS (SELECT SC.ID, SC.Student_ID, COALESCE(SC.Price, S.SubjectPrice) AS SubjectPrice,
S.SName As SubjectName, TE.TName As TeacherName, SC.NumOfSessions,
...

I'll add to this:
This would translate as "valid": 1-5,9-7 (Note 9 left of 7)

But how to proceed from here?
Print 1,2,3,4,5 (in that order), and then?
print 9,8,7 or re-sort to 7,8,9?
...

But that's exactly what tg is alluding to:
Your drier (probably) has a "beeper" --> Drier.RaiseEventBeeper("Done")
The question is: Is your Frontend (yourself) subscribed to this event (aka are you...