PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: [1] 2 3 ... 10
Programming / Re: Code failure between PVX 9.1 and 15.1
« Last post by Devon Austen on August 04, 2021, 09:22:29 AM »
There was a issue with [ODB] and WindX that was fixed in version 16.10. You may want to try using version 16.10 of WindX and see if that resolves your issue.
Nomads / Re: FM generator issues
« Last post by Susan Cryderman on August 03, 2021, 09:10:24 AM »
Hi St├ęphane,

Thanks for letting us know about these issues.  We will look into solutions for the next update.
Language / Automation issue (OLE)
« Last post by michaelgreer on August 02, 2021, 10:43:37 AM »
I am trying to duplicate this VBS script in PxPlus:

strSLXCon = "Provider=SLXOLEDB.1;Password=password;Persist Security Info=True;User ID=admin;Initial Catalog=FACTSCONNECTION;Data Source=IP-SQL;Extended Properties=PORT=1706;LOG=ON;CASEINSENSITIVEFIND=ON;AUTOINCBATCHSIZE=1;SVRCERT=;"
Set objSLXCon = CreateObject("ADODB.Connection")
objSLXCon.Open strSLXCon
Set objSLXRS = CreateObject("ADODB.Recordset")

strSQL = "slx_dbids('Account',1)"
objSLXRS.Open strSQL, objSLXCon

        strID = objSLXRS.Fields(0)

msgbox strID

Here is my code:

1000 !
1005 def object crm,"ADODB.Connection"
1007 def object rec,"ADODB.Recordset"
1010 constr$="Provider=SLXOLEDB.1;persist security info=True;Initial Catalog=FACTSCONNECTION;PASSWORD=password;user ID=admin;Data Source=IP-SQL;EXTENDED PROPERTIES=""PORT=1706;log=on;casesensitivefind=on;autoincbatchsize=1;SVRCERT="""
1015 crm'open(constr$)
1020 idsql$="slx_dbids('Account',1)"
1025 ! id$=crm'execute$(idsql$)
1030 ! print id$
1035 rec'open(idsql$,*crm)
1040 rec'movefirst()
1045 id$=rec'fields$(0)
1050 print id$
1080 drop object crm
1085 drop object rec

I do not get the same result as the VB script which does return the correct value. My code executes, but generates a completely different set of ID's.  Any pointers on what is wrong here?
Nomads / FM generator issues
« Last post by St├ęphane Devouard on August 01, 2021, 11:42:40 AM »
Here are a couple of issues I found while using the FM generation wizard :

1) Inserting a dot in the FM panel name
If I name the panel with a dot (e.g. company.fm), I cannot re-open the FM wizard after the first generation of the panel. From the Nomads selector I get a message telling me to delete and regenerate the panel. From *it, I can open the library then edit the generated panel.
If I name the panel with an underscore (e.g. company_fm) then everything works as expected.
Looking at the Nomads code, this is due to the way the folder tabs are generated.
So I would simply suggest to add a check on the presence of a dot (.) in the name when creating a new FM object

2) Defining a primary key segment with a format specifier

If one of the primary key segments in the data dictionary is defined as "Last Substring" (for example), then I cannot complete the FM wizard
I am getting a message saying that some of the required fields are missing on the screen layout.
This is because the :[...] format specifier adds an extra comma to the IOLIST and screws up the test @ 1446 in fm_wizard

I already found the problem and corrected it. Thanks.
Programming / Re: Mixed-direction key not working? - Found problem, corrected
« Last post by Mike King on July 29, 2021, 10:52:54 AM »
Have you tried including the kno= option in the READ to make sure the system is using the correct key?

Programming / Mixed-direction key not working? - Found problem, corrected
« Last post by James Zukowski on July 28, 2021, 05:33:52 PM »
I've got a file with a secondary key of:
PO_Date/d + PO_Num + Cust + ShipTo + Seq

I can read directly through the file with no problems. But if I want to grab the first entry in a group and skip the rest of the Seq values, I issue:
read (F,key=PO_Date$:PO_Num$:Cust$:ShipTo$:$FF$)

It always goes to the end of file at this point. The file is created properly, with the first field descending and the remaining ascending. Am I missing something?

Thanks, all!
Programming / Re: Signature capture
« Last post by joe on July 23, 2021, 10:30:59 AM »
Thanks for hanging in there with me. I got the signature capture box and capture button working with your help. I think I can add the other buttons also.

The only other issue I have now is the stylus does not mark/draw in the signature box. I can draw with the mouse in the box, but that is not ideal. I tested the stylus using MS paint and it is functioning well. The stylus also appears to be somewhat acknowledged in the box. When I approach the screen with it a target dot appears.
Programming / Re: Signature capture
« Last post by Devon Austen on July 23, 2021, 08:23:31 AM »
Yes that logic should be on the "When Button Pressed" logic and you should select "Execute" as when the button is pressed you want to just run that code you specify in the input field.

For details about what the different options in the logic drop down menu do see here: https://manual.pvxplus.com/?NOMADS%20Graphical%20Application/Program%20Interaction/Events%20Logic/Actions%20and%20Parameters.htm
Programming / Re: Signature capture
« Last post by joe on July 22, 2021, 04:59:49 PM »
The documentation states

The Capture button retrieves the signature as a png image and saves it to a file. The OnChange logic looks like this:


Does this reffer to the button control? I could not find ONCHANGE. Should it be when button pressed? What should I select from the drop down, perform, execute? Not sure.
Pages: [1] 2 3 ... 10