NetTalk Central

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.


Messages - hkalmbach

Pages: [1] 2 3 ... 6
1
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

2
Hi Bruce,

I don't see any effect with these driverstring options.

Is there a way to trap and ignore this errors?
That there is no message box in the webserver?

Cheers
Heinz

3
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

4
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

5
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

6
Hi,
no, I did not make any changes, perhaps I added a column in the browse, but nothing funtional as far as I now.

The 'no records message' is not empty and also I don't use span columns.

Do you think its a problem of the browse or of the form?

Thanks for every help

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

8
Web Server - Ask For Help / Re: NetWebClient and jFiles
« on: April 20, 2020, 11:47:49 PM »
Hi Bruce,

sorry, was out of office.
NetTalk 11.27
jFiles 1.71

For the actual case the problem is solved, I included jFiles manually. This works as described in your manual. The error only appears if included by the global extension template.

Cheers
Heinz

9
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

10
Web Server - Ask For Help / Re: NetBrowse with fixed column widths
« on: March 29, 2020, 09:57:06 AM »
Hi Don,

thanks for your answer.
I tried to use min-width. If you scroll my picture right you see that I define a min-width of 80, but also that this is not used.
Something is overwriting it (its crossed out) and I don't know what does this and how to overrule it.

You have an idea?

Thanks
Heinz

11
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


12
Web Server - Ask For Help / Re: Focus after lookup field
« on: February 28, 2019, 05:03:38 AM »
Hi Bruce,

you need an exampe as application or a detailed description?

Here is the description. In the attachment you find a picture of the form. Its a form based on memory.

Pressing 'Speichern' the form calls itself again, passing an action parameter which does the action defined in the GenerateForm embed, actions can be 'Save' and 'Empty', 'Save' puts the last entries into the database, 'Empty' clears the form. In this way the form cycles until the user aborts or selects the main menu.

The process is the following. The user opens the form which then is empty. Then he types the number of a spare part or scans a barcode with a scanner as keyboard wedge.
If he accepts the EANCode field then in the source code in the embed ValidateValue loads data from the data base (description and first stock location). The fields 'ErsBezeichnung', 'Menge' and 'Lagerort' are in the reset list of 'EANCode'.

As remarked the focus field is set to 'Menge' (amount).
But the focus is not set to 'Menge', it is somewhere, after pressing 'Tab' it is in 'Menge'.

The code I use:

Validate::EANCode Routine
  data
! Start of "After Validate New Value"
! [Priority 5000]

! End of "After Validate New Value"
  code
  ! Start of "After Validate New Value"
  ! [Priority 5000]
 
  ! End of "After Validate New Value"
  ! Start of "Validate New Value"
  ! [Priority 5000]
 
  ! End of "Validate New Value"
  ! Start of "Validate New Value"
  ! [Priority 5000]
 
  ! End of "Validate New Value"
  If p_web.Ajax = 1 and p_web.ifExistsValue('NewValue')
    EANCode = p_web.GetValue('NewValue')
  ElsIf p_web.IfExistsValue('Value') !FormFieldPicture = '@s20'  !FieldPicture =
    EANCode = p_web.Dformat(p_web.GetValue('Value'),'@s20')
  End
  do ValidateValue::EANCode  ! copies value to session value if valid.
  If loc:noFocus = false
    p_web.SetValue('SelectField',clip(loc:formname) & '.' & p_web.NoColon(Menge))
  End
  ! Start of "After Validate New Value"
  ! [Priority 4000]
 
 
  ! End of "After Validate New Value"

  p_web.PushEvent('parentupdated')
  do Refresh::EANCode   ! Field is auto-validated
  do SendMessage
  do Refresh::ErsBezeichnung  !(GenerateFieldReset)
  do Refresh::Lagerort  !(GenerateFieldReset)
  do Refresh::Menge  !(GenerateFieldReset)
  p_web.ntForm(loc:formname,'ready') ! 8.67 (in case the form was not the originator of the Ajax call)
  ! Start of "After Validate New Value, After sending replies"
  ! [Priority 5000]
 
  ! End of "After Validate New Value, After sending replies"
  p_web.PopEvent()


ValidatValue::EANCode ROUTINE

  ! End of "Validate Value"
      If loc:invalid = '' then p_web.SetSessionValue('EANCode',EANCode).   !NetTalk
  ! Start of "Validate Value"
  ! [Priority 5000]

  IF LEN(CLIP(EANCode)) THEN
    p_web.OpenFile(Ersatzteile)
    p_web.OpenFile(ErsatzLager)
 
    EANCode = LEFT(CLIP(EANCode))
    ERS:EANCode = SUB(EANCode,1,12)
    GET(Ersatzteile,ERS:KeyEANCode)
    IF ERRORCODE() THEN CLEAR(ERS:Record).
    ErsBezeichnung = CLIP(ERS:Nummer) & ' ' & ERS:Bezeichnung
    ErsSysPk = ERS:SysPk
    Menge = 1
   
    Lagerort = ''
    ERL:ErsSysPk = ErsSysPk  !get the first stock location
    SET(ERL:KeyErsSysPk,ERL:KeyErsSysPk)
    NEXT(Ersatzlager)
    IF ~ERRORCODE() THEN
      Lagerort = ERL:Lagerort
    END 
   
    p_web.SSV('ErsSysPk',ErsSysPk)
    p_web.SSV('Lagerort',Lagerort)
    p_web.SSV('ErsBezeichnung',ErsBezeichnung)
    p_web.SSV('Menge',Menge)
   
    p_web.CloseFile(Ersatzteile)
    p_web.CloseFile(ErsatzLager)
   
    p_web.SetValue('SelectField',clip(loc:formname) & '.' & p_web.NoColon(Menge))   !NetTalk
  END     


Some times I can see, that accepting 'EANCode' the cursor jumps to 'Menge', but then refreshing or reseting the other fields appears afterwards and after that the focus is no longer in an input field.

I hope this explans the facts.

If its not enough please tell me what to send you.

Thanks a lot

Cheers
Heinz

13
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

14
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?


15
Web Server - Ask For Help / Re: Set the picture of a spinner field
« on: August 17, 2018, 12:26:37 AM »
Hi Bruce,

no problem. But wouldn't it be enough to be able to set a picture? (@t1)
Using the correct limits (0-8640000) and steps (90000 for a quarter of an hour) works, the numbers only should be displayed different.

Thanks.
Heinz

Pages: [1] 2 3 ... 6