Search:

Basically the same discussion:
https://www.vbforums.com/showthread.php?889125-vb6-how-use-an-user-type-parameter-on-a-class-function-sub

Huh? Didn't know that one.
Now, the interesting question would be: Does this work with a "SELECT....INTO....." Statement?

Aircode-Algorithm
Source-File: source.txt
Target-File: target.txt
Do...

DM, here is the original Thread: https://www.vbforums.com/showthread.php?891128-Very-complicated-but-perhaps-possible!
If you look at my aircode in Post 16, you'll see there is a line with...

Is it a Public Function in a Standard Code-Module?

Well, there we go.
it‘s now on him

Would it explain why he fails in DB-Browser?

He‘s using RC5
See post #11

Holy smoke! Yes, i remember High-school, too.
End of the eighties "Computer Science" was an elective for the last 2 years
Yeah, laugh it up: "Computer Science" with, IIRC, three XT-Machines with 5...

Try it as a single line


SELECT DISTINCT T1.aut, T2.remain FROM trans As T1 LEFT JOIN (SELECT Aut, ID, remain, Acquit, ROW_NUMBER() OVER(PARTITION BY item_id ORDER BY Aut DESC) AS RN FROM Trans)...

There is already one: https://www.vbforums.com/forumdisplay.php?74-Other-Programming-Languages

So it works?

I advise against such a migration-tool.
FPC/Lazarus has such a slew of options you can use to improve your vb-code.
Yes, start with a simple project, and port it, but "rewrite it" in a way.
Yes,...

Porting not that much, since i'm not (and never was) a professional dev.
Mainly stuff i use at work, which were Excel-VBA-things that i moved/ported to Lazarus.

@easier/harder: Funny enough:...

Eh?
True.
It's time for some offtime..... overworked, underjumped, the whole slew......

*groan**facepalm*
Missed that one
I actually used Arnout's CREATE TABLE/INSERT INTO Statements to create my sample data

bruahahahahahahahah
rotfl

Strange.
I did that Query in DB-Browser for SQLite (sqlitebrowser.org), and it worked.
Maybe you have a typo or missing blank/comma somewhere
Could you try to run that query in a DB-Tool like mine?

Done in SQLite

SELECT DISTINCT
T1.aut,
T2.remain
FROM
trans As T1
LEFT JOIN
(SELECT Aut,ID, remain, Acquit,ROW_NUMBER() OVER(PARTITION BY item_id ORDER BY Aut DESC) AS RN
FROM Trans)...

As i understand it, the Standard-TButtons don't like coloring in Lazarus under Windows
Look at reply #2
https://forum.lazarus.freepascal.org/index.php/topic,53897.0.html

btw: I don't think we...

I'd advise you to register yourself at the official Lazarus-Forum.
I'm registered there myself. The people there are pretty laid back regarding newcomers to Lazarus
I did the transition away from...

Agree with Gary, but the UseCase for unique combinations in Detail-Tables is a given.

e.g.:
Master-Table holds information about a employee
Detail-Table holds information about phones issued to...

Sorry, don't understand the requirement

Huh?
Any chance to upgrade to at least 5.7 or 8?
Otherwise:
Create a View from the INNER SELECT_Statement (since it doesn't have parameters/dynamic filters)
the you can address that view as any...

Works in SQLite. No Idea if you have to change anything for MySQL

SELECT DISTINCT
T1.asset_id,
T2.meter_reading,
T2.reading_date
FROM
source_table T1
INNER JOIN
(SELECT

What i could find out: There seems to be the fact, that "Shell Icons" is missing sometimes in the Registry.

Have you thought about
1) Query Registry for that Key
2) If Error (Key not present)...

ZIP it first, click on "go advanced" then on manage attachments

On first glance this looks like a case for ROW-NUMBER() OVER(PARTITION BY asset_id ORDER BY reading_date DESC) As RN
with a Filter in the WHERE-clause RN<=2

Do have sample-data as a csv?

Maybe you have a pending Commit somewhere earlier?

btw: I have no idea how Olaf implemented the Synchronous-Property, but in "pure" SQLite, Synchronous is a PRAGMA-Call (which is basically the...

For vb6? Not that i know of.
I know that it's available in other Languages (in my Case Lazarus/FreePascal), but for vb6.... *shrug*

A modulation or pitch bend is an Effect.
And the "classic" way (a.k.a. at a mixing console) to deal with Effects is to never change the original signal, but additionally sending the original signal...

So what he basically wants, is a ListView in report-style married with a TreeView.
The (multicolumn) TreeView would be the "Parent", while the (multicolumn) ListView would be the "Detail"

You don't call ShellExecute in your Sub

What about the "standard" template (normal.dot)?
Corrupted?

AFAIK, The Database-Format itself (in your case the Database-File) has nothing to do with Bitness of Access, only with Version of Access

https://www.fmsinc.com/MicrosoftAccess/history/features.htm

IIRC, a Function-Argument in a Do-While-Loop is executed everytime, so in your case i'd go for a


Do While FileExists(FileName)
'DoSomething and check "next" FileName, count up your Counter...

Wrong Forum. This belongs at Database

To your Question: Which DBMS?

At first look:
There is a reason i dislike "Dim MyArray(101) As Integer"
A "Dim MyArray(0 To 100) As Integer" is more clear in regards to your requirement.
Then your test against it is just "If...

Uhhh.... start learning SQL?


SELECT
cod,
SUM(quantity) As qty
FROM
MyTable
GROUP BY
cod

IIRC, the Activate-Event fires when a Form gets the Focus (back).
So as the others said: you need a flag preventing the Code in the Event to run.

I don't like global variables, so another...

I know why i love the "grep"-Tool on Linux....
As jdc recommended: "grep" for something static and known (like a Caption of a Form)