|
Home > Archive > Whish List > August 2005 > Null Values
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Roger Sauer 2005-08-24, 3:24 am |
| I would like to see these two statements reconciled:
1. autoNullFields: When the rowset's autoNullFields property is set to false, numeric fields (long, float, etc.) are assigned a value of zero, logical fields a value of "false", and character fields are filled with spaces.
2. lookupSQL: If the display lookup fails, a blank is displayed in the control. If the reverse lookup fails, a null is written to the field.
I think that if autoNullFields is set to false, lookupSQL should not write null values to fields.
Roger Sauer
| |
| Ken Mayer [dBVIPS] 2005-08-24, 9:23 am |
| Roger Sauer wrote:
> I would like to see these two statements reconciled:
>
> 1. autoNullFields: When the rowset's autoNullFields property is set to false, numeric fields (long, float, etc.) are assigned a value of zero, logical fields a value of "false", and character fields are filled with spaces.
>
> 2. lookupSQL: If the display lookup fails, a blank is displayed in the control. If the reverse lookup fails, a null is written to the field.
>
> I think that if autoNullFields is set to false, lookupSQL should not write null values to fields.
Then what value should be stored to the field that uses lookupSQL?
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Roger Sauer 2005-08-24, 11:25 am |
| If it's a character field, spaces; if it's numeric, zero; etc. As dictated by the stated purpose of setting autoNullFields to "false".
Roger
Ken Mayer [dBVIPS] Wrote:
> Roger Sauer wrote:
>
> Then what value should be stored to the field that uses lookupSQL?
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
| |
| Danita Brooks 2005-08-25, 11:24 am |
| Roger,
> If it's a character field, spaces; if it's numeric, zero; etc. As dictated
> by the stated purpose of setting autoNullFields to "false".
[color=darkred]
I have entered your suggestion as QAID: 5515.
Thanks,
Danita Brooks
dBI
|
|
|
|
|