PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: [1] 2 3 ... 10
1
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« Last post by Mike King on August 17, 2022, 06:44:57 PM »
Well if the database is using SQL Server you might be able to use the Microsoft Linux connector.  Its not the easiest thing to setup but this link should get you started.

https://manual.pvxplus.com/?/PxPlus%20User%20Guide/Data%20Integration/Odbc%20Linking.htm

Basically you need to install unixODBC on your Linux box along with the Microsoft SQL Server ODBC Driver for Linux
2
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« Last post by nmartinez@bristolind.com on August 17, 2022, 06:31:08 PM »
Hi Mike,
One last issue we are having.  Our Web Program needs to be able to access data from one of our ERPs (JD Edwards).  The way it has always been done  is by using "[WDX][ODB]" from any of our Windows computers, but the Web Program now resides on our Red Hat LINUX host server and we are using EZWeb.  How do we use DSN/ODBC on this server and this Web Program?  Do we need to install any additional software from PvxPlus, so we can use the ODBC on RedHat Linux?
Thank you!
3
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« Last post by nmartinez@bristolind.com on August 17, 2022, 04:59:50 PM »
Thank you !!
Just copied the START_UP program we use with our current ERP  to the starting directory we are using with  EZWeb server.
Our TEST application is working perfectly now thanks to you sir Mike!!
4
Webster Plus / Re: update dropdown [list] inside grid
« Last post by Mike King on August 17, 2022, 10:42:17 AM »
Something you might want to consider when using a grid with a list if values, when the page is generated that list of values will be included in the page for each line, so if your list of values has say 20 items and your grid has 100 lines, that becomes 2000 items that will be included in the HTML form.

You might find it easier to make the field a locked input with a query and set the background color to White using the class fill_white.  This will eliminate having the list items replicated on each row of the grid.  Just set the query to a Drop Query.  Other advantages using the drop query are that you can include multiple columns in the display which may assist the end user and the data is dynamic -- i.e. loaded when the query button is clicked.

Of course this assumes that the options can be sourced from a query.
5
Webster Plus / Re: update dropdown [list] inside grid
« Last post by Mike King on August 17, 2022, 08:35:58 AM »
You would provide the name of the Grid so the system can update it.

Technically there is no field called project_code$ since this is a column in a grid which makes its internal name is gridname-row-project_code$ but you cannot reload a specific col/cell as its not a valid variable name.
6
Webster Plus / Re: update dropdown [list] inside grid
« Last post by Zereliq on August 17, 2022, 03:51:01 AM »
I might be doing something wrong so here's the code I'm using and what it returns:

Code: [Select]
col Source=project_code$ ttl="project" width=30 nosort][list project_code$][data rowsep=/ valsep=: text=(project_tbl$)][/list][/col]
Code: [Select]
%WEBSTER'BIND'RELOAD("project_code$")shows the following in console: ** Could not set: project_code$ == '<select id='**UPD**' name='project_code$'></select>' **

if I do a %WEBSTER'BIND'RELOAD on the name displayed in the live html code, (grid_eiguurf1-1-project_code$) then it doesnt return anything in console
so still only updates in the background.

7
Webster Plus / Re: update dropdown [list] inside grid
« Last post by Mike King on August 16, 2022, 11:29:37 AM »
Have you tried %webster'Bind'Reload("name_of_list")?

This should reload the list definition including any drop box values.
8
Webster Plus / update dropdown [list] inside grid
« Last post by Zereliq on August 16, 2022, 10:45:53 AM »
      Hi,I'm currently working on an app to register our companies worked hours online via Webster+
      but trying to get some list elements inside a grid to refresh in frontend does not seem to be working.

      What i want to have happen is the moment i change our "debiteur" column (which i do via a lookup table see image1)
      change the content of the dropdown in column "project", my console confirms changing the values but it does not
      show in frontend(image2)

      Is there a way to refresh just the list elements without refreshing the page? (this will make me lose entered values)



9
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« Last post by Mike King on August 16, 2022, 08:54:26 AM »
You appear to be looking for the file/program "#A" as this is in ERR(LastPath). 

File and programs used by your web program need to be accessible by your program.  This could be done using the PREFIX directive to access files/programs external of the directory where your web application is running or  (on Linux) you could using file system links for the files.
10
Web Services / Re: Setup EZWeb server on RedHat Linux 8.x Server
« Last post by EVa on August 16, 2022, 02:54:20 AM »
And what does line 160 of program ltstulip.pxp look like ?
Pages: [1] 2 3 ... 10