Messages

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

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

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

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

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

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

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

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

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

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

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.

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

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

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