1. Mark Lundell
  2. PowerServer 2020 or older (Obsolete)
  3. Monday, 30 March 2020 21:40 PM UTC

Is the tooltip feature on datawindow columns supported in PowerServer?

Mark Lundell Accepted Answer Pending Moderation
  1. Monday, 6 April 2020 14:13 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

So here's the thing.  The tooltip on on a datawindow column works great most of the time.  However, if I execute the following code before displaying the datawindow, the tooltip does not work. 

String ls_dwSyntax
Integer li_ReturnCode

ls_dwSyntax = adw_source.Describe("datawindow.Syntax")
li_ReturnCode = adw_source.Create(ls_dwSyntax)

Now why would I write this ridiculous piece of code? Its because the above snippet is a dumbed down version of the following, where I need to change the database schema so that table DEVL.ERROR_MESSAGES becomes PROD.ERROR_MESSAGES before I actually use the datawindow.

String ls_dwSyntax, ls_dwSyntax2
Integer li_ReturnCode

ls_dwSyntax = adw_source.Describe("datawindow.Syntax")
ls_dwSyntax2 = lnv_string.of_GlobalReplace(ls_dwSyntax, 'DEVL.', 'PROD.', TRUE )
li_ReturnCode = adw_source.Create(ls_dwSyntax2)

Comment
  1. Mark Lundell
  2. Monday, 6 April 2020 20:35 PM UTC
Powerserver version 2019 (PB Edition) 11.0.2170.00 on my workstation and Version 2019 11.0.2170.00 on our test server. Works the same on both versions of PowerServer.



I've done compares of the dwsyntax as it exists orginally on the dataobject, after my global replace, and after the Create Statement. After global replace the only differences are the database schema. After the Create the only difference is that the Create statement adds Font.weight="400" to each of the columns.(I used NotePadd++ to perform the compares).



I tried the SetSqlSelect function, but there are too many limitations on it's use.



Is there another method to change the sql without the limitations?
  1. Helpful
  1. mike S
  2. Monday, 6 April 2020 23:08 PM UTC
use modify/describe - datawindow.table.select



PS 2020 fixes a number of issues, i don't recall anything about tooltip offhand. I'll check some reports that i create from syntax at runtime to see if the tooltips work.
  1. Helpful
  1. mike S
  2. Monday, 6 April 2020 23:25 PM UTC
maybe you just didn't hover long enough? (check your delay); you do have it enabled?



works fine for me. i have a dw with tooltips (both fixed text and tooltips based on value of a column). I have the dw stored as text and create it at runtime via the create: dwcontrol.Create ( string syntax {, string errorbuffer } )

also i can change the sql at runtime without any tooltips not working



I noticed that you didn't include the error parm in the create:

integer dwcontrol.Create ( string syntax {, string errorbuffer } )

maybe try adding that just to see if it helps??







  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Monday, 30 March 2020 21:54 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

yes

Comment
  1. Chris Pollach @Appeon
  2. Tuesday, 31 March 2020 14:03 PM UTC
As well as Menu toolbars, and various controls (like in native PB). ;-)
  1. Helpful
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.