how to display a cell with null data in a datawindow

[montjoile]

I want to display all the cells in a datawindow even if they contain null data, but I don't know how to do it. This is just for aesthetic purposes.
Clients says that my application doesn't look nice when there are cell with no borders in the table

 

[mbalent]

When you say 'cell' you mean a row/column combination? What style of datawindow are you using (grid, freeform, etc)?

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[montjoile]

I'm using a datawindow freeform. And yes, that's what I mean with cell: each data is displayed with border, but it doesn't display anything when I have null data. it's obvious, I know, but is there a method that allow me to display the border even with null data, or replace the null data with another character (if I can do that, I do not what to change any value)

 

[mbalent]

In MS SQL you could use the statement Isnull(xxx,'') for the character columns so the DB will return an emptystring if the value is null. This won't trigger any change in the database from PB unless the value is changed and the column is in the update properties of the datawindow object.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com