Upgrade Guides for Genero BDL / 2.0x upgrade guide |
DEFINE var1 DECIMAL(6,2) DEFINE var2 CHAR(10) DEFINE var3 DATE PREPARE st1 FROM "INSERT INTO tab1 VALUES ( ?. ?, ? )" EXECUTE st1 USING var1, var2, var3 EXECUTE st1 USING var2, var3, var1 -- different order = different data types
The database interface of version 2.0x has been rewritten for better performance. Having data types changing at each execute is no longer supported.
Error -254 will be raised if different data types are used in subsequent EXECUTE statements (with the same statement name).