Skip to content
Navigation menu
Search
Powered by Algolia
Search
Log in
Create account
DEV Community
Close
#
uniface
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Checking VAT ID format with GLOB in SQLite - from a Uniface service
Franz
Franz
Franz
Follow
Nov 16
Checking VAT ID format with GLOB in SQLite - from a Uniface service
#
uniface
#
sqlite
#
sql
#
procscript
Comments
Add Comment
3 min read
Moderation
Validating free-form field values in SQLite - GLOB patterns and a date() surprise
Franz
Franz
Franz
Follow
Nov 16
Validating free-form field values in SQLite - GLOB patterns and a date() surprise
#
uniface
#
sqlite
#
sql
#
procscript
Comments
Add Comment
3 min read
Moderation
Customer hierarchies with WITH RECURSIVE - finding cycles and group totals in a Uniface service
Franz
Franz
Franz
Follow
Nov 16
Customer hierarchies with WITH RECURSIVE - finding cycles and group totals in a Uniface service
#
uniface
#
sqlite
#
sql
#
procscript
Comments
Add Comment
4 min read
Moderation
Finding negative stock with a running balance - SUM() OVER in a Uniface service
Franz
Franz
Franz
Follow
Nov 16
Finding negative stock with a running balance - SUM() OVER in a Uniface service
#
uniface
#
sqlite
#
sql
#
procscript
Comments
Add Comment
3 min read
Moderation
Test data that skips the number range - an error in a Uniface click test that was not a bug
Franz
Franz
Franz
Follow
Nov 16
Test data that skips the number range - an error in a Uniface click test that was not a bug
#
uniface
#
testing
#
sqlite
#
procscript
Comments
Add Comment
2 min read
Moderation
New Uniface services without clicking - XML import from an exported template
Franz
Franz
Franz
Follow
Nov 16
New Uniface services without clicking - XML import from an exported template
#
uniface
#
procscript
#
python
#
tooling
Comments
Add Comment
3 min read
Moderation
Rounding money in Uniface ProcScript - why the modulo operator was the wrong tool
Franz
Franz
Franz
Follow
Nov 16
Rounding money in Uniface ProcScript - why the modulo operator was the wrong tool
#
uniface
#
procscript
#
sqlite
#
testing
Comments
Add Comment
3 min read
Moderation
One deadline list from ten tables - a UNION ALL in a Uniface service, exported as ICS
Franz
Franz
Franz
Follow
Nov 16
One deadline list from ten tables - a UNION ALL in a Uniface service, exported as ICS
#
uniface
#
procscript
#
sqlite
#
ics
Comments
Add Comment
5 min read
Moderation
When the customer changes, forget the contact - a stale id in a Uniface master-detail form
Franz
Franz
Franz
Follow
Nov 16
When the customer changes, forget the contact - a stale id in a Uniface master-detail form
#
uniface
#
procscript
#
testing
#
ui
Comments
Add Comment
3 min read
Moderation
Dimmed buttons are not a permission check - admin forms in Uniface
Franz
Franz
Franz
Follow
Nov 16
Dimmed buttons are not a permission check - admin forms in Uniface
#
uniface
#
security
#
procscript
#
testing
Comments
Add Comment
3 min read
Moderation
Price changes with LAG() - a window function inside a Uniface service
Franz
Franz
Franz
Follow
Nov 16
Price changes with LAG() - a window function inside a Uniface service
#
uniface
#
sqlite
#
sql
#
procscript
Comments
Add Comment
3 min read
Moderation
An average of zeros - why AVG over CASE ... ELSE 0 gave the wrong lateness
Franz
Franz
Franz
Follow
Nov 16
An average of zeros - why AVG over CASE ... ELSE 0 gave the wrong lateness
#
uniface
#
sqlite
#
sql
#
testing
Comments
Add Comment
3 min read
Moderation
Business reports in a Uniface service - year comparison, cash forecast and sales funnel with plain SQL
Franz
Franz
Franz
Follow
Nov 16
Business reports in a Uniface service - year comparison, cash forecast and sales funnel with plain SQL
#
uniface
#
sqlite
#
reporting
#
legacy
Comments
Add Comment
7 min read
Moderation
An invoice archive with SHA-256 checksums in Uniface - and where it is weaker than it looks
Franz
Franz
Franz
Follow
Nov 16
An invoice archive with SHA-256 checksums in Uniface - and where it is weaker than it looks
#
uniface
#
sqlite
#
security
#
legacy
Comments
Add Comment
5 min read
Moderation
Schema migrations for a Uniface app on SQLite - without a migration tool
Franz
Franz
Franz
Follow
Nov 16
Schema migrations for a Uniface app on SQLite - without a migration tool
#
uniface
#
sqlite
#
migration
#
legacy
Comments
Add Comment
6 min read
Moderation
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account