Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
Ad Blocking Detected
Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us).
Hi all I'm trying to create a query that lists a group of records only when the last record of the group doesn't have a specific field value (trans<>'delete') (I showed the list here grouped by access, ordered by access, date)
In my other sql attempts, I'm only able to get the Delete row. SQL for Paradox tables seems to make this a difficult task. Any help is appreciated. Thank you
Thanks for the quick response Hans. Yes, Paradox is -old- and I have requested this database go to SQL Server long ago, but politics is slow... That query in SQLite does work, but, unfortunately, Paradox sql can't do that
The issue is the sub-query (at least). Paradox sql does sub-queries but doesn't treat the sub-query as a group the way SQLite does in that construction. The sub-query results are just individual records, so removing a "Delete" transaction is just 1 record
ReplyQuote
Ad Blocking Detected
Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us).
Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us).
Media Player Classic My favorite media player for Windows - light weight and supports all common video formats.
Security Awareness Tip of the Day Great resource to make you online-life more secure - definitely some great tips here and a recommended read.
NCH Software - WavePad Awesome Audio editor (from audio and even video files!), free for home use, available for Windows, MacOS X, iOS and Android.
Packages Great tool for MacOS X developers, to create your own installer packages (free).
Lubuntu A Ubuntu variant aimed at being small and fast. Love it!
ForkLift Great tool for FTP, SFTP, remote editing of text files (through SSH) and even a great Finder replacement - Not free, but keep an eye on special offerings (I got my copy for $5)
Links Page These and more of our favorite links can be found on the Links Page.
New Downloads
ConnectMeNow4-v4.0.9-macOS-arm64.dmgDate: 2023-05-28 - Size: 2.6 MBVersion 4 of ConnectMeNow - A tool for more convenient mounting of network shares under macOS. This is the Apple Silicon version (not suitable for Intel).
ConnectMeNow4-v4.0.9-macOS-x86-64.dmgDate: 2023-05-28 - Size: 3 MBVersion 4 of ConnectMeNow - A tool for more convenient mounting of network shares under macOS. This is the Intel version which works on Intel and Apple Silicon Macs.
MovieScanner2-2.2.3-Windows-32bit-setup.exeDate: 2023-04-12 - Size: 18.6 MBA small application that uses FFProbe to scan your video files and logs these details in a small database. This is the 32 bit Windows version.
MovieScanner2-2.2.2-Linux-GTK-64bits.tar.gzDate: 2023-04-11 - Size: 29.2 MBA small application that uses FFProbe to scan your video files and logs these details in a small database. This is the 64 bit Linux version for GTK.
MovieScanner2-2.2.2-Linux-QT5-64bits.tar.gzDate: 2023-04-11 - Size: 29.1 MBA small application that uses FFProbe to scan your video files and logs these details in a small database. This is the 64 bit Linux version for QT5.
MovieScanner2-2.2.2-macOS-x86-64.dmgDate: 2023-04-11 - Size: 26.3 MBA small application that uses FFProbe to scan your video files and logs these details in a small database. This is the 64 bit macOS version.
Downloads Page Find these and more Downloads on the Downloads Page, where you will also find articles references, operating system requirements and categories.
Amazon Ads
Support us by doing your shopping at Amazon.com, either click the link, or click one of the links below …
You can also sponsor us through these Amazon offerings:
Please consider disabling your ad blocker for our website.We rely on these ads to be able to run our website.You can of course support us in other ways (see Support Us on the left).