KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: SQL Data Types in 4D v11 SQL
PRODUCT: 4D | VERSION: 11.4 | PLATFORM: Mac & Win
Published On: June 4, 2009
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

With the introduction of SQL into 4D, developers have been granted the ability to natively modify their database structures programmatically via SQL's Data Definition Language. In doing so, developers need to specify data types that are compliant with the SQL type names. These types correspond to 4D data types and while the mapping works without a hitch, there are a few specifics to be aware of.

Download Complete Tech Note: PDF

Commented by Thomas Fitch on July 2, 2009 at 4:08 PM
Dynamically creating tables with SQL code can be really powerful. It's important to understand how to use some of the different data types because they aren't all as intuitive as you might think. I definitely learned from this Tech Note, especially about some of the date and time characteristics.