Subject | Connection.ColumnAttributes - doesn't seem to be working |
---|---|
Author | Michael L. Horne |
Post date | 2002-01-15T07:52:53Z |
Hello Jason,
As I understood it if I go to the TIB_Connection and set
up values for domains in then it will apply to all uses
of fields of that domain through out the program. If
that is correct then it is not working....
I set:
TIB_Connection.ColumnAttributes
T_MEMO=BLANKISNULL
Now if I have a button that does
qyInv.FieldByName('INV_CUSTOMER_NOTES').AsString := '';
where the field is a T_Memo, it isn't set to NULL.
However, if I set the query to:
TIB_Query.ColumnAttributes
INV_CUSTOMER_NOTES=BLANKISNULL
Now if I have a button that does
qyInv.FieldByName('INV_CUSTOMER_NOTES').AsString := '';
it IS set to NULL.
I look forward to hearing about this.
Thanks
Michael L. Horne
As I understood it if I go to the TIB_Connection and set
up values for domains in then it will apply to all uses
of fields of that domain through out the program. If
that is correct then it is not working....
I set:
TIB_Connection.ColumnAttributes
T_MEMO=BLANKISNULL
Now if I have a button that does
qyInv.FieldByName('INV_CUSTOMER_NOTES').AsString := '';
where the field is a T_Memo, it isn't set to NULL.
However, if I set the query to:
TIB_Query.ColumnAttributes
INV_CUSTOMER_NOTES=BLANKISNULL
Now if I have a button that does
qyInv.FieldByName('INV_CUSTOMER_NOTES').AsString := '';
it IS set to NULL.
I look forward to hearing about this.
Thanks
Michael L. Horne