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.
1
ODBC / Re: ODBC Views Issue
« on: May 02, 2023, 07:46:30 AM »
devon, Thanks for your answer, I was able to get it working.
2
ODBC / Re: ODBC Views Issue
« on: April 28, 2023, 11:41:39 AM »
hi devon,
If I have the sql odbc driver installed as a client, in the options tab I can include an address of a network shared folder, for example: \\12.8.1.54\PXPlus19\Pxplus, this being the directory where the pvxwin32.dll is located? With that configuration, would it show the views?
If I have the sql odbc driver installed as a client, in the options tab I can include an address of a network shared folder, for example: \\12.8.1.54\PXPlus19\Pxplus, this being the directory where the pvxwin32.dll is located? With that configuration, would it show the views?
4
ODBC / Re: ODBC Views Issue
« on: April 26, 2023, 08:33:33 AM »
Hi devon,
thanks for your answer, we did that setup, in fact we have other views that work without errors, but this one has that error.
thanks for your answer, we did that setup, in fact we have other views that work without errors, but this one has that error.
5
ODBC / ODBC Views Issue
« on: April 25, 2023, 07:52:48 PM »
hello All,
we are trying to query data from a view in excel and we are getting this error (attached in the screenshot).
The thing is that when we try the query from Excel to the same file from which the view was created, we can access the data.
What could be happening?
we are using a Pxplus Sql ODBC Driver Version 7 and Pxplus Version 19.1
we are trying to query data from a view in excel and we are getting this error (attached in the screenshot).
The thing is that when we try the query from Excel to the same file from which the view was created, we can access the data.
What could be happening?
we are using a Pxplus Sql ODBC Driver Version 7 and Pxplus Version 19.1
7
Webster Plus / Webster Queries
« on: April 05, 2023, 01:11:02 PM »
Hello everyone !
In webster plus, queries don't have a search field?
In webster plus, queries don't have a search field?
8
Nomads / Re: Message/Status Bar Updates
« on: November 02, 2022, 04:37:27 PM »
hi james,
if you are using pxplus v10 or higher, you may want to use the listbox and grid system popup menu to accomplish this by simply calling a routine
For more info:
https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/Creating%20Panel%20Controls/Popup%20Menu/List%20Box%20and%20Grid%20System%20Popup%20Menu.htm
if you are using pxplus v10 or higher, you may want to use the listbox and grid system popup menu to accomplish this by simply calling a routine
Code: [Select]
CALL "*plus/winutl/listpopup;Export_to_File",ctl_no,exportfile$For more info:
https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/Creating%20Panel%20Controls/Popup%20Menu/List%20Box%20and%20Grid%20System%20Popup%20Menu.htm
9
iNomads / Bar Code Reading in iNomads
« on: July 14, 2022, 05:41:06 PM »
hello everyone,
we are trying to use the "*plus/inomads/scanner" tool to read barcodes on mobile devices (iPhone/iPad) and it always generates an 11 error on the line that calls this routine.
on android devices it opens the code reader application but it does not return the read value, has anyone used this tool that can give me some help?
This is a sample of how I am calling the routine:
For Android:
For iPad/iPhone:
we are trying to use the "*plus/inomads/scanner" tool to read barcodes on mobile devices (iPhone/iPad) and it always generates an 11 error on the line that calls this routine.
on android devices it opens the code reader application but it does not return the read value, has anyone used this tool that can give me some help?
This is a sample of how I am calling the routine:
For Android:
Code: [Select]
CALL "*plus/inomads/scanner",x_dat$,"CODABAR,CODE_39,CODE_93,CODE_128,QR_CODE"For iPad/iPhone:
Code: [Select]
CALL "*plus/inomads/scanner",x_dat$,"QR_CODE"
10
Programming / Re: Looking for PxPlus based ERP Wholesale Distribution System
« on: June 29, 2022, 05:34:21 PM »
mike,
Thank you very much for this contribution, for days we have wanted to experiment with webster to rebuild our erp directly for the web.
so this helps us to take the first steps.
Thank you very much for this contribution, for days we have wanted to experiment with webster to rebuild our erp directly for the web.
so this helps us to take the first steps.
11
iNomads / Re: Fav Icon On Inomads
« on: May 20, 2022, 10:36:53 AM »
Mike,
thank you very much! it worked!
thank you very much! it worked!
12
Language / Re: Trapping for Escape Key
« on: May 18, 2022, 01:22:24 PM »
Hi jeffrey,
try this
try this
Code: [Select]
ignore_exit=0
IF CTL=-1999 OR CTL=4 THEN {
MSGBOX "Do you want to exit the process ?","Exit",?,YESNO,tim=3",resp$
IF resp$<>"YES" THEN ignore_exit=1; RETURN
}
13
iNomads / Fav Icon On Inomads
« on: May 17, 2022, 10:40:37 AM »
Hello everyone,
Is there a way to put a custom favorite icon in the inomads template?
Is there a way to put a custom favorite icon in the inomads template?
14
iNomads / Re: how to extract a value passed in the url
« on: April 01, 2022, 02:02:18 PM »
Thank you all for reply,
Stéphane,
1-yes, we change the path to where we have pxplus installed.
2-Pxplus is not installed in the program files.
Mike,
1-we bought the license with a reseller, we will contact them to help us.
2-I will try using the method indicated.
3-Webster+ can be used with a Wayfer license? or do we have to upgrade?
Stéphane,
1-yes, we change the path to where we have pxplus installed.
2-Pxplus is not installed in the program files.
Mike,
1-we bought the license with a reseller, we will contact them to help us.
2-I will try using the method indicated.
3-Webster+ can be used with a Wayfer license? or do we have to upgrade?
15
iNomads / how to extract a value passed in the url
« on: April 01, 2022, 09:37:07 AM »
Hello everyone,
we are trying to query a receipt or invoice with inomads directly passing the receipt number through the url, so we need to extract the value from the url.
we have read the manual tried several ways but we have not been able to achieve it.
we have a transaction called "qryrec" and we want to pass the value "5580" and later extract that value.
for example:
http://website.com/?txid=qryrec&?id=5580
We also add the PxPlus program CGI handler as specified in https://manual.pvxplus.com/PXPLUS/apache/sampleinstall.htm, but when we try to run the program we get this message "Submission rejected. Web server license not found."
note:
Pxplus 2021 V18.1 Wayfer license .
we are using apeche 2.4 web server.
We are new to using inomads, so if anyone can help us, we would really appreciate it.
we are trying to query a receipt or invoice with inomads directly passing the receipt number through the url, so we need to extract the value from the url.
we have read the manual tried several ways but we have not been able to achieve it.
we have a transaction called "qryrec" and we want to pass the value "5580" and later extract that value.
for example:
http://website.com/?txid=qryrec&?id=5580
We also add the PxPlus program CGI handler as specified in https://manual.pvxplus.com/PXPLUS/apache/sampleinstall.htm, but when we try to run the program we get this message "Submission rejected. Web server license not found."
note:
Pxplus 2021 V18.1 Wayfer license .
we are using apeche 2.4 web server.
We are new to using inomads, so if anyone can help us, we would really appreciate it.