Tips & Tricks for your 4D Apps – August Edition
by Add Komoncharoensiri, Director of Technical Services at 4D Inc
Here we go with another set of tips and tricks.
As you know, 4D Knowledge Base is a library of information about the 4D technology where weekly tech tips and monthly technotes are actively published. If you missed the last tips on the KB, that’s fine; here is a compilation from the past few weeks.
This blog post covers 16 tips:
Tech Tips — The 4 Tips of April are Here!
by Add Komoncharoensiri, Director of Technical Services at 4D Inc
As a 4D developer, you have to keep up with the new advances 4D is continuously shipping. Besides tips and tricks provided by the product team, Tech Tips are another reference for learning some of the 4D concepts.
This article covers 4 tips:
- How to treat SQL wildcard characters as a literal string
- Programmatically get the project name
- Preemptive methods under the same call chain should also be preemptive
- Creating a new View Pro document based on a Sheet
Read 4D object fields with SQL Engine
A 4D object field is a persistent database field type, stored as binary content. Previously, reading this type of field by an ODBC driver wasn’t possible. Until today.
Before, an error was returned when trying to read an object field. This prevented the completion of simple Select * from myTable requests, which could be frustrating for users who only wanted to browse the content of a table.
Good news! The SQL engine has been updated to allow 4D object fields to be read.