v5:reference:adodb_force_type
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
v5:reference:adodb_force_type [2016/02/27 01:31] – [Table] mnewnham | v5:reference:adodb_force_type [2016/02/28 01:52] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== $ADODB_FORCE_TYPE ====== | ====== $ADODB_FORCE_TYPE ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | The behaviour of [[.connection: | + | The behaviour of [[v5: |
Default is ADODB_FORCE_VALUE | Default is ADODB_FORCE_VALUE | ||
Line 40: | Line 40: | ||
</ | </ | ||
+ | ===== How The Different Constants Work ===== | ||
+ | Assuming a table definition like this: | ||
+ | CHAR1 C(10), | ||
+ | CHAR2 C(10), | ||
+ | CHAR3 C(10), | ||
+ | INT1 I, | ||
+ | INT2 I | ||
+ | | ||
+ | Assuming the Values to be inserted are | ||
+ | CHAR1 = ' | ||
+ | CHAR2 = NULL | ||
+ | CHAR3 = '' | ||
+ | INT1 = 10 | ||
+ | INT2 = NULL | ||
+ | INT3 = 0 | ||
+ | | ||
+ | The SQL statements generated are as follows: | ||
+ | |||
+ | ==== ADODB_FORCE_IGNORE ==== | ||
+ | |||
+ | INSERT INTO TABLE (CHAR1, | ||
+ | | ||
+ | ==== ADODB_FORCE_NULL ==== | ||
+ | |||
+ | INSERT INTO TABLE (CHAR1, | ||
+ | |||
+ | ==== ADODB_FORCE_EMPTY ==== | ||
+ | |||
+ | INSERT INTO TABLE (CHAR1, | ||
+ | |||
+ | ==== ADODB_FORCE_NULL_AND_ZERO ==== | ||
+ | |||
+ | INSERT INTO TABLE (CHAR1, | ||
v5/reference/adodb_force_type.txt · Last modified: 2016/02/28 01:53 by mnewnham