New Query Problem, not returning correct value

Started by martinp, September 17, 2024, 03:00:19 PM

Previous topic - Next topic

martinp

New Query acting strange..

Hope this picture is clear.

It's only occurring on some file queries as well...

martinp

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

Jane Raymond

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.
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.

martinp

#3
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

martinp

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

Len Vassos

Hi Martin,

Yes, we did receive your support ticket.  Thank you.
PVX Plus Technologies, Ltd.

Jane Raymond

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.
Jane Raymond
Software Developer
PVX Plus Technologies Ltd.

martinp

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? 

Jane Raymond

Jane Raymond
Software Developer
PVX Plus Technologies Ltd.