DEV Community

#uniface

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Checking VAT ID format with GLOB in SQLite - from a Uniface service

Checking VAT ID format with GLOB in SQLite - from a Uniface service

Comments
3 min read
Validating free-form field values in SQLite - GLOB patterns and a date() surprise

Validating free-form field values in SQLite - GLOB patterns and a date() surprise

Comments
3 min read
Customer hierarchies with WITH RECURSIVE - finding cycles and group totals in a Uniface service

Customer hierarchies with WITH RECURSIVE - finding cycles and group totals in a Uniface service

Comments
4 min read
Finding negative stock with a running balance - SUM() OVER in a Uniface service

Finding negative stock with a running balance - SUM() OVER in a Uniface service

Comments
3 min read
Test data that skips the number range - an error in a Uniface click test that was not a bug

Test data that skips the number range - an error in a Uniface click test that was not a bug

Comments
2 min read
New Uniface services without clicking - XML import from an exported template

New Uniface services without clicking - XML import from an exported template

Comments
3 min read
Rounding money in Uniface ProcScript - why the modulo operator was the wrong tool

Rounding money in Uniface ProcScript - why the modulo operator was the wrong tool

Comments
3 min read
One deadline list from ten tables - a UNION ALL in a Uniface service, exported as ICS

One deadline list from ten tables - a UNION ALL in a Uniface service, exported as ICS

Comments
5 min read
When the customer changes, forget the contact - a stale id in a Uniface master-detail form

When the customer changes, forget the contact - a stale id in a Uniface master-detail form

Comments
3 min read
Dimmed buttons are not a permission check - admin forms in Uniface

Dimmed buttons are not a permission check - admin forms in Uniface

Comments
3 min read
Price changes with LAG() - a window function inside a Uniface service

Price changes with LAG() - a window function inside a Uniface service

Comments
3 min read
An average of zeros - why AVG over CASE ... ELSE 0 gave the wrong lateness

An average of zeros - why AVG over CASE ... ELSE 0 gave the wrong lateness

Comments
3 min read
Business reports in a Uniface service - year comparison, cash forecast and sales funnel with plain SQL

Business reports in a Uniface service - year comparison, cash forecast and sales funnel with plain SQL

Comments
7 min read
An invoice archive with SHA-256 checksums in Uniface - and where it is weaker than it looks

An invoice archive with SHA-256 checksums in Uniface - and where it is weaker than it looks

Comments
5 min read
Schema migrations for a Uniface app on SQLite - without a migration tool

Schema migrations for a Uniface app on SQLite - without a migration tool

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.