Category: V1 DBForms
V1 DBForm sniplets
In DBForms try where possible to use -E for Trusted Connections rather than hard coded usernames and passwords. Use dbsvpdf.exe to output V1 outputs to PDF For multi page, multi document outputs use a variable to control the end of page such as END_OF_DOC using a field you know will appear on the last page…
DBForms: Check and format email addresses from Sage Line 500/1000
As the email field can sometimes not be used for the correct purpose I use a bit of code to look for an @ symbol and then a dot. If more than one email address is in I replace the comma with -t which is required by dbmailsend. If using Sage Line 500/1000 the CustomerTable…