This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
46
Web Server - Ask For Help / Re: Popup Date Calendars not working in NT9.31 app
« on: October 03, 2017, 10:53:23 AM »
I'm using Redmond
47
Web Server - Ask For Help / Re: Popup Date Calendars not working in NT9.31 app
« on: September 30, 2017, 02:11:14 AM »
No solution but I narrowed the issue down:
As long as the form is not a popup the date calendar popup works OK!
I use a lot of pop up forms so if anyone knows a solution please share
Mike
As long as the form is not a popup the date calendar popup works OK!
I use a lot of pop up forms so if anyone knows a solution please share
Mike
48
Web Server - Ask For Help / Popup Date Calendars not working in NT9.31 app
« on: September 29, 2017, 06:51:22 AM »
In one form none of the date field calendars work - in another form a field works only once. I click on the little calendar icon and nothing happens.
Its got me baffled - I can't see anything I have changed to cause them to stop popping up.
I've got an important sales preso on Tuesday - as Murphy's Law would predict!
Any ideas would be welcome.
Mike
Its got me baffled - I can't see anything I have changed to cause them to stop popping up.
I've got an important sales preso on Tuesday - as Murphy's Law would predict!
Any ideas would be welcome.
Mike
49
Web Server - Ask For Help / Re: unknown variable "%GenLoginForm"
« on: June 09, 2017, 09:22:25 AM »
it looks like this msg is connected with Secwin which I had removed from this app. It carries on compiling OK
Mike
Mike
50
Web Server - Ask For Help / unknown variable "%GenLoginForm"
« on: June 07, 2017, 02:46:06 AM »
I'm suddenly getting this error message when I use the NT9 wizard to create a Browse and Form. Using 9.28
Also unknown is %swglobal
Anyone else seen this?
Mike
Also unknown is %swglobal
Anyone else seen this?
Mike
51
Web Server - Ask For Help / Re: MEMOs have no CR <13> just <10>
« on: February 27, 2017, 04:05:48 AM »
Got it - missed out the ThisStringTheory4.Getvalue()
Amazing number of functions in the Stringtheory toolbag
Very Useful
Mike
Amazing number of functions in the Stringtheory toolbag
Very Useful
Mike
52
Web Server - Ask For Help / Re: MEMOs have no CR <13> just <10>
« on: February 27, 2017, 03:34:52 AM »
Bruce
Can you see anything wrong with the following:(trying to convert from <10> to <13><10>)
tempstr8=REV:actionupdate ! save in a string to avoid Amiguous Procedure Call msg
ThisStringtheory4.Setvalue(tempstr8)
ThisStringtheory4.LineEndings(st:Unix)
REV:actionupdate=tempstr8 ! save back to memo
I tried st:Windows as well but no success.
Mike
Can you see anything wrong with the following:(trying to convert from <10> to <13><10>)
tempstr8=REV:actionupdate ! save in a string to avoid Amiguous Procedure Call msg
ThisStringtheory4.Setvalue(tempstr8)
ThisStringtheory4.LineEndings(st:Unix)
REV:actionupdate=tempstr8 ! save back to memo
I tried st:Windows as well but no success.
Mike
53
Web Server - Ask For Help / Re: MEMOs have no CR <13> just <10>
« on: February 27, 2017, 02:46:40 AM »
thanks guys.
Its strange - I did a test by creating some memo text in a win32 app and when I checked it in Topscan it showed OD OA as expected. When I opened that memo in my NT web app as soon as I saved it the memo got changed back to OA only.
Mike
Its strange - I did a test by creating some memo text in a win32 app and when I checked it in Topscan it showed OD OA as expected. When I opened that memo in my NT web app as soon as I saved it the memo got changed back to OA only.
Mike
54
Web Server - Ask For Help / MEMOs have no CR <13> just <10>
« on: February 26, 2017, 01:09:53 PM »
Suddenly my memo fields are only saving with line feeds <10> and no CR <13>
This means they don't format properly in reports.
Anyone know what could cause this?
NT 9.19, Stringtheory 2.56 and latest C10
Mike
This means they don't format properly in reports.
Anyone know what could cause this?
NT 9.19, Stringtheory 2.56 and latest C10
Mike
55
Web Server - Ask For Help / Re: FLow control in a Memory Form
« on: February 18, 2017, 12:47:16 PM »
Not sure about Question 2 - but for Q1 you could popup a message as in
p_web.Script('ntAlert("Incorrect User/Password details - please try again");')
Mike
p_web.Script('ntAlert("Incorrect User/Password details - please try again");')
Mike
56
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 16, 2017, 07:41:08 PM »
OK here's the combination that finally worked
'upper(rev:observer) = <39>' & upper(quote(p_web.gsv('trainingadvisor'))) & '<39> '
thanks to Kevin and Bruce
'upper(rev:observer) = <39>' & upper(quote(p_web.gsv('trainingadvisor'))) & '<39> '
thanks to Kevin and Bruce
57
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 16, 2017, 02:32:12 PM »
still no luck - I even tried CLIP as a longshot:
[8304] [st] [netTalk][thread=4] BrowseReviews :: Filter: REV:Linkid = 149 AND clip(upper(rev:observer)) = 'ANTHONY D'AURIA'
If I put a space instead of the apostrophe, in both browses, it filters fine.
The customer is using this as a temp workaround until I come up with a solution.
I'm working through Kevin's ideas (above) and will feedback my results here.
[8304] [st] [netTalk][thread=4] BrowseReviews :: Filter: REV:Linkid = 149 AND clip(upper(rev:observer)) = 'ANTHONY D'AURIA'
If I put a space instead of the apostrophe, in both browses, it filters fine.
The customer is using this as a temp workaround until I come up with a solution.
I'm working through Kevin's ideas (above) and will feedback my results here.
58
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 15, 2017, 10:12:19 AM »
Thanks for the idea Kevin but the 1 flag doubled up the quotes:
[10276] [st] [netTalk][thread=4] BrowseReviews :: Order: REV:Linkid,-REV:PlannedDate,REV:Sysid
[10276] [st] [netTalk][thread=4] BrowseReviews :: Filter: REV:Linkid = 149 AND upper(quote(rev:observer),1) = 'ANTHONY D''AURIA'
Do you know anywhere in the browse, just before the filter is applied to that row, where I could run QUOTE on rev:observer itself?
Mike
[10276] [st] [netTalk][thread=4] BrowseReviews :: Order: REV:Linkid,-REV:PlannedDate,REV:Sysid
[10276] [st] [netTalk][thread=4] BrowseReviews :: Filter: REV:Linkid = 149 AND upper(quote(rev:observer),1) = 'ANTHONY D''AURIA'
Do you know anywhere in the browse, just before the filter is applied to that row, where I could run QUOTE on rev:observer itself?
Mike
59
Web Server - Ask For Help / Re: using QUOTE in a browse filter
« on: February 14, 2017, 10:22:02 AM »
this is what Debugview shows
[6720] [st] [netTalk][thread=3] BrowseReviews :: Order: REV:Linkid,-REV:PlannedDate,REV:Sysid
[6720] [st] [netTalk][thread=3] BrowseReviews :: Filter: REV:Linkid = 119 AND upper(quote(rev:observer)) = 'ANTHONY D''AURIA'
the linkid is correct but I'm wondering if PROP:FILTER supports QUOTE?
I'm not using SQL but I presume the view uses PROP:FILTER
Mike
[6720] [st] [netTalk][thread=3] BrowseReviews :: Order: REV:Linkid,-REV:PlannedDate,REV:Sysid
[6720] [st] [netTalk][thread=3] BrowseReviews :: Filter: REV:Linkid = 119 AND upper(quote(rev:observer)) = 'ANTHONY D''AURIA'
the linkid is correct but I'm wondering if PROP:FILTER supports QUOTE?
I'm not using SQL but I presume the view uses PROP:FILTER
Mike
60
Web Server - Ask For Help / using QUOTE in a browse filter
« on: February 12, 2017, 06:37:28 AM »
One of the observers names is D'Auria and its throwing my filters out.
In a conditional browse filter I have set up the filter as
'upper(quote(rev:observer)) = ''' & upper(quote(p_web.gsv('trainingadvisor'))) & ''' '
but it still doesn't find D'Auria. I checked the prop:filter and it was being doubled up correctly as D''Auria
Can anyone see anything wrong with the filter string?
It works OK as long as there is no apostrophe in the name.
Mike
In a conditional browse filter I have set up the filter as
'upper(quote(rev:observer)) = ''' & upper(quote(p_web.gsv('trainingadvisor'))) & ''' '
but it still doesn't find D'Auria. I checked the prop:filter and it was being doubled up correctly as D''Auria
Can anyone see anything wrong with the filter string?
It works OK as long as there is no apostrophe in the name.
Mike