Recent Posts
91
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..
92
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.
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.
93
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.
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.
94
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
TIA
95
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...
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...
96
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by Mike King on February 27, 2024, 02:46:05 PM »Webster+ uses the PxPlus Web server interface which can run on EZWeb, Apache, or IIS uses a user slot for the duration of the process. That is a user slot will be needed/allocated when the host server receives the request then freed up once the request has been completed.
When using the Web Server interface there is nothing actually running on the server until the user makes the request.
In normal Windows/Linux processing once the user starts the application a user slot is allocated and will remain in use until they totally exit the application and all processes have completed.
For example on Windows/Linux non-Web applications there is always at least one process running on the server and as such it requires a user slot for the duration. When running using the Web server interface when a request is received a PxPlus process is started (using a user slot) and terminated once the response is sent.
When using the Web Server interface there is nothing actually running on the server until the user makes the request.
In normal Windows/Linux processing once the user starts the application a user slot is allocated and will remain in use until they totally exit the application and all processes have completed.
For example on Windows/Linux non-Web applications there is always at least one process running on the server and as such it requires a user slot for the duration. When running using the Web server interface when a request is received a PxPlus process is started (using a user slot) and terminated once the response is sent.
97
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« Last post by jhendrickx00 on February 27, 2024, 12:35:22 PM »Hi Mike, can you explain how are handled the users in Webster+?
98
ODBC / Re: UPdtae table send me message column not found
« Last post by EVa on February 27, 2024, 04:15:08 AM »It works here when I replace " with ' :
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'
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'
99
ODBC / UPdtae table send me message column not found
« Last post by eldonfsr on February 26, 2024, 03:52:35 PM »Hello well juts testing to run sql look message i follow documentation and examples to write sql statement correct
just on first column the values must be on single '' or bouble "" , if i put on single '' don't send error but all information is mixed on fields , so put "" and send this error...what i doing wrong..
SQL Error: [ProvideX][ODBC Driver]Column not found: California Metal Services Inc
Code: -2147467259 SQL: 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"
just on first column the values must be on single '' or bouble "" , if i put on single '' don't send error but all information is mixed on fields , so put "" and send this error...what i doing wrong..
SQL Error: [ProvideX][ODBC Driver]Column not found: California Metal Services Inc
Code: -2147467259 SQL: 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"
100
Programming / Re: Sign XML Documents with Digital Signatures
« Last post by HendersonS on February 23, 2024, 12:43:19 PM »Loren, thanks for your demonstration,
so far I have not been able to install xmlsec on Windows, and I have not been able to find a solution with pxplus either, so I will have to make some program in C# or another language to invoke it from pxplus, since I do not see a solution with pxplus.
so far I have not been able to install xmlsec on Windows, and I have not been able to find a solution with pxplus either, so I will have to make some program in C# or another language to invoke it from pxplus, since I do not see a solution with pxplus.