DEV Community

Franz profile picture

Franz

404 bio not found

Joined Joined on 
Restoring a draft over rows that are reloaded from the database - Uniface grid forms

Restoring a draft over rows that are reloaded from the database - Uniface grid forms

Comments
4 min read

Want to connect with Franz?

Create an account to connect with Franz. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Spreadsheet paste, drafts and sorting for Uniface grid forms

Spreadsheet paste, drafts and sorting for Uniface grid forms

Comments
4 min read
Let users jump to the target status - generating ProcScript status paths from a small state graph

Let users jump to the target status - generating ProcScript status paths from a small state graph

Comments
3 min read
Row lists without a database table in Uniface 10 - grid entities, per-row triggers and two surprises

Row lists without a database table in Uniface 10 - grid entities, per-row triggers and two surprises

Comments
4 min read
A quick order entry form in Uniface 10 - item lists in component variables and a price preview on loseFocus

A quick order entry form in Uniface 10 - item lists in component variables and a price preview on loseFocus

Comments
4 min read
Two $concat pitfalls in Uniface ProcScript - arithmetic arguments and the argument count

Two $concat pitfalls in Uniface ProcScript - arithmetic arguments and the argument count

Comments
2 min read
Uniface 10 field triggers - leaveField compiles, but loseFocus is what runs

Uniface 10 field triggers - leaveField compiles, but loseFocus is what runs

Comments
3 min read
Date shortcuts like +7, +2w and mon with SQLite date modifiers in a Uniface service

Date shortcuts like +7, +2w and mon with SQLite date modifiers in a Uniface service

Comments
3 min read
Ctrl+A that saves instead of closing - accept and quit triggers in a Uniface form

Ctrl+A that saves instead of closing - accept and quit triggers in a Uniface form

Comments
3 min read
A Uniface test service that just stopped - four things I learned debugging it

A Uniface test service that just stopped - four things I learned debugging it

Comments
4 min read
Checking IBANs in Uniface ProcScript - mod 97 without big numbers

Checking IBANs in Uniface ProcScript - mod 97 without big numbers

Comments
4 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
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
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
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
1330 Uniface tests against the real database - and the file doesn't change by a single byte

1330 Uniface tests against the real database - and the file doesn't change by a single byte

Comments
5 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
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
A job scheduler in two tables - recurring tasks inside a Uniface app

A job scheduler in two tables - recurring tasks inside a Uniface app

Comments
5 min read
Gapless invoice numbers in a Uniface app - and how to check them across the year change

Gapless invoice numbers in a Uniface app - and how to check them across the year change

Comments
7 min read
A four-eyes approval in a Uniface service - one table, two rules, and the gaps it leaves

A four-eyes approval in a Uniface service - one table, two rules, and the gaps it leaves

Comments
5 min read
Data quality checks in a Uniface app - orphans and bad data in SQLite without foreign keys

Data quality checks in a Uniface app - orphans and bad data in SQLite without foreign keys

Comments
6 min read
The Uniface CSV import that never found its header line

The Uniface CSV import that never found its header line

Comments
4 min read
A row is not a list of rows - a getitem pitfall with sql/data in Uniface

A row is not a list of rows - a getitem pitfall with sql/data in Uniface

Comments
3 min read
Ten Uniface forms without painting a single field - generating the XML instead

Ten Uniface forms without painting a single field - generating the XML instead

Comments
5 min read
The Uniface save dialog that never opened - filebox and the default directory

The Uniface save dialog that never opened - filebox and the default directory

Comments
3 min read
A modern look for a Uniface 10 desktop app - with its own .ini and without touching the IDE

A modern look for a Uniface 10 desktop app - with its own .ini and without touching the IDE

Comments
4 min read
One copy instead of eleven - a Uniface IncludeScript library created by XML import

One copy instead of eleven - a Uniface IncludeScript library created by XML import

Comments
4 min read
When an empty field means "delete" - a silent removal in a Uniface service and how the form now guards it

When an empty field means "delete" - a silent removal in a Uniface service and how the form now guards it

Comments
3 min read
One customer, many forms - passing an ID through exec in Uniface 10

One customer, many forms - passing an ID through exec in Uniface 10

Comments
3 min read
A dry run that left no trace - how a rollback in a Uniface form removed the service's own log entry

A dry run that left no trace - how a rollback in a Uniface form removed the service's own log entry

Comments
3 min read
One entry for commit and rollback after a service call in Uniface forms

One entry for commit and rollback after a service call in Uniface forms

Comments
3 min read
Adding a button to an existing Uniface form by XML - export, patch, import

Adding a button to an existing Uniface form by XML - export, patch, import

Comments
4 min read
Id lists in Uniface ProcScript - reading a KPI cockpit with getitem/id

Id lists in Uniface ProcScript - reading a KPI cockpit with getitem/id

Comments
3 min read
Dry run first, then ask - a purge button in Uniface that shows what it will delet

Dry run first, then ask - a purge button in Uniface that shows what it will delet

Comments
2 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
Uniface lists are not semicolon strings - printing an id list with forlist

Uniface lists are not semicolon strings - printing an id list with forlist

Comments
2 min read
Delete by id is not enough - an ownership check in a Uniface form

Delete by id is not enough - an ownership check in a Uniface form

Comments
2 min read
Twenty list entries from one template - generating repetitive Uniface ProcScript with Python

Twenty list entries from one template - generating repetitive Uniface ProcScript with Python

Comments
2 min read
Export and import that do not fit together - a format mismatch found in a Uniface click test

Export and import that do not fit together - a format mismatch found in a Uniface click test

Comments
2 min read
Three service operations, one entry - dry run and confirmation for data normalization in Uniface

Three service operations, one entry - dry run and confirmation for data normalization in Uniface

Comments
2 min read
A SHA-256 checksum file from Uniface - and why sha256sum -c did not read it

A SHA-256 checksum file from Uniface - and why sha256sum -c did not read it

Comments
3 min read
Restoring a settings snapshot in Uniface - compare first, keep a way back

Restoring a settings snapshot in Uniface - compare first, keep a way back

Comments
4 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
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
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 table builder for all HTML reports - column types in a short string in Uniface ProcScript

One table builder for all HTML reports - column types in a short string in Uniface ProcScript

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
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
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
The Uniface test that "hung" had died - finding a silent crash with SQLite

The Uniface test that "hung" had died - finding a silent crash with SQLite

Comments
5 min read
Six ProcScript surprises from 60 Uniface services

Six ProcScript surprises from 60 Uniface services

Comments 1
5 min read
40 features, 872 tests, one SQLite file - how the Uniface test suite stayed honest

40 features, 872 tests, one SQLite file - how the Uniface test suite stayed honest

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
A job scheduler in two tables - recurring tasks inside a Uniface app

A job scheduler in two tables - recurring tasks inside a Uniface app

Comments
5 min read
A four-eyes approval in a Uniface service - one table, two rules, and the gaps it leaves

A four-eyes approval in a Uniface service - one table, two rules, and the gaps it leaves

Comments
5 min read
The Uniface CSV import that never found its header line

The Uniface CSV import that never found its header line

Comments
4 min read
1330 Uniface tests against the real database - and the file doesn't change by a single byte

1330 Uniface tests against the real database - and the file doesn't change by a single byte

Comments
5 min read
loading...