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.
16
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
17
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
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
18
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
19
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?
20
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
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
21
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
22
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
23
Web Server - Ask For Help / Re: Interrup the call of update form by a redirect
« on: July 20, 2018, 12:09:14 AM »
Thanks a lot. I first tried the suggestion of Bruce.
I made a tab for the questions. First this tab is displayed by hide/unhide conditions.
On this tab I placed a button which on click calls the form itself with a parameter that tells the form not to display the questions again.
Then have my normal form with lookups and so on. But now the form does not work correct any more.
- If I use a lookup that displays a browse to select from I don't get back to my form.
- If I select from a dropdown menu and save the form the value is not saved.
- If I enter a text in a text field and save the text is not saved.
I think some internal states of the form are not set correct.
What's the error?
Is it the wrong way to call the form itself when finished the question to call itself?
How can I accept the answers of the question tab, reload the form in normal way (as update form) that the form works correct?
Thanks for every help
Cheers Heinz
I made a tab for the questions. First this tab is displayed by hide/unhide conditions.
On this tab I placed a button which on click calls the form itself with a parameter that tells the form not to display the questions again.
Then have my normal form with lookups and so on. But now the form does not work correct any more.
- If I use a lookup that displays a browse to select from I don't get back to my form.
- If I select from a dropdown menu and save the form the value is not saved.
- If I enter a text in a text field and save the text is not saved.
I think some internal states of the form are not set correct.
What's the error?
Is it the wrong way to call the form itself when finished the question to call itself?
How can I accept the answers of the question tab, reload the form in normal way (as update form) that the form works correct?
Thanks for every help
Cheers Heinz
24
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
25
Web Server - Ask For Help / Re: NetTalk disconnected desktop app
« on: May 22, 2018, 02:13:40 AM »
Hi Bruce,
thanks for your answer.
I think I found most of what I need:
- In the ServerSync procedure on client side the possibility to filter records on client side.
- In the syncFile procedure of the server the possibility to filter the records on Server side, they are filtered with FileView{Prop:Filter} in the routine BuildResultFields
(This I need, because in one case on the server there are > 100.000 records, the client only should get ~20 of these records, starting with an empty table, and the filter on client side here is very much to slow, it takes than half an hour even if the server and client are on the same computer.)
But some questions are left:
- in my case I have a main table with serveral sub tables. The main table is this where the client should get the mentioned 20 records. All the sub records of these 20 main records should be synced to the client, but only they, not the complete sub tables (these may contain > 100.000 records each).
How can I filter them on server side to get a fast sync? If I filter them on client side all 100.000 records have to be sent and checked, and only lets say 100 are ok and are inserted in the client table.
- The main table in addition to the GUID field has an autonumbered order number field. If a client creates a new order and this is synced to the server it may be, that the order number of the client already is used on the server. Therefore I create a new order number in PrimtFields:File. This works so far. But if after the first sync, where the record gets to the server with a new order number, the record is changed on the client, the server record is not updated again. I saw that the problem starts in SyncRecord:File because the record on client side has no ServerTimeStamp and therefore is look at as an incoming insert.
Should the record be resynced from the server to get back the ServerTimeStamp?
The next step is, that if I get an error in InsertRecord:File (Duplicate) the next check is ReallyTheSame:File, but this does not result in a positive result because the order number is different. How can I manage this case?
- If I have the described situation that after the first sync there is an order on the server with different order number, but same GUID as on the client, and then on the server the record is changed, should this change be synced to the client with the next snyc? This does not happen.
Thanks a lot for hellp.
Cheers
Heinz
thanks for your answer.
I think I found most of what I need:
- In the ServerSync procedure on client side the possibility to filter records on client side.
- In the syncFile procedure of the server the possibility to filter the records on Server side, they are filtered with FileView{Prop:Filter} in the routine BuildResultFields
(This I need, because in one case on the server there are > 100.000 records, the client only should get ~20 of these records, starting with an empty table, and the filter on client side here is very much to slow, it takes than half an hour even if the server and client are on the same computer.)
But some questions are left:
- in my case I have a main table with serveral sub tables. The main table is this where the client should get the mentioned 20 records. All the sub records of these 20 main records should be synced to the client, but only they, not the complete sub tables (these may contain > 100.000 records each).
How can I filter them on server side to get a fast sync? If I filter them on client side all 100.000 records have to be sent and checked, and only lets say 100 are ok and are inserted in the client table.
- The main table in addition to the GUID field has an autonumbered order number field. If a client creates a new order and this is synced to the server it may be, that the order number of the client already is used on the server. Therefore I create a new order number in PrimtFields:File. This works so far. But if after the first sync, where the record gets to the server with a new order number, the record is changed on the client, the server record is not updated again. I saw that the problem starts in SyncRecord:File because the record on client side has no ServerTimeStamp and therefore is look at as an incoming insert.
Should the record be resynced from the server to get back the ServerTimeStamp?
The next step is, that if I get an error in InsertRecord:File (Duplicate) the next check is ReallyTheSame:File, but this does not result in a positive result because the order number is different. How can I manage this case?
- If I have the described situation that after the first sync there is an order on the server with different order number, but same GUID as on the client, and then on the server the record is changed, should this change be synced to the client with the next snyc? This does not happen.
Thanks a lot for hellp.
Cheers
Heinz
26
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
27
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
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
28
Web Server - Ask For Help / Re: Disconnected Web app
« on: April 11, 2018, 11:34:58 PM »
One addition:
Updates seem not to work. I change the name of one of the countries and see the changes in the browser, also in the window of the sync server, but not in the tps file???
New inserts I see there at one.
Cheers
Heinz
Updates seem not to work. I change the name of one of the countries and see the changes in the browser, also in the window of the sync server, but not in the tps file???
New inserts I see there at one.
Cheers
Heinz
29
Web Server - Ask For Help / Re: Disconnected Web app
« on: April 11, 2018, 11:26:54 PM »
Sorry, I was not finished.
The strange behaviour:
- I call the server for the app (port 88) locally with chrome and add a country. I can close the browser, reconnect, and the inserted country is visible
- I call the server for the app from a second computer, I don't see the country from the first computer, but I can insert also countries and see them after restarting the browser there
- I don't see the countries of the second computer on the first one
- In the tps file I see all countries
What ist wrong here
Thanks for help
The strange behaviour:
- I call the server for the app (port 88) locally with chrome and add a country. I can close the browser, reconnect, and the inserted country is visible
- I call the server for the app from a second computer, I don't see the country from the first computer, but I can insert also countries and see them after restarting the browser there
- I don't see the countries of the second computer on the first one
- In the tps file I see all countries
What ist wrong here
Thanks for help
30
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:
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: