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.


Topics - hkalmbach

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

3
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

4
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

5
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

6
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

7
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


8
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

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


10
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

11
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

12
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

13
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

14
Web Server - Ask For Help / Show the contents (files) of a folder
« on: May 08, 2018, 01:21:52 AM »
Hello,

I have a web app where the user can look at dokuments attached to a machine. In the browse the document paths are shown and the documents can be opened in the browser (pdf's, word doc's, ...). This works fine.
Now a user has a lot of documents and does not want to attach each document to the machine, but wants to attach the folder where the documents a stored to the machine.
In the clarion windows program its no problem to have links to documents in the data base as well as a link to a folder. If the user wants to see the folder I can open an explorer window to show the content of the folder.
Is it possible to do something similar with NetTalk? That means to have the path of a folder in the database, show it to the user and when he clicks on it to show him the contents of this folder?

Thanks for every hint.

Cheers
Heinz

15
Web Server - Ask For Help / Disconnected Web app
« on: April 11, 2018, 11:23:07 PM »
Hi,

I am testing the example disconnected web. Some things work, some not. I have the following questions:

- Am I right that in addition to the server of the example which serves the app I need a second server for the sychronisation of the data, which runs on a second port?
- I created this second server and get some kind of synchronisation. But it behaves strange in some way:

Pages: [1] 2 3 4