PxPlus User Forum

Main Board => Discussions => Programming => Topic started by: martinp on September 17, 2024, 03:00:19 PM

Title: New Query Problem, not returning correct value
Post by: martinp on September 17, 2024, 03:00:19 PM
New Query acting strange..

Hope this picture is clear.

It's only occurring on some file queries as well...
Title: Re: New Query Problem, not returning correct value
Post by: martinp on September 17, 2024, 03:11:17 PM
I've traced ARG_1$ is reverted back after *winlist;wrapup" in *plus/inomads/in_qry2

 QRY_WrapUp:
 call "*plus/winutl/winqry;Set_iNomads_Query_Persistence",QRYOPTS
 if _DUMPFILE then gosub RELOAD_DUMP; perform "*winlist;wrapup"
 drop object QRYOPTS
 print 'option'("Invalid_bmp",_sv_bmp$),
 if ctl=-1999 or ctl=close_btn.ctl then let %nomad_qry_abort=2
 if iswindows then print 'cursor'(0),
 return
Title: Re: New Query Problem, not returning correct value
Post by: Jane Raymond on September 18, 2024, 08:52:38 AM
Since this issue only happens on some queries, we will have to have more information about the query definition so we will know how it is set up. Also, what version of Pxplus are you using, and if these queries worked in the past, what version were you running them, etc. 
That being said, the best way to attack this issue is for you to create a helpdesk ticket at helpdesk2.pvxplus.com or  go to our www.pvxplus.com website and go to the Client Hub/Support page to Open a New Ticket. This allows us to track the issue and more easily communicate with you.
Title: Re: New Query Problem, not returning correct value
Post by: martinp on September 18, 2024, 11:00:37 AM
I've reproduced this issue it seems to be with a large number or records > 5000 for example.  I will create a ticket for you.  Thank you.

EDIT:  I sent the ticket but I didn't receive a confirmation email on ticket creation let me know if I have to re-create.  Thanks
Title: Re: New Query Problem, not returning correct value
Post by: martinp on September 19, 2024, 10:24:48 AM
Hi did you get my ticket?   I never received an auto ticket response like in past or I did something wrong.  If not I will try again thanks
Title: Re: New Query Problem, not returning correct value
Post by: Len Vassos on September 19, 2024, 11:57:57 AM
Hi Martin,

Yes, we did receive your support ticket.  Thank you.
Title: Re: New Query Problem, not returning correct value
Post by: Jane Raymond on September 26, 2024, 08:39:41 AM
Martin,
I have responded to your ticket with a possible fix, but have not heard back from you. I just wanted to check with you since previously you did not receive the auto ticket response.
Title: Re: New Query Problem, not returning correct value
Post by: martinp on September 26, 2024, 03:56:47 PM
Thanks, I did not get it, I got another one today from another ticket.  #512072, so that email is working so perhaps I entered wrong email on the first ticket? 
Title: Re: New Query Problem, not returning correct value
Post by: Jane Raymond on September 27, 2024, 09:13:31 AM
We'll look into it.