Tech Tip: Nonexistent vs blank database methods
PRODUCT: 4D | VERSION: 18 | PLATFORM: Mac & Win
Published On: March 2, 2021
When working with the built-in database methods such as On SQL Authentication, there can be different return values based on whether the database method exists or is a blank method. When the On SQL Authentication does not exist, the return value will default to True. However, if the developer double clicks to create the On SQL Authentication and does not enter any code, the blank method will default to False which can cause authentication errors when trying to connect via ODBC.
In short, whenever you plan to use the built-in database methods, make sure the code will return some value. Otherwise, it may be best to just delete the method if it is unused.