PxPlus User Forum

Twitter Twitter Twitter

Recent Posts

Pages: 1 ... 8 9 [10]
91
ODBC / Re: UPdtae table send me message column not found
« Last post by eldonfsr on February 29, 2024, 11:41:26 AM »
Thanks so much for your replay  i appreciate this.
 
there a way from command line run utility to fix that problem... because i don't have nomads  for 32 bits...the version i have is 64 bits and don't know could affect all information on table.
92
ODBC / Re: UPdtae table send me message column not found
« Last post by EVa on February 29, 2024, 05:44:45 AM »
I can't help you with that - you need to contact whoever created the file/dictionary entry as it looks like these do not match.
93
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by jhendrickx00 on February 28, 2024, 03:32:05 PM »
Hi Mike thanks for your (very) valuable feedback; the 'background problem' can arise because some of this 'notifications' can be money-related (Money on place/The delivery took the money/Money at warehouse/Money left place X/...), and of course, this could be very atractive to someone with 'not so clear intentions', so the security is important ... we consider to develop a HTML page (no Webster/PxP+) and refresh it every 5 minutes or so, then call the Webster+page, if there changes, show the changed, update the results and be back to the 'wating page', but still we're just gathering info; my first goal was to try to keep the development with an all-pxplus solution, but perhaps using a mix one should get better results.

Jean H//
94
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by Mike King on February 28, 2024, 10:35:43 AM »
I was thinking about your issue last night and wondering if perhaps the easiest solution for you would be to use RSS.

There are a number of free RSS readers for Windows and other platforms, many of which can reside in the task bar or run in the background and display an alert when an RSS feed changes. 

On the server you could create RSS files and have your  internet web server (Apache, IIS, etc) simply serve up the RSS file.  Depending on your needs you could have multiple RSS feeds, a global for all users, company specific feeds, even user specific feeds.  These RSS files could be updated on the server as required using PxPlus either as the events occur or by a background task.  As for load, most servers can easily handle 1000s of requests per minute if all they are doing is forwarding a data file (the RSS feed).  This avoids you having to worry about how many PxPlus licenses you might need as PxPlus would not be directly involved in the RSS request.

Of course a lot of this depends on exactly what your application requirements are, but using RSS might be a real simple solution.

BTW: Another solution might be to use something like WhatsApp to send messages.  This is something I am looking at presently.



95
ODBC / Re: UPdtae table send me message column not found
« Last post by eldonfsr on February 28, 2024, 09:26:13 AM »
The dictionary is of mas90 countrycode is string 3  and look only accept 2...
96
ODBC / Re: UPdtae table send me message column not found
« Last post by eldonfsr on February 28, 2024, 09:22:05 AM »
Thanks for you time and help me here image of my test and file definition... some look is take country as length of 2 but is 3 characters string..
97
ODBC / Re: UPdtae table send me message column not found
« Last post by EVa on February 28, 2024, 03:20:45 AM »
Doesn't happen here, but I don't have your dictionary information.  When my table has this data:

1:dump
ADDRESSLINE1$="addressline #1"
ADDRESSLINE2$="addressline #2"
ADDRESSLINE3$="addressline #3"
CITY$="City"
COUNTRYCODE$="USA"
CUSTOMERNAME$="Customer CMS00"
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="NY"

and I execute this update:  UPDATE AR1_CustomerMaster SET CustomerName='California Metal Services Inc ' ,AddressLine1= '1428 W Mission Road ',AddressLine2= '1430 ',AddressLine3= ' ',City='ESCONDIDO ' ,State= 'CA ' ,CountryCode= 'SA ' where   Division='00' and CustomerNumber='CMS'

the table then has this data:

1:dump
ADDRESSLINE1$="1428 W Mission Road "
ADDRESSLINE2$="1430 "
ADDRESSLINE3$=" "
CITY$="ESCONDIDO "
COUNTRYCODE$="SA "
CUSTOMERNAME$="California Metal Services Inc "
CUSTOMERNUMBER$="CMS"
DIVISION$="00"
STATE$="CA "

which is correct.  If this doesn't work for you, I would suspect that the dictionary information isn't correct.
98
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by Mike King on February 27, 2024, 08:20:53 PM »
There are a number of ways you could handle this.  You actually have two issues, one is the central server that the desktops will connect to and will serve up the status changes, the other is the software on the workstation.

For the central server you should be able to use PxPlus to handle the load.  To determine the number of concurrent users you would need to determine how long a request takes to respond and the frequency that you want workstations updated.

For the workstation this would be fairly easy to do using PxPlus however the license costs might be prohibitive.  If you find that is the case you could use something like powershell to create a workstation process or create a C, .NET or VB application to do the same. 

Now technically depending on your actual application requirements you might be able to have the host simply maintain 'status files' on the server and use Apache (or any other web service like IIS) simply serve up the status files.  PxPlus could update the status files as needed.

Last, but not least, you might be able to use Web Notifications as that may provide you the functionality you are looking for.

Of course, all of the above depends a lot on the exact needs of your application.


99
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by jhendrickx00 on February 27, 2024, 06:38:29 PM »
 We're planning to develop a kind of widget who will be running at every desk/user (It's like a delivery control system and the want to know when the package changes its status, to take some metrics and then develop a plan to enhance the procedures), the 'problem' is: In a blink this could rise the thousand of users; some customers can have 10+ users and now there around 100 customers (and they plan to twofold the customer when the system be online... Of course, we need to tell them about the user load (for choose the [hardware] server) and the number of licenses... Any thoughts?

TIA
100
ODBC / Re: UPdtae table send me message column not found
« Last post by eldonfsr on February 27, 2024, 04:41:59 PM »
Yes looks is working but if you check the information on table is not show up as must be some information from column is put into other column spread the information
UPDATE  AR1_CustomerMaster  SET  CustomerName=''California Metal Services Inc'' ,AddressLine1=''1428 W Mission Road'',AddressLine2=''1430 '',AddressLine3='' '',City=''CARLSBAD'' ,State=''CA'' ,CountryCode=''USA'', ZipCode=''92008''  where   Division=''00'' and CustomerNumber=''CMS''

you see countrycode is now as in sql ... some put in conactcode and other countrycode

some strange on sqlodbc...
 


Pages: 1 ... 8 9 [10]