Messages

1

Web Server - Ask For Help / Re: MS-SQL demon select statement

« on: April 19, 2016, 10:59:30 AM »

Hi,

Yes, as mentioned this will work in C10 up to and including 11822 but it's broke in versions after that.
I think I have a work around for this for now.

Thanks for taking a look at this.

Regards

Parker

2

Web Server - Ask For Help / Re: MS-SQL demon select statement

« on: April 19, 2016, 07:50:36 AM »

Thanks for that but no joy.

SQL driver 10.0 was in place and I installed 11.0 (2011.110.5058.00)
Modified the connection string to force the use of version 11 of the driver and it still GPFs on the 2nd or 3rd try.

What version of C10 are you using when you compile and run this?
Are you getting a result back other than zero?

Regards

Parker

3

Web Server - Ask For Help / Re: MS-SQL demon select statement

« on: April 18, 2016, 06:58:14 PM »

bump

4

Web Server - Ask For Help / MS-SQL demon select statement

« on: April 03, 2016, 04:25:41 PM »

Hi Bruce,

I wanted to bump this in case it fell off your to-do list.
 
This one is bizarre and I’m still debating if it’s a Clarion or Nettalk issue.
The environment is Clarion 10.12104, MSSQL 2008-14, NT9.05
 
I’ve have an application running for several years with C9 and NT8.6x, it runs solid but when I tried converting it to the later C10 builds it blows out when doing a very specific PropSQL call on a TurboSQL table. With all the chatter on the news groups about SQL issues in the current releases of C10 I chalked it up to that, particularly as if I put the MSSQL DLL from build 11822 in place it works again.
 
I prepared an example to report to SoftVelocity but the sample desktop app ran fine with the same query. So I built a very stripped down NT9 app to do the same thing and it crashes every time.
 
In the attached zip file are the 2 example apps I created (no dictionary required) both are designed to execute an SQL statement using a internally defined TurboSQL file and return the result. It also contains a backup of the sample MSSQL database they are both accessing, you would need to restore this to an SQL server of course.
 
Compile both apps, the desktop client when run has a menu option named “Open Form”, it will automatically populate the fields with the connect string which you need to change for your server, and the problematic SELECT statement. If you click the Execute SQL button several times it will return a total amount. Other values in the table besides 3100 that can be used in the WHERE clause are 3300 and 8393.
 
Run the web app and the server will crash on either the very first or second execution of the SQL statement.
 
If you remove the WHERE clause it will run successfully multiple times without issue.
 
So a Clarion driver or an NT issue with the new Clarion driver?
 
Thanks for looking.
 
Regards
 
Parker

5

Web Server - Ask For Help / Re: Penetration Testing

« on: March 26, 2016, 05:30:40 AM »

Hi Ashley,

Unlikely to be a thread issue since 100/minute is less than 2 per second and it does run for the first 1.5 hours. Can you elaborate on what happens on each request and what backend database is being used if any?
You could open the task manager and watch to see if the memory being used by the web app continues to climb to an excessive amount during the testing, it isn't a definitive indicator of a memory leak but it may provide a valuable clue.

Regards

Parker

6

Web Server - Ask For Help / Re: Exception error C0000005 on entering a form

« on: February 10, 2016, 09:20:03 AM »

Hi Terry,

Any chance you are using MSSQL and/or self-declared TurboSQL tables in your application?

I've had similar issues with C10 upgrades after 11822. Although I have not put it into production, copying the ClaMSS.dll from 11822 into the application folder seems to make the issue go away.

Regards

Parker

7

Web Server - Ask For Help / Re: How do I get "Other Button" icons to match selected theme.

« on: July 12, 2015, 06:04:42 AM »

Hi Bruce,

Thanks for the speedy reply!

Nope, it isn't urgent. Do I need to register for the Thursday webinar somewhere?

Regards

Parker

8

Web Server - Ask For Help / How do I get "Other Button" icons to match selected theme.

« on: July 12, 2015, 05:19:17 AM »

Hi folks,

I am using the shoestrap2 theme and in row buttons. This gives the Add/Change/Delete buttons a nice colour on the icon. When I add "other buttons" however there is no automagic colour added so they look greyed out as if they are disabled, but they are not disabled.

I'm using the alert, print, and calendar names in the Image CSS prompt field on the template. Is there a way I can use these icons but have them with some colour?

Regards

Parker

[attachment deleted by admin]

9

Web Server - Ask For Help / Re: possible parser issue with jFiles

« on: July 02, 2015, 01:59:08 AM »

Capiche.

Grazie.

Parker

10

Web Server - Ask For Help / possible parser issue with jFiles

« on: July 01, 2015, 05:15:09 AM »

Hi Bruce,

Finally got the example working with Willie's original request and I apologize to him for hijacking that thread a bit.

A small oddity with the data has cropped up. I tried to append various pieces of the queue data to a text string and display it and unexpected line breaks occur which seem to be related to the last element in an json object.
Displaying this data causes the line breaks when using the "value" data:
 
"elements" : [
            {
               "distance" : {
                  "text" : "16.5 mi",
                  "value" : 26580
               },
               "duration" : {
                  "text" : "20 mins",
                  "value" : 1202
               },
               "status" : "OK"
            }
     ]

Processing this does not exhibit the line breaks:
notice the commas after the last value in the in each set which I don't think is a properly formatted json object

"elements" : [
            {
               "distance" : {
                  "text" : "16.5 mi",
                  "value" : 26580,
               },
               "duration" : {
                  "text" : "20 mins",
                  "value" : 1202,
               },
               "status" : "OK"
            }
     ]

So it seems the parser is adding a little something extra to the last field in an object.

Example attached.

Regards

Parker

[attachment deleted by admin]

11

Web Server - Ask For Help / Re: Jfiles - List arrays

« on: June 30, 2015, 06:12:11 PM »

Hi Bruce,

I think there is still a piece of this puzzle missing.
When I try this code I only get the last 2 element entries, there are only 2 entries in the queue and I would have expected 4.
I added another set of element entries to Willie's json data and again I only get the last 2.

Is it possible that the elements.Load(elementsQ) is clearing the queue on each iteration instead of appending?

Regards

Parker

12

Web Server - Ask For Help / Re: Code for "Other" button NT8.51

« on: June 30, 2015, 05:20:22 PM »

Hi,

Perhaps try: on the properties of the button, on the "Client-Side" tab, check "Send Button Click to server" and then click on the "Server Code" button.

Regards

Parker

13

Web Server - Ask For Help / Re: Have p_web.Redirect use POST instead of GET.

« on: June 30, 2015, 03:56:53 AM »

Hi Bruce,

Yes I was thinking of it from the server side.

You've made me realize I was looking at this all wrong and now need to rethink the approach.
Some desktop client habits are just hard to break!!!!

Regards
Parker

14

Web Server - Ask For Help / Re: Jfiles - List arrays

« on: June 30, 2015, 03:52:56 AM »

Thanks Bruce, there is some good study material in this response.
I'll be printing that out and tucking it in "the binder" for future reference as well.

It would be nice if the proposed access to the json object array

  jObject.GetValueByName('rows[ x ].elements[ y ].distance.text')

wasn't so slow as to make it impractical, and of course the effort on your part to code it too unreasonable.

Thanks again,

Parker

15

Web Server - Ask For Help / Have p_web.Redirect use POST instead of GET.

« on: June 29, 2015, 10:43:05 AM »

The p_web.Redirect(...) appears to do a GET, is it possible to have it do a POST instead?
I'm trying to redirect to another site's page (within my own domain) and pass some values to it using POST.

Thanks

Parker