Information générale
Catégorie:
Codage, syntaxe et commandes
>>>Bulls Eye Cindy !
>>>Excellent :) I couldn't think this yesterday. Numeric fields could only be visually blank and distinguished with isblank().
>>>Cetin
>>
>>ISBLANK(quantity) is returning .F. for these blank values. The records were originally created with INSERT INTO mytable (someotherfield) VALUES(someothervalue). Of course, neither this command nor any other one specified the value of the quantity field.
>>
>>I just tried APPEND BLANK and then BLANK FIELDS quantity. The expression ISBLANK(quantity) returned .F. after each of those commands.
>Brett,
>Is quantity numeric or something like integer, double etc ? For Numeric isblank() returns .t.
>Cetin
It is numeric, width 6, decimal 0. That's what the table designer says. Perhaps, since I specified decimal = 0, it is internally equivalent to type Integer.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement