1. Murat Yurdakul
  2. PowerBuilder
  3. Sunday, 15 September 2024 07:40 AM UTC

Hi.

I think there are some problems in version 3391. For example, the code snippet below works without any problems. But sometimes this line gives errors. A code that works continuously with a timer. But sometimes it gives the error below. I bypassed the error with Try-Catch and it works properly again in the following runs.

In another part of the application, the value I assigned to the long variable is set to -2147483648 when the data window is set. This value is the lowest limit of the long variable. Most probably there is a problem with the long variable in version 3391. Somehow the long variable turns into the lowest value and naturally the problem I first mentioned above occurs.

 

 

 

Error : Invalid DataWindow row/column specified at line 134 in function of_portcheck of object n_network.

 

Datawindow columns

 

 

**** Script ****

long i, k

datetime ldt_logdate

datastore dw_port

....

...

 

For i = dw_port.RowCount() to 1 step -1
    ldt_logdate = dw_port.GetItemDateTime(i,"logdate")
    if ldt_logdate < ldt_olddate Then
        dw_port.DeleteRow(i)
    else
        For k = 2 to 4
            ll_ping[k] = dw_port.GetItemNumber(i,"ping"+string(k + 31399))
        Next

...

...

...

 

 

 

Murat Yurdakul Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2024 17:27 PM UTC
  2. PowerBuilder
  3. # 1

I don't think so. There is no database connection in my application. I use external datawindow. I think the problem is related to the long variable type. As I mentioned above, in another part of the application, the long variable sets the value -2147483648 to the column. Again, external datawindow. While setting the value in the long variable to the datawindow, it sets the value -2147483648. Most likely, the problem here is something similar. The k variable somehow produces -2147483648 and cannot find the column name. 

The application has been working for 2 years. I have never had such a problem. This problem occurred with version 3391.

Comment
  1. Murat Yurdakul
  2. Tuesday, 17 September 2024 21:15 PM UTC
Yes. I'm testing it right now. It will work 24/7 for a few more days. Thanks a lot for your help.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 17 September 2024 21:35 PM UTC
You are most welcome. Please let us know how the test turns out! ;-)
  1. Helpful
  1. David Peace (Powersoft)
  2. Wednesday, 18 September 2024 15:10 PM UTC
The minus number is caused by a number overflow, if longlong is fixing the issue then that would seem to point to that being the problem. Have you tried changing the For loop values for k to be 31401 to 31404? I wonder if the arithmetic function within the String function is messing things up.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 September 2024 14:51 PM UTC
  2. PowerBuilder
  3. # 2

Hi Murat;

  Could this be caused by a data base column value that is > a long and thus should be handled as a LongLong data type?

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.