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
Web Server - Ask For Help / Cookie handling
« on: December 02, 2024, 01:15:42 PM »
Hello,
I would like to set a cookie with livetime of some minutes for a webserver. The value is the user id of the person who logged in. If the user leaves and calls again the webserver within the amount of the livetime of the cooke he should not have to login again.
for that I set the cookie directly after the login:
p_web.SetCookie('MAGWebUserLoggedIn',UserId,TODAY(),CLOCK()+xMinutes*6000)
Directly after setting the cookie I can read the value of the UserId by
UserId = p_web.GetCookie('MAGWebUserLoggedIn')
Unfortunately, if I start a new window of the browser and read at the beginning of my indexpage i don't get the UserId by the command
UserId = p_web.GetCookie('MAGWebUserLoggedIn')
The cookie is empty.
But if I look in my new browser window with F12 at the cookie list I see my cookie, see attachment.
Does somebody know, why I can't read this cookie in a new session?
Thanks for any help.
Cheers
Heinz
I would like to set a cookie with livetime of some minutes for a webserver. The value is the user id of the person who logged in. If the user leaves and calls again the webserver within the amount of the livetime of the cooke he should not have to login again.
for that I set the cookie directly after the login:
p_web.SetCookie('MAGWebUserLoggedIn',UserId,TODAY(),CLOCK()+xMinutes*6000)
Directly after setting the cookie I can read the value of the UserId by
UserId = p_web.GetCookie('MAGWebUserLoggedIn')
Unfortunately, if I start a new window of the browser and read at the beginning of my indexpage i don't get the UserId by the command
UserId = p_web.GetCookie('MAGWebUserLoggedIn')
The cookie is empty.
But if I look in my new browser window with F12 at the cookie list I see my cookie, see attachment.
Does somebody know, why I can't read this cookie in a new session?
Thanks for any help.
Cheers
Heinz
2
Web Server - Ask For Help / msvcr140.dll is missing
« on: May 28, 2024, 01:27:33 AM »
Hello,
I tried to configure email sending on a windows server 2022. For this I used netdemo / Email send.
The email should be send by smtp.office365.com. On sending the test email I get the message that some dll's could not be loaded.
Everything is present but not msvcr140.dll.
Is this a microsoft dll? Can somebody help?
Cheers
Heinz
I tried to configure email sending on a windows server 2022. For this I used netdemo / Email send.
The email should be send by smtp.office365.com. On sending the test email I get the message that some dll's could not be loaded.
Everything is present but not msvcr140.dll.
Is this a microsoft dll? Can somebody help?
Cheers
Heinz
3
Web Server - Ask For Help / Calling a form by URL from external
« on: February 07, 2023, 06:50:48 AM »
Hello,
my aim is to create an email which contains the URL to work on a specific order in the web application.
This email is NOT created by a NetTalk web application but by a normal clarion application. Therefore it does not know anything about row Id (as mentioned in https://www.capesoft.com/docs/NetTalk9/NetTalkWebFAQ.htm#W4)
I tried the old example mentioned there, in my case it looks the following:
http://appserver:2338/WebUpdateAuftraege?WAF:Auftragsnummer=15761&change_btn=change
To use the form WebUpdateAuftraege the user has to be logged in. Therefore, if I use the link of the email, I am first redirected to the login page and the get to the update form.
But there the correct record is not read, the form is empty beside the order number (15761).
If I instead copy the URL in a browser tab, where I before logged in to the web application and the user is known, the link works, the correct orders is loaded and displayed, can be changed and save as expected.
The URL in this case still is displayed after loading the record.
Before, with the redirection, the URL I see in the update form is http://appserver:2338/WebUpdateAuftraege?_chain_=1
Is there a way to call an update form from external without having the nettalk row Id (with redirection to a login form)?
Thanks for every help.
Cheers
Heinz
my aim is to create an email which contains the URL to work on a specific order in the web application.
This email is NOT created by a NetTalk web application but by a normal clarion application. Therefore it does not know anything about row Id (as mentioned in https://www.capesoft.com/docs/NetTalk9/NetTalkWebFAQ.htm#W4)
I tried the old example mentioned there, in my case it looks the following:
http://appserver:2338/WebUpdateAuftraege?WAF:Auftragsnummer=15761&change_btn=change
To use the form WebUpdateAuftraege the user has to be logged in. Therefore, if I use the link of the email, I am first redirected to the login page and the get to the update form.
But there the correct record is not read, the form is empty beside the order number (15761).
If I instead copy the URL in a browser tab, where I before logged in to the web application and the user is known, the link works, the correct orders is loaded and displayed, can be changed and save as expected.
The URL in this case still is displayed after loading the record.
Before, with the redirection, the URL I see in the update form is http://appserver:2338/WebUpdateAuftraege?_chain_=1
Is there a way to call an update form from external without having the nettalk row Id (with redirection to a login form)?
Thanks for every help.
Cheers
Heinz
4
Web Server - Ask For Help / Nettalk File Error 33 with SQL Express
« on: July 20, 2022, 12:36:07 AM »
Hello,
I am using NetTalk 12.41 and SQL Express.
I have a browse with an Edit in Place Checkbox.
If I check some lines in the browse fast the WebServer produces an error message (error 33) and also DebugView gets error messages.
67 29.923422 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
68 29.931760 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
69 29.932107 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
70 29.932671 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
The problem is, the error messages appear on the server, mostly the webserver runs as windows service and nobody sees them. Then the web server hangs.
Does someone know how to trap these file error messages to get no message boxes in the web server?
Thanks in advance
Cheers
Heinz
I am using NetTalk 12.41 and SQL Express.
I have a browse with an Edit in Place Checkbox.
If I check some lines in the browse fast the WebServer produces an error message (error 33) and also DebugView gets error messages.
67 29.923422 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
68 29.931760 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
69 29.932107 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
70 29.932671 15280 MagWeb.exe [st] [netTalk][thread=4] NETTALK FILE ERROR: 33 Satz nicht verf?gbar! :: 0
The problem is, the error messages appear on the server, mostly the webserver runs as windows service and nobody sees them. Then the web server hangs.
Does someone know how to trap these file error messages to get no message boxes in the web server?
Thanks in advance
Cheers
Heinz
5
Web Server - Ask For Help / Client countdown
« on: March 18, 2021, 07:51:58 AM »
Hello,
I want to offer the user a countdown for being logged out and of course activate the countdown on client side.
I found no example where I can see this all. I found some where page footer the embed code
if (p_web.GetSessionLoggedIn() and p_web.PageName <> 'LoginForm')
! parameter 1 is the session time
! parameter 2 is the name of the login page.
! parameter 3 is the id of the <div> in the html.
p_web.Script('startCountDown('& int(p_web.site.SessionExpiryAfterHS/100) &',"' & clip(p_web.site.DefaultPage) & '?logout_btn=logout_btn","countdown");')
end
is present (one is web67), but the logout is not performed. Also I did not succeed to show the user the count down.
Is there an example which contains all that?
What can be wrong?
Where exactly I have to insert the code for showing the countdown to the user?
Thanks for every help.
Cheers
Heinz
I want to offer the user a countdown for being logged out and of course activate the countdown on client side.
I found no example where I can see this all. I found some where page footer the embed code
if (p_web.GetSessionLoggedIn() and p_web.PageName <> 'LoginForm')
! parameter 1 is the session time
! parameter 2 is the name of the login page.
! parameter 3 is the id of the <div> in the html.
p_web.Script('startCountDown('& int(p_web.site.SessionExpiryAfterHS/100) &',"' & clip(p_web.site.DefaultPage) & '?logout_btn=logout_btn","countdown");')
end
is present (one is web67), but the logout is not performed. Also I did not succeed to show the user the count down.
Is there an example which contains all that?
What can be wrong?
Where exactly I have to insert the code for showing the countdown to the user?
Thanks for every help.
Cheers
Heinz
6
Web Server - Ask For Help / Manually saving form contents
« on: October 07, 2020, 07:09:12 AM »
Hello,
I have a NetForm, based on Memory, and do updates to database manually with a button, calling the form itself with an action parameter. This action parameter is evaluated on GenerateForm, and
gets the contents by GSVs on the form fields, then does the save action.
This works well beside one point: there is only one text field and the save button on the form. If I change the text WITHOUT leaving the field by tab the entered content is not available by a GSV.
If I first leave the field and then press my save button the text is available.
Can I do something to get the text without accepting the textfield, that means write text and directly press SAVE?
Thanks a lot
Cheers
Heinz
I have a NetForm, based on Memory, and do updates to database manually with a button, calling the form itself with an action parameter. This action parameter is evaluated on GenerateForm, and
gets the contents by GSVs on the form fields, then does the save action.
This works well beside one point: there is only one text field and the save button on the form. If I change the text WITHOUT leaving the field by tab the entered content is not available by a GSV.
If I first leave the field and then press my save button the text is available.
Can I do something to get the text without accepting the textfield, that means write text and directly press SAVE?
Thanks a lot
Cheers
Heinz
7
Web Server - Ask For Help / NetBrowse does not refresh after delete
« on: May 04, 2020, 01:15:48 AM »
Hello,
I don't know exactly when i began, but there was a NetTalk version where after a deleting a record the browse was automatically refreshed and the deleted record no longer displayed.
Now with Clarion 11/NetTalk 11.32 this does not work.
I have a delete record button in every line of the browse. The record really is deleted, but the browse does not refresh, I need to press F5 or change the page and go back to see the effect.
In a previous version of NetTalk this worked automatically, but I cannot say which version exact, the clanet.dll shows no version nummber, but it has a change date 10/26/2018.
I have this effect in all my browse/form combinations.
Has someone an idea what to do to get the browses freshed automatically?
Thanks a lot.
Cheers
Heinz
I don't know exactly when i began, but there was a NetTalk version where after a deleting a record the browse was automatically refreshed and the deleted record no longer displayed.
Now with Clarion 11/NetTalk 11.32 this does not work.
I have a delete record button in every line of the browse. The record really is deleted, but the browse does not refresh, I need to press F5 or change the page and go back to see the effect.
In a previous version of NetTalk this worked automatically, but I cannot say which version exact, the clanet.dll shows no version nummber, but it has a change date 10/26/2018.
I have this effect in all my browse/form combinations.
Has someone an idea what to do to get the browses freshed automatically?
Thanks a lot.
Cheers
Heinz
8
Web Server - Ask For Help / NetWebClient and jFiles
« on: April 15, 2020, 04:15:50 AM »
Hello,
I have a small test app with a NetWebClient to send request to a WebService.
This works very well. The content of the pages I receive are json objects.
Therefore I add jfiles to global extension. If I then compile my app without adding anything else concering jfiles I get the errors from the picture in the attachment.
I seems to be concerned to Netmaps, but I don't want to use maps, I even don't want to use a web server in this app.
Does someone know what to do?
Thanks a lot.
Cheers
Heinz
I have a small test app with a NetWebClient to send request to a WebService.
This works very well. The content of the pages I receive are json objects.
Therefore I add jfiles to global extension. If I then compile my app without adding anything else concering jfiles I get the errors from the picture in the attachment.
I seems to be concerned to Netmaps, but I don't want to use maps, I even don't want to use a web server in this app.
Does someone know what to do?
Thanks a lot.
Cheers
Heinz
9
Web Server - Ask For Help / NetBrowse with fixed column widths
« on: March 27, 2020, 05:34:26 AM »
Hello,
I have a NetBrowse routine and would like to have fixed column widths. The reason is that the browse is part of a form and should have a fixed width, at least should not get to narrow because then a layout of the from gets bad.
In the CSS tab on field level I defined a Column width. This also later is shown in the html code. But it is not accepted and not used (see attachment)
In the html code I find the classes nt-flex, nt-flexwidth-1 and so on, I think this is for responsive grids.
Is there a way to have a browse with fixed column widths? How? (But only one browse of the complete web application)
Thanks for every help
Cheers
Heinz
I have a NetBrowse routine and would like to have fixed column widths. The reason is that the browse is part of a form and should have a fixed width, at least should not get to narrow because then a layout of the from gets bad.
In the CSS tab on field level I defined a Column width. This also later is shown in the html code. But it is not accepted and not used (see attachment)
In the html code I find the classes nt-flex, nt-flexwidth-1 and so on, I think this is for responsive grids.
Is there a way to have a browse with fixed column widths? How? (But only one browse of the complete web application)
Thanks for every help
Cheers
Heinz
10
Web Server - Ask For Help / Focus after lookup field
« on: February 27, 2019, 10:14:14 AM »
Hi,
I have a simple form with 3 entry fields and some display fields. The first field is a string lookup field. Its possible to do manual entries, which then are looked up in a table.
In the string field I set the focus to the second field (when accepted set focus on...).
In the embed point 'Add Server Code Here' I read and set some values for display fields. For them the I do a validate::value and a refresh to show the new values after the lookup.
ERS:EANCode = SUB(EANCode,1,12)
GET(Ersatzteile,ERS:KeyEANCode)
ErsBezeichnung = CLIP(ERS:Nummer) & ' ' & ERS:Bezeichnung
ErsSysPk = ERS:SysPk
Menge = 1
ERL:ErsSysPk = ErsSysPk
SET(ERL:KeyErsSysPk,ERL:KeyErsSysPk)
NEXT(Ersatzlager)
IF ~ERRORCODE() THEN
Lagerort = ERL:Lagerort
p_web.SSV('Lagerort',Lagerort)
END
p_web.SSV('ErsSysPk',ErsSysPk)
p_web.SSV('LaoErsSysPk',ErsSysPk)
p_web.SSV('ErsBezeichnung',ErsBezeichnung)
p_web.SSV('Menge',Menge)
DO ValidateValue::Lagerort
DO Refresh::Lagerort
DO ValidateValue::Ersbezeichnung
DO Refresh::ErsBezeichnung
DO ValidateValue::Menge
DO Refresh::Menge
Everything works, but after the lookup the focus is not set to the second field (Label Menge). None of the to field really has the focus.
If I press tab the focus is to the second field.
What can be wrong here, who can I set the focus to the field Menge?
Thanks for every help.
Cheers
Heinz
I have a simple form with 3 entry fields and some display fields. The first field is a string lookup field. Its possible to do manual entries, which then are looked up in a table.
In the string field I set the focus to the second field (when accepted set focus on...).
In the embed point 'Add Server Code Here' I read and set some values for display fields. For them the I do a validate::value and a refresh to show the new values after the lookup.
ERS:EANCode = SUB(EANCode,1,12)
GET(Ersatzteile,ERS:KeyEANCode)
ErsBezeichnung = CLIP(ERS:Nummer) & ' ' & ERS:Bezeichnung
ErsSysPk = ERS:SysPk
Menge = 1
ERL:ErsSysPk = ErsSysPk
SET(ERL:KeyErsSysPk,ERL:KeyErsSysPk)
NEXT(Ersatzlager)
IF ~ERRORCODE() THEN
Lagerort = ERL:Lagerort
p_web.SSV('Lagerort',Lagerort)
END
p_web.SSV('ErsSysPk',ErsSysPk)
p_web.SSV('LaoErsSysPk',ErsSysPk)
p_web.SSV('ErsBezeichnung',ErsBezeichnung)
p_web.SSV('Menge',Menge)
DO ValidateValue::Lagerort
DO Refresh::Lagerort
DO ValidateValue::Ersbezeichnung
DO Refresh::ErsBezeichnung
DO ValidateValue::Menge
DO Refresh::Menge
Everything works, but after the lookup the focus is not set to the second field (Label Menge). None of the to field really has the focus.
If I press tab the focus is to the second field.
What can be wrong here, who can I set the focus to the field Menge?
Thanks for every help.
Cheers
Heinz
11
Web Server - Ask For Help / Refresh another field after new value in a Lookup field
« on: February 05, 2019, 02:11:15 AM »
Hello,
I have a form where the user selects a spare part. This is a lookup field (based on a table, popup). To every spare part the belong one or more stock locations (other table).
In a second field (dropdown) the user can select one of stock locations after selecting a spare part. The dropdown list is based on a queue, which is filled after selecting the spare part.
I fill this queue in the embed point AfterLookup / Fieldname. This works very well if I really use the lookup button behind the field.
But it should also work if I type in a new value for the spare part manually. I have set the option 'Send new value to server' on the tab 'Client-Side' for the spare part field.
I also can debug that the queue for stock locations is really updated after accepting a manually entered value for the spare part.
But I don't succeed in refreshing the drop down field in this case. In my dropdown field there are no values or the values of the spare part before (selected by the button).
Does someone know how to refresh the dropdown list on the screen according the new values in the queue?
Thanks for every help.
Cheers Heinz
By the way: in the lookup settings of my spare part field I have defined a description field (name of spare part), this is not shown on screen. What can be wrong here?
I have a form where the user selects a spare part. This is a lookup field (based on a table, popup). To every spare part the belong one or more stock locations (other table).
In a second field (dropdown) the user can select one of stock locations after selecting a spare part. The dropdown list is based on a queue, which is filled after selecting the spare part.
I fill this queue in the embed point AfterLookup / Fieldname. This works very well if I really use the lookup button behind the field.
But it should also work if I type in a new value for the spare part manually. I have set the option 'Send new value to server' on the tab 'Client-Side' for the spare part field.
I also can debug that the queue for stock locations is really updated after accepting a manually entered value for the spare part.
But I don't succeed in refreshing the drop down field in this case. In my dropdown field there are no values or the values of the spare part before (selected by the button).
Does someone know how to refresh the dropdown list on the screen according the new values in the queue?
Thanks for every help.
Cheers Heinz
By the way: in the lookup settings of my spare part field I have defined a description field (name of spare part), this is not shown on screen. What can be wrong here?
12
Web Server - Ask For Help / Set the picture of a spinner field
« on: August 15, 2018, 05:32:55 AM »
Hello,
perhaps I am blind, but I don't find the possibility to set the picture of a spinner field in a web form.
What I want to do is to have a time (only time) field which spins by 15 minutes (step 90000).
I have a long variable, minimum 1, maximum 8640000 and want to use the picture @t1
But there is no picture field...
Does somebody know wheres the mistake?
Thanks a lot.
Cheers
Heinz
perhaps I am blind, but I don't find the possibility to set the picture of a spinner field in a web form.
What I want to do is to have a time (only time) field which spins by 15 minutes (step 90000).
I have a long variable, minimum 1, maximum 8640000 and want to use the picture @t1
But there is no picture field...
Does somebody know wheres the mistake?
Thanks a lot.
Cheers
Heinz
13
Web Server - Ask For Help / Set a parameter and the refresh the complete form with different visible tabs
« on: July 20, 2018, 04:03:11 AM »
Hello,
is there a way to solve the following problem in a net web form:
I have several tabs on my form, at start some are hidden some not.
Now by pressing a button the conditions for the tabs should be changed (Send new value to server, serverside code), the form should be refreshed and according to the conditions other tabs should be shown.
Can I do this by some kind of refresh or does the form itself should be called by URL again?
Thanks for every hint.
Cheers
Heinz
is there a way to solve the following problem in a net web form:
I have several tabs on my form, at start some are hidden some not.
Now by pressing a button the conditions for the tabs should be changed (Send new value to server, serverside code), the form should be refreshed and according to the conditions other tabs should be shown.
Can I do this by some kind of refresh or does the form itself should be called by URL again?
Thanks for every hint.
Cheers
Heinz
14
Web Server - Ask For Help / Interrup the call of update form by a redirect
« on: July 11, 2018, 07:26:59 AM »
Hello,
I have the following task:
- a user has a browse with orders. There he uses the change button to edit the order as usual.
- Before the order is displayed there has to be done a check. If the check is negative not the update form should be displayed but a form with some questions.
- After answering the questions and saving the question form there should be two possibilites. If the answers are ok then the update form of the order should be called. If the answer is not ok then the user should come back to the browse.
- If the first check is positive the update form should be displayed directly
Can this be solved by a redirection?
Where, in the 'procedure setup embed' of the update form?
If I am in the question form an save with positive answers, how do I get back correctly to the update form?
How to the browse?
Thanks for every help.
Cheers
Heinz
I have the following task:
- a user has a browse with orders. There he uses the change button to edit the order as usual.
- Before the order is displayed there has to be done a check. If the check is negative not the update form should be displayed but a form with some questions.
- After answering the questions and saving the question form there should be two possibilites. If the answers are ok then the update form of the order should be called. If the answer is not ok then the user should come back to the browse.
- If the first check is positive the update form should be displayed directly
Can this be solved by a redirection?
Where, in the 'procedure setup embed' of the update form?
If I am in the question form an save with positive answers, how do I get back correctly to the update form?
How to the browse?
Thanks for every help.
Cheers
Heinz
15
Web Server - Ask For Help / NetTalk disconnected desktop app
« on: May 15, 2018, 06:47:36 AM »
Hello,
I have the following task. I want to build an offline client programm for a windows device, there as first step a disconnected desktop app.
This client should be used in the following way:
- People walk around in a factory with the device, on the device they have their tasks (orders), work with them and later this should be synchronised with the server
- On the offline device they should have not the complete server data base, but a selection of data corresponding to their person. Therefore at the beginning of each day the client data base should be empty in regard of the orders, some other tables stay filled on the client, as basic data like machines, persons. The emptying can be done after synchronizing the last day.
- For the actual day there should be the possibilty to tell the sync procedure, that only orders from the server are fetched which have been assigned to the actual person on the server. Other records of the order table should not be fetched.
- This selection or filter should be set in the client app while connected to the network and as soon a filter is set and the next sync is started the related records should be fetched from the server.
Is it possible to do this with the sync procedure or do I have to write an own procedure which copies the relevant records from the server data base to the client database?
Thanks for every hint
Regards,
Heinz
I have the following task. I want to build an offline client programm for a windows device, there as first step a disconnected desktop app.
This client should be used in the following way:
- People walk around in a factory with the device, on the device they have their tasks (orders), work with them and later this should be synchronised with the server
- On the offline device they should have not the complete server data base, but a selection of data corresponding to their person. Therefore at the beginning of each day the client data base should be empty in regard of the orders, some other tables stay filled on the client, as basic data like machines, persons. The emptying can be done after synchronizing the last day.
- For the actual day there should be the possibilty to tell the sync procedure, that only orders from the server are fetched which have been assigned to the actual person on the server. Other records of the order table should not be fetched.
- This selection or filter should be set in the client app while connected to the network and as soon a filter is set and the next sync is started the related records should be fetched from the server.
Is it possible to do this with the sync procedure or do I have to write an own procedure which copies the relevant records from the server data base to the client database?
Thanks for every hint
Regards,
Heinz