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 / Add Button in Page Header
« on: December 31, 2023, 03:34:05 PM »
I need to have a clickable button in the Page Header and when the user clicks it, it pops up a form to enter information and when the form is completed, the info is displayed in the Page Header.
2
Web Server - Ask For Help / Browse Row Color Change when Select Row
« on: June 29, 2017, 06:05:59 PM »
NT 9.21
I have a browse with a conditional CSS and that colors the row based on the condition and it works fine.
But, when you click on the row, the color stays the same, thus the user doesn't get a visual clue as to what row is selected. Is there a way to change the color when the row is selected?
For example, if the row is colored a light green due to the conditional CSS, how to change it to a darker green when the user clicks on it so they have a visual indication of the currently selected row.
Mike Springer
I have a browse with a conditional CSS and that colors the row based on the condition and it works fine.
But, when you click on the row, the color stays the same, thus the user doesn't get a visual clue as to what row is selected. Is there a way to change the color when the row is selected?
For example, if the row is colored a light green due to the conditional CSS, how to change it to a darker green when the user clicks on it so they have a visual indication of the currently selected row.
Mike Springer
3
Web Server - Ask For Help / Hide Columns on NetBrowse
« on: June 09, 2017, 07:22:17 PM »
NT 9.21
Have a browse with a change button and a button (other) in the row. Each has a conditional statement so that only one or the other button is displayed. That works, BUT the column for the hidden button is still displayed.
How do I hide the column when the button display condition calls for the button to be hidden?
Mike Springer
Have a browse with a change button and a button (other) in the row. Each has a conditional statement so that only one or the other button is displayed. That works, BUT the column for the hidden button is still displayed.
How do I hide the column when the button display condition calls for the button to be hidden?
Mike Springer
4
Web Server - Ask For Help / Prime a Browse Field
« on: April 12, 2017, 06:40:58 AM »
Using NT 9.21
Have a browse on a memory form. The browse is displaying filtered records of a file. One of the browse fields is a local variable that has to be built by looking up a value in a different file based on the info in other columns of the browse record. Where would I place an embed to allow the lookup/calculation of this browse field?
Thanks,
Mike Springer
Have a browse on a memory form. The browse is displaying filtered records of a file. One of the browse fields is a local variable that has to be built by looking up a value in a different file based on the info in other columns of the browse record. Where would I place an embed to allow the lookup/calculation of this browse field?
Thanks,
Mike Springer
5
Web Server - Ask For Help / Wizard Style Form Prev/Next don't change tab
« on: March 03, 2017, 04:02:33 PM »
NT 8.62
Created a form with Wizard style. As expected, it shows a Previous and Next button. However, when I click on the Next (or Previous) button, the tab does not change to the next (or previous) tab. No embed code, just selected the Wizard form style and created three tabs with a single field on each tab.
What am I obviously missing?
Mike Springer
Created a form with Wizard style. As expected, it shows a Previous and Next button. However, when I click on the Next (or Previous) button, the tab does not change to the next (or previous) tab. No embed code, just selected the Wizard form style and created three tabs with a single field on each tab.
What am I obviously missing?
Mike Springer
6
Web Server - Ask For Help / Set Form Tab
« on: April 01, 2016, 07:30:01 PM »
NetTalk 8.62
On a Form with Tabs (Tab type), is there a way to choose which tab is open when the form is opened? On the basis of a session value when the form is called, I'd like to have the form open with a specific tab opened depending on that session value.
Mike Springer
On a Form with Tabs (Tab type), is there a way to choose which tab is open when the form is opened? On the basis of a session value when the form is called, I'd like to have the form open with a specific tab opened depending on that session value.
Mike Springer
7
Web Server - Ask For Help / Validate Form Data Before Printing
« on: April 13, 2015, 08:44:12 AM »
Clarion 9.1 NT 8.33
I have a memory form with some fields. The fields set the parameters that will be passed to a report via a start button on the form. How do I go about making sure the fields have been filled in when the start button is clicked?
I'd like to run some simple IF/Then tests of the fields and if they are blank (not filled in) then I don't want to run the report but give an error message and return the cursor to the field in question.
Mike Springer
I have a memory form with some fields. The fields set the parameters that will be passed to a report via a start button on the form. How do I go about making sure the fields have been filled in when the start button is clicked?
I'd like to run some simple IF/Then tests of the fields and if they are blank (not filled in) then I don't want to run the report but give an error message and return the cursor to the field in question.
Mike Springer
8
Web Server - Ask For Help / Printer Formatting Suddenly Changed - Suggestions?
« on: February 09, 2015, 04:01:33 PM »
Clarion 9.1
Nettalk 8.33
Customer just moved the NetTalk Web server and printer to a new building. Just a move, no changes.
However, now the NetTalk generated reports all have a formatting problem. Looks like the font is larger than normal and strings that line up horizontally with each other now run into each other. Doesn't matter what report is run.
No changes were made to the computer, no changes to the application, and the same server attached printer. The printer is configured as the default printer. Windows 7 OS.
On the browser end, different browsers, different printers - all that used to display the PDF fine and print locally fine but now display and print with the formatting problem.
I thought this would be a problem where the server no longer had a default printer, but it does - hardwired CAT 5 connected and set as the default system printer. Printing locally from a Clarion desktop version of the application prints fine.
I'm stumped - any suggestions of what to look for?
Mike Springer
Nettalk 8.33
Customer just moved the NetTalk Web server and printer to a new building. Just a move, no changes.
However, now the NetTalk generated reports all have a formatting problem. Looks like the font is larger than normal and strings that line up horizontally with each other now run into each other. Doesn't matter what report is run.
No changes were made to the computer, no changes to the application, and the same server attached printer. The printer is configured as the default printer. Windows 7 OS.
On the browser end, different browsers, different printers - all that used to display the PDF fine and print locally fine but now display and print with the formatting problem.
I thought this would be a problem where the server no longer had a default printer, but it does - hardwired CAT 5 connected and set as the default system printer. Printing locally from a Clarion desktop version of the application prints fine.
I'm stumped - any suggestions of what to look for?
Mike Springer
9
Web Server - Ask For Help / Span Value and Comments
« on: June 16, 2014, 03:11:14 AM »
C 9.0
NT 7.35
I'm trying to get the comments to snug up just to the right of a number field, but have the number field aligned so it is not snugged up to the prompt field. From reading threads on this, it appears that all I have to do to get the effect is to check the "Span Prompt/Value/Column" checkbox and then apply a custom CSS to the prompt field to set the width of the field. But, as you can see from the attached image, the value moves to the next line rather than aligning to the right at the position set by the prompt field width.
Any suggestion for what I am doing incorrectly?
Thanks,
Mike Springer
[attachment deleted by admin]
NT 7.35
I'm trying to get the comments to snug up just to the right of a number field, but have the number field aligned so it is not snugged up to the prompt field. From reading threads on this, it appears that all I have to do to get the effect is to check the "Span Prompt/Value/Column" checkbox and then apply a custom CSS to the prompt field to set the width of the field. But, as you can see from the attached image, the value moves to the next line rather than aligning to the right at the position set by the prompt field width.
Any suggestion for what I am doing incorrectly?
Thanks,
Mike Springer
[attachment deleted by admin]
10
Web Server - Ask For Help / Uploading records to Server
« on: May 28, 2014, 06:26:30 AM »
NT 7.35
I have a customer with an installed base of about 400 clarion single user applications. We are implementing a NetTalk server and the customer wants the field clarion applications to upload selective database records to the server. Once the server receives the uploads, a clarion process would sync the received file data into the main server database.
Question:
1. What would you recommend as the best process for this upload?
2. Is there a good example that would illustrate how a client would upload a file to the server?
3. Is this an FTP kind of transaction or HTTP? I assume HTTP is a better choice.
4. The data will contain contact info - should it also be encrypted for the journey? Cryptonite approach?
Thanks for any advice on the best way to approach this.
Mike Springer
I have a customer with an installed base of about 400 clarion single user applications. We are implementing a NetTalk server and the customer wants the field clarion applications to upload selective database records to the server. Once the server receives the uploads, a clarion process would sync the received file data into the main server database.
Question:
1. What would you recommend as the best process for this upload?
2. Is there a good example that would illustrate how a client would upload a file to the server?
3. Is this an FTP kind of transaction or HTTP? I assume HTTP is a better choice.
4. The data will contain contact info - should it also be encrypted for the journey? Cryptonite approach?
Thanks for any advice on the best way to approach this.
Mike Springer
11
Web Server - Ask For Help / Child Browse to the right of Parent Form
« on: May 20, 2014, 03:32:40 AM »
NT 7.35
I have a form with data from a parent file, and would like to display a browse of the child records filtered for that specific parent in the form, but I need the child browse to appear to the right of the form fields. So, the effect is the parent data fields on the left of the screen, and the child browse with the relevant entries to the right of the form.
If I add the browse to the form's list of "fields" the browse appears below the form fields. How do I get the browse to the right of the form fields instead of below the fields?
Thanks,
Mike Springer
I have a form with data from a parent file, and would like to display a browse of the child records filtered for that specific parent in the form, but I need the child browse to appear to the right of the form fields. So, the effect is the parent data fields on the left of the screen, and the child browse with the relevant entries to the right of the form.
If I add the browse to the form's list of "fields" the browse appears below the form fields. How do I get the browse to the right of the form fields instead of below the fields?
Thanks,
Mike Springer
12
Web Server - Ask For Help / Call Form with no browse from Static Page Link
« on: May 07, 2014, 04:14:59 AM »
I have a static page with a link on it to call a Form without a browse. The background on this is people log in to the system, and a static page (a NetWebPage) with a lot of icon links are on it. When the click on a particular icon, a call is made to a NT procedure. That all works fine, but now, I need to add a call to a Form (without a browse) that displays the logged in person's info.
I am using the following code in the static call:
<a href="'MyChurchProfile?change+btn=change&_bidv_=' &p_web.AddBrowseValue('dmemain','Family',FAM:Key_SysID,60)">
MyChurchProfile is the NT Form procedure
I only allow a Change action
The calling static page (which is a NetPage procedure) is dmemain
Family is the table name that contains the logged in person's data
FAM:Key_SysID is the unique key
60 is the person's record key value
This call results in a page not found with the following displayed as the link:
http://127.0.0.1/'MyChurchProfile?change+btn=change&_bidv_='&p_web.AddBrowseValue( 'dmemain','Family',FAM:Key_SysID,60)
I'm guessing the problem is that the instructions in the NetTalk book are not based on the URL being coded in a static link and the " and ' in the link may be a problem.
So, two questions:
1. Can I call the form directly from a static link, and if so, what changes do I need to make to the static link?
2. Regarding the specific record ID, in the example here I have "hard coded" the ID (60) for testing. In actual practice, I would have the ID in a session value. What should the static link change to for using the session value as the source of the record ID? Replace the example 60 value with p_web.GSV('LoggedInFamilyID')?
Thanks for your help on this.
Mike Springer
I am using the following code in the static call:
<a href="'MyChurchProfile?change+btn=change&_bidv_=' &p_web.AddBrowseValue('dmemain','Family',FAM:Key_SysID,60)">
MyChurchProfile is the NT Form procedure
I only allow a Change action
The calling static page (which is a NetPage procedure) is dmemain
Family is the table name that contains the logged in person's data
FAM:Key_SysID is the unique key
60 is the person's record key value
This call results in a page not found with the following displayed as the link:
http://127.0.0.1/'MyChurchProfile?change+btn=change&_bidv_='&p_web.AddBrowseValue( 'dmemain','Family',FAM:Key_SysID,60)
I'm guessing the problem is that the instructions in the NetTalk book are not based on the URL being coded in a static link and the " and ' in the link may be a problem.
So, two questions:
1. Can I call the form directly from a static link, and if so, what changes do I need to make to the static link?
2. Regarding the specific record ID, in the example here I have "hard coded" the ID (60) for testing. In actual practice, I would have the ID in a session value. What should the static link change to for using the session value as the source of the record ID? Replace the example 60 value with p_web.GSV('LoggedInFamilyID')?
Thanks for your help on this.
Mike Springer
13
Web Server - Ask For Help / Move Child Browse Vertical Position
« on: May 06, 2014, 01:25:07 PM »
I have a NetBrowse with a parent and child browse. The child browse is located to the right of the parent browse.
I would like to move the child browse vertical position slightly (down by what amounts to about a couple of lines in vertical spacing). What would be the best (simplest?) approach to do something like that?
Thanks,
Mike Springer
I would like to move the child browse vertical position slightly (down by what amounts to about a couple of lines in vertical spacing). What would be the best (simplest?) approach to do something like that?
Thanks,
Mike Springer
14
Web Server - Ask For Help / Hide/Unhide Form Fields based on another Field Entry
« on: March 22, 2014, 11:53:58 AM »
C9.0 NT 7.35
I need to hide two fields from the form until another field is entered via a drop, and in the server side code for the drop, I look up the record for the selected drop field and do a SSV of a flag to indicate if the following two fields should be displayed for entry or not.
If I am opening an existing record, the template hide/unhide conditions for the two fields are followed. But, if inserting a new record, the fields are hidden (which would be correct until the drop down field is filled in). I do ask the templates to reset the two fields after the server side code that does the SSV of the control field. But, the two fields remain hidden.
The hide/unhide template entries for the two fields are:
Include: p_web.gsv('PCN:AllowFirstFruit') = 'Y'
Hide: p_web.gsv('PCN:AllowFirstFruit') <> 'Y'
Note - the PCN:AllowFirstFruit session value contains the correct value
So, what processes are needed to be followed to do this, what embeds are used to be able to redisplay the form with the new decision regarding hide/unhide after the drop field is selected.
Thanks,
Mike Springer
I need to hide two fields from the form until another field is entered via a drop, and in the server side code for the drop, I look up the record for the selected drop field and do a SSV of a flag to indicate if the following two fields should be displayed for entry or not.
If I am opening an existing record, the template hide/unhide conditions for the two fields are followed. But, if inserting a new record, the fields are hidden (which would be correct until the drop down field is filled in). I do ask the templates to reset the two fields after the server side code that does the SSV of the control field. But, the two fields remain hidden.
The hide/unhide template entries for the two fields are:
Include: p_web.gsv('PCN:AllowFirstFruit') = 'Y'
Hide: p_web.gsv('PCN:AllowFirstFruit') <> 'Y'
Note - the PCN:AllowFirstFruit session value contains the correct value
So, what processes are needed to be followed to do this, what embeds are used to be able to redisplay the form with the new decision regarding hide/unhide after the drop field is selected.
Thanks,
Mike Springer
15
Web Server - Ask For Help / SetAlert Not Working?
« on: February 25, 2014, 07:29:56 AM »
NT 7.31 C9.0
When a customer recently updated to use the NT 7.31 version of the web server app, a SetAlert message stopped appearing. I investigated and found this situation which doesn't make sense to me. The problem occurs in a NetForm with a Button and on the Client Side tab for the button, I've checked the Send New Value to Server.
The Server Side Code embed has this code:
if p_web.GSV('LOC:UserDepositDate') = 0
p_web.SetAlert('Error Message',1,'MakeDeposit')
Else
DepositContributions(p_web) !go process the deposit file
p_web.SetAlert('Deposit Recorded',1,'MakeDeposit')
End
In this code, if the LOC:UserDepositDate is 0, the Error Message is displayed. But, if the date exists, the DepositContributions procedure is run successfully, but the "Deposit Recorded" SetAlert does not appear, and the form's button is greyed out.
I have changed the code for debugging why the SetAlert doesn't display, and I substituted this code:
if p_web.GSV('LOC:UserDepositDate') = 0
p_web.SetAlert('Error Message',1,'MakeDeposit')
Else
p_web.SetAlert('Deposit Recorded',1,'MakeDeposit')
End
And, still, that "Deposit Recorded" message is not displayed. It's not the message itself, I have also simply duplicated the first "Error Message" into the "Else" and it still does not appear.
Any thoughts why a SetAlert will not appear, especially in light of the first one appearing OK (if no date).
Also, this worked back in 7.15 but now in 7.31 is not.
Mike Springer
When a customer recently updated to use the NT 7.31 version of the web server app, a SetAlert message stopped appearing. I investigated and found this situation which doesn't make sense to me. The problem occurs in a NetForm with a Button and on the Client Side tab for the button, I've checked the Send New Value to Server.
The Server Side Code embed has this code:
if p_web.GSV('LOC:UserDepositDate') = 0
p_web.SetAlert('Error Message',1,'MakeDeposit')
Else
DepositContributions(p_web) !go process the deposit file
p_web.SetAlert('Deposit Recorded',1,'MakeDeposit')
End
In this code, if the LOC:UserDepositDate is 0, the Error Message is displayed. But, if the date exists, the DepositContributions procedure is run successfully, but the "Deposit Recorded" SetAlert does not appear, and the form's button is greyed out.
I have changed the code for debugging why the SetAlert doesn't display, and I substituted this code:
if p_web.GSV('LOC:UserDepositDate') = 0
p_web.SetAlert('Error Message',1,'MakeDeposit')
Else
p_web.SetAlert('Deposit Recorded',1,'MakeDeposit')
End
And, still, that "Deposit Recorded" message is not displayed. It's not the message itself, I have also simply duplicated the first "Error Message" into the "Else" and it still does not appear.
Any thoughts why a SetAlert will not appear, especially in light of the first one appearing OK (if no date).
Also, this worked back in 7.15 but now in 7.31 is not.
Mike Springer