Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: 1 [2]
16
Language / Re: WINDEV with redirected printer
« on: April 15, 2020, 04:25:25 PM »
James,
I have come across this myself. For me and my users, our problem is that our cheap home printers don't support the output sent to the printer.
Our Unform output is PCL5, which my home printer doesn't support.
To work around this, our users are printing to PDF on the RDP session. From Adobe on the remote session, they then print to the "redirected" printer, which works fine.
I did work with another developer on this and he does have a laser printer at home that supports PCL5/6. He was able to print directly to his printer from PxPlus, however, in order to do so, he had to set his printer up on his local PC to use the "HP Universal Printing PCL6" driver instead of the specific driver for his printer.
I haven't seen that with my own eyes, but fully trust what he told me. I believe he was printing using *windev*, but I can't be positive. My system does for the printer I was using and his system is set up very similarly.
I didn't pursue this any further because our users were content to print to PDF and then print from Adobe to their printer.
Hope that helps. Good luck.
I have come across this myself. For me and my users, our problem is that our cheap home printers don't support the output sent to the printer.
Our Unform output is PCL5, which my home printer doesn't support.
To work around this, our users are printing to PDF on the RDP session. From Adobe on the remote session, they then print to the "redirected" printer, which works fine.
I did work with another developer on this and he does have a laser printer at home that supports PCL5/6. He was able to print directly to his printer from PxPlus, however, in order to do so, he had to set his printer up on his local PC to use the "HP Universal Printing PCL6" driver instead of the specific driver for his printer.
I haven't seen that with my own eyes, but fully trust what he told me. I believe he was printing using *windev*, but I can't be positive. My system does for the printer I was using and his system is set up very similarly.
I didn't pursue this any further because our users were content to print to PDF and then print from Adobe to their printer.
Hope that helps. Good luck.
17
Language / Re: Shared user slots
« on: July 18, 2019, 05:43:29 PM »
I got some help from someone offline and got this resolved. No further response needed.
In case anyone is wondering, changing "deftty" to "deftty window" fixed it.
My description of the problem was slightly off also. Only the first session I opened behaved as I described.
In case anyone is wondering, changing "deftty" to "deftty window" fixed it.
My description of the problem was slightly off also. Only the first session I opened behaved as I described.
18
Language / Shared user slots
« on: July 18, 2019, 04:45:34 PM »
From the reference manual, the '1U' parameter says that if the parameter is off, "PxPlus attempts to use shared user slots for the session". Noting the word "attempts", what would prevent PxPlus from being able to share a user slot?
The reason I ask is that I can open 3 code screens and all will be sharing the same user slot.
However, if I try to resize the screens to allow a larger viewable area, they are sometimes assigned a dedicated user slot. It is inconsistent, but happens often enough to cause "User limit exceeded" problems.
Example:
-}?prm('1U')
0
-}?tcb(27)
-17
-}deftty (0)40,15
-}?prm('1U')
1
-}?tcb(27)
10
For some reason, when issuing the deftty directive above, the '1U' parameter gets set and the session is now using a dedicated user slot. Any suggestions on how to prevent this from using a dedicated user slot?
The reason I ask is that I can open 3 code screens and all will be sharing the same user slot.
However, if I try to resize the screens to allow a larger viewable area, they are sometimes assigned a dedicated user slot. It is inconsistent, but happens often enough to cause "User limit exceeded" problems.
Example:
-}?prm('1U')
0
-}?tcb(27)
-17
-}deftty (0)40,15
-}?prm('1U')
1
-}?tcb(27)
10
For some reason, when issuing the deftty directive above, the '1U' parameter gets set and the session is now using a dedicated user slot. Any suggestions on how to prevent this from using a dedicated user slot?
19
ODBC / Re: ODBC Connection string
« on: March 04, 2019, 12:49:27 PM »
Devon,
As you suspected all along, my original connection string was fine. The problem was in the other third party software. I worked with them today and it is resolved. Thanks!
As you suspected all along, my original connection string was fine. The problem was in the other third party software. I worked with them today and it is resolved. Thanks!
20
ODBC / Re: ODBC Connection string
« on: March 01, 2019, 03:16:29 PM »
I have confirmed that their software is 32-bit. He was relieved when I told him the driver we already have installed is 32-bit.
The other software is passing the connection string off to the OS and because it "fails", Windows pops up a dialogue box prompting the user to select an existing DSN. If I select an existing DSN (or file DSN), the query proceeds successfully. However, this is connecting using the DSN selected, not by the initial connection string.
They tell me that they are not popping up the dialogue box... Windows does because my connection string fails. I have no way to confirm that.
The other software is passing the connection string off to the OS and because it "fails", Windows pops up a dialogue box prompting the user to select an existing DSN. If I select an existing DSN (or file DSN), the query proceeds successfully. However, this is connecting using the DSN selected, not by the initial connection string.
They tell me that they are not popping up the dialogue box... Windows does because my connection string fails. I have no way to confirm that.
21
ODBC / ODBC Connection string
« on: March 01, 2019, 01:23:53 PM »
I'm trying to create an ODBC connection string that can be used by a third party product to access a couple PxPlus data files.
I have the ODBC server and client setup.
I have been able to successfully extract data from the PXPlus files using Excel with this connection string:
DRIVER={PxPlus® ODBC Driver (32-bit)};Directory=/my_dir/sub_dir/;RemotePVKIOHost=192.168.xxx.xxx
*Note - when using Excel, credentials are tendered in a separate screen, but in the other software, I'm adding ";uid=user" to the connection string (no password).
I also successfully got data using Excel by simply specifying a DSN in the connection string:
DSN=Shipping
However, when using either of the connection strings above in the third party software, it failed.
I have tried variations of the above connection strings with additional keywords, but got similar results... They succeed in Excel, but fail in the other software. They assure me they are simply taking the connection string I provide without any manipulation.
Any ideas why it works with Excel, but not the other software? Is Excel manipulating the connection string I provide?
Server:
RedHat 7.5
PxPlus 11.65
ODBC 5.20
Client
ODBC 5.20
I have the ODBC server and client setup.
I have been able to successfully extract data from the PXPlus files using Excel with this connection string:
DRIVER={PxPlus® ODBC Driver (32-bit)};Directory=/my_dir/sub_dir/;RemotePVKIOHost=192.168.xxx.xxx
*Note - when using Excel, credentials are tendered in a separate screen, but in the other software, I'm adding ";uid=user" to the connection string (no password).
I also successfully got data using Excel by simply specifying a DSN in the connection string:
DSN=Shipping
However, when using either of the connection strings above in the third party software, it failed.
I have tried variations of the above connection strings with additional keywords, but got similar results... They succeed in Excel, but fail in the other software. They assure me they are simply taking the connection string I provide without any manipulation.
Any ideas why it works with Excel, but not the other software? Is Excel manipulating the connection string I provide?
Server:
RedHat 7.5
PxPlus 11.65
ODBC 5.20
Client
ODBC 5.20
22
Language / Re: Update a LIST_BOX
« on: July 25, 2018, 11:21:13 AM »
Ed,
You have to remove the currently selected item, add your new item, then select it. See lines 52-58 below
0010 print 'CS'; list
0020 list_box 100,@(2,14,12,6),fnt="*"
0030 list_box load 100,"Dog/Cat/Pig/"; wait 1
0040 list_box write 100,"Cat"; wait 1
0050 ! list_box load 100,1,*
0052 list_box read 100,_index ! Get index of current selection
0054 list_box load 100,_index,* ! Remove current selection
0056 list_box load 100,_index,"T-Rex" ! Add this one in its place
0058 list_box write 100,"T-Rex" ! Select the new option
0060 end
You have to remove the currently selected item, add your new item, then select it. See lines 52-58 below
0010 print 'CS'; list
0020 list_box 100,@(2,14,12,6),fnt="*"
0030 list_box load 100,"Dog/Cat/Pig/"; wait 1
0040 list_box write 100,"Cat"; wait 1
0050 ! list_box load 100,1,*
0052 list_box read 100,_index ! Get index of current selection
0054 list_box load 100,_index,* ! Remove current selection
0056 list_box load 100,_index,"T-Rex" ! Add this one in its place
0058 list_box write 100,"T-Rex" ! Select the new option
0060 end
Pages: 1 [2]