Search:
Type: Posts; User: Zvoni
Search:
Search took 0.15 seconds; generated 45 minute(s) ago.
-
Do you have any concrete examples? I'm trying to wrap my mind around how a correct result might look like.
But i tend in tg's direction, too: Sum first, Join second
EDIT: I think i figured it...
-
Because there is no IPicture-Interface?
https://learn.microsoft.com/en-us/dotnet/framework/additional-apis/stdole.ifontdisp
-
I'll add to this, since i come from Lazarus/Freepascal:
Lazarus/FreePascal has your usual Controls you can place on a Form (TButton, TEdit, TLabel etc.), and they all inherit from a common...
-
@1
On the Contrary: I'd expect different behaviour
You define an Interface "IAnimal" which provides a Skeleton-Procedure "Move"
You define three classes "Dog", "Snake" and "Fish" which each...
-
Don't use a SELECT-Recordset to update stuff
Untested
db2.Execute("UPDATE CLIENTI SET RAG_SOC='PIPPO' WHERE CODICE='100'", dbFailOnError)
-
-
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?
-
-
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????!?
|
Click Here to Expand Forum to Full Width
|