1. James Firestone
  2. PowerBuilder
  3. Wednesday, 6 March 2019 21:37 PM UTC

I am new to PowerBuilder.  We are adding two columns to a table.  One is a date, the other char(2).  I am able to insert something to the columns initially, but when I try to modify or delete the row, it does not work, because it did not properly retrieve the date (which looks fine via a separate query), but instead has 1949-??-??.  No doubt I have not provided enough information yet, but I'd rather not fill this post with what may be a bunch of irrelevant info.

James Firestone Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 22:29 PM UTC
  2. PowerBuilder
  3. # 1

Thank you Chris and Olan.  I think I have tried these things in one degree or another.  Probably I will have to provide more detail about the specific situation.  I will put that reply together upon posting this one, as I will want to take some time to figure out exactly what I should share here (and yet give enough info for you to understand the situation).

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 22:19 PM UTC
  2. PowerBuilder
  3. # 2

Most likely your FORMAT has not been specified.

In the DW Painter -
   1) click on the DATE column
   2) Expand the upper right pane until the FORMAT tabpage appears
   3) Click on the FORMAT tabpage

   4) Set the FORMAT of the date appropriately.


5) Test the DW by retrieving data.


Olan

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 6 March 2019 22:16 PM UTC
  2. PowerBuilder
  3. # 3

Hi James;

  After inserting new columns into an existing table, you need to:

1) Open the DW Painter and then proceed to the SQL Painter from there.

2) Select the new column(s) that the DW is to use in the SQL Painter.

3) Return to the DW Painter and then add the column(s) that you want the user to interact with in the "Design" pane.

4) Then check the Update Properties in the DW Painter for those new column(s). Select (highlight) the new columns if you want the DWO to produce SQL to maintain them.

5) Use the "Preview" pane to check out the DWO's behaviour.

6) If everything works OK in the DW Painter ... Save the DWO and then exit.

HTH

PS: Welcome to PowerBuilder!

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.