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 most likely no translated for the post!
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
KODI (a.k.a. XBMC) KODI (XBMC) is probably the best media center application out there, suitable for multiple platforms.
CleverSubmitter Submits your website for indexing with a truckload of search engines.
0xED - Hex Editor Compact, fast and very flexible Hex (hexadecimal) editor for MacOS.
Lubuntu A Ubuntu variant aimed at being small and fast. Love it!
Animizer Animizer.net provides complete online toolbox for animations (GIF and APNG) - Edit, Assemble, Split or Convert, it's all there.
WordPress WordPress is one of the best tools for Blogs and Content Management Systems.
Links Page These and more of our favorite links can be found on the Links Page.
New Downloads
Resize-eMail-Pictures-for-Big-Sur.zipDate: 2021-12-28 - Size: 172.3 kBResize eMail Picture(s) workflow intended for Big Sur.
Unzip the file, and double click the .workflow file to install.
MovieScanner2-v2.0.5-macOS-64bit.dmgDate: 2021-02-27 - Size: 25.4 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.
MovieScanner2-2.0.5-Linux-QT5-64bits.tar.gzDate: 2021-02-27 - Size: 29 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.0.5-Windows-32bit-setup.exeDate: 2021-02-27 - Size: 18.4 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.0.5-Linux-GTK-64bits.tar.gzDate: 2021-02-27 - 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 GTK.
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: