Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

how to display a cell with null data in a datawindow

montjoile (Programmer) (OP)
2 Jun 11 10:53
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 (Programmer)
3 Jun 11 7:32
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"
www.anvil-of-time.com

montjoile (Programmer) (OP)
3 Jun 11 10:34
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 (Programmer)
6 Jun 11 8:05
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"
www.anvil-of-time.com

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close