PxPlus User Forum

Twitter Twitter Twitter

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.


Topics - Jeffrey Ferreira

Pages: [1] 2 3 4
1
Language / Trapping for Escape Key
« on: May 18, 2022, 10:58:45 AM »
Hello,

Is there any way to trap for the ESC key being hit. I tried _EOM$ and ctl but i cannot seem to distinguish it from clicking the X-Close .
or would i need to modify *UCK

thanks

jeff

2
Programming / providex.usr - Auto Create
« on: April 29, 2022, 03:57:47 PM »
Hello List,

In old pxplus. Is there a way i could automatically create the providex.usr file.
A client is looking for me to make a wizard to create a USER by just answering a few questions.
i should have posted this in "Language"

Thank

jeff

3
Programming / Converting HTML to PDF
« on: April 25, 2022, 03:59:58 PM »
Hi All,
I have a need to convert an HTML Page to a PDF programatically. I've done it manually and it converts real nice.  I was curious about that pxplus chromium object....do you think that could do it?

I should elaborate...when you have a web page open thru chrome...you can print it to pdf and it comes out really nice...i was wondering if i opened a web page thru that chromium object if i could that...i did try it and i could not seem to access any of the methods/properties...that is when i posted to list...

jeff

4
Language / Convert PxPlus File to CSV
« on: March 01, 2022, 08:02:21 AM »
Hello All,

I know you can convert a grid or list box to an csv.  Are there any Utilities out there that will take a PxPlus and convert it to a CSV file. I figured I would ask before creating it.

thanks

jeff

5
ODBC / ODBC / Linked Server
« on: February 08, 2022, 09:37:04 AM »
Hello All,

We are trying to attempt is to set up a linked server in SQL as a read only to pull data from a Pxplus database. The linked server is an ODBC type using the 5.20 64 bit driver and we can see all the tables but we cannot query anything. Using Excel we are able to pull data using the same odbc connection but SQL locks up all users and does nothing. The SQL server is in Azure and we are using SSMS to access the connection. We have tried this before with the same result on older versions of SQL both 3.50 64 bit and the 4.21.1 32 bit. Has anyone ever been able to get linked server to work in SQL or is it just not compatible?

thanks

jeff

6
ODBC / Getting a View to Show ODBC
« on: January 21, 2022, 01:32:21 PM »
Hi List,

I'm trying to start using Views to make complex file linking easier for our customers. I'm having trouble getting the Views to display in my ODBC DSN.  I see the views dll...i dont have that filled in...can someone give me some pointers.

jeff

7
Language / Error in Character Editor
« on: January 10, 2022, 11:06:42 AM »
Hi All,

I know I should use GUI editor but I like some features in the character editor...but I cannot save programs in Character editor.
I get an error 41 at line 5039

5039 print 'textwdw'(-200,-200,mxc(0)+2,mxl(0)+2,'CS'),

i do have a bigger monitor...does anyone know how i can fix this?

thanks

jeff

8
ODBC / Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« on: October 19, 2021, 11:04:36 AM »
Hello All

I have a client that does the following using Crystal and PxPlus ODBC Driver:

-> Links Order Header to Order Lines (works fine)
-> Links Order Lines to Inventory Master (works fine)
-> Links Order Header to Order Lines and Order Lines to Inventory Master (fails)

I don't know if it is a Crystal Problem or a PxPlus ODBC problem. Has anyone else had an issue like this

jeff

9
Nomads / Scrolling in a panel
« on: September 14, 2021, 04:55:08 PM »
Hello,

If i make panel resizable. Is there any way to get vertical and horizontal scroll bars on it...it is a tabbed panel.
i dont know if that is confounding things.

thanks

jeff

10
Language / Determine Viewer
« on: June 23, 2021, 02:38:28 PM »
Hello List,

When we open a printer - we can do the following
print fin(print_chan,"DEVICE")  ! Determine Printer

If we open the *viewer* is there any sure fire way to determine that we have the Viewer Open

thanks

Jeff

11
Language / Was Program Called
« on: June 16, 2021, 10:53:39 AM »
Hi List

To determine if a program was called:
Thru the years, i've seen programs check tcb(13)<>0 but I have had problems with that.
Then i saw check tcb(20) but then I encountered programs called with no arguments.

Is there any sure fire fool proof way to know if a program was called.

jeff

12
Off Topic / Determining a Cell Provider
« on: May 21, 2021, 01:22:51 PM »
Hello List,

I have a client that wants to send texts from our software ...the only problem is that is in order for me to do it i need to attach the extension of the phone carrier like @vtext.com @att.text.com, does anyone at any of the divisions know of an api or something i can use that can tell me the extension of a phone carrier..i found a web site but i would love to do it programatically.

any help is appreciated...

thanks

jeff

13
Programming / Does PID Exist
« on: May 20, 2021, 09:41:07 AM »
Hi All, i've done this with various dos utilities and powershell but does anyone have / know of some function/black box to pass in a Process ID in Windows and return a boolean if process exists.

14
Programming / Reverse Engineer Print @
« on: May 13, 2021, 12:00:46 PM »
Hello All
If I have a text file that contains print @ like this

->print@(0),"Jeff",@(20),"PxPlus",@(50),"Canada"
Jeff                PxPlus                        Canada

I want to convert the string containing the print @ to the nicely formatted with spaces...
is there a way to do that.

Jeff



15
Language / Nomads Adding Security Class to Control
« on: May 03, 2021, 03:10:28 PM »
Hello All,

We've used a feature of pxplus for several years now whereby we add a Security Class to a control if the Client requests "That they never want to see that field."
It has worked perfect over the years. No matter what group it is in, no matter what code hides/shows control, the customer will never see it because No One is a member of that security class.

Recently as we have migrated to new versions of pxplus, we are noticing it still hides the control but it leaves the query button on screen.

has anyone seen this and is there any fix we can add to any pxplus programs that could help solve this problem.

Jeff

Pages: [1] 2 3 4