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.
61
Web Server - Ask For Help / Re: Record not found 5
« on: September 09, 2013, 08:36:50 AM »
Upon further review I have found a difference in behavior with the tab key verses the enter key in a search.
If the row has the "Link to Form" check box clicked, you have the option of clicking on the row to open the form. With that set, if you enter a string in the search field (using contained in this case) and use the "Tab" key, you can then click on the row and the form opens with the first click. On the other hand, if you enter a string in the search field and then use the "Enter" key, then you must click on the row twice in order for the form to open.
This seems to be at the root of the issue I am experiencing only, when I click on the row after using the "Enter" key, it gives me an error instead of making me click on the row twice. If I close the error and click on the row again, then the form comes up.
The issue only appears to be an issue on the first row you click on after you hit the "Enter" key. Any other click in the same search works just fine.
I used the attached example to test this with as well. I added the locator and checked the box in the example and received the same behavior.
Thanks
Ken Watts
Wasatch Consulting Services
[attachment deleted by admin]
If the row has the "Link to Form" check box clicked, you have the option of clicking on the row to open the form. With that set, if you enter a string in the search field (using contained in this case) and use the "Tab" key, you can then click on the row and the form opens with the first click. On the other hand, if you enter a string in the search field and then use the "Enter" key, then you must click on the row twice in order for the form to open.
This seems to be at the root of the issue I am experiencing only, when I click on the row after using the "Enter" key, it gives me an error instead of making me click on the row twice. If I close the error and click on the row again, then the form comes up.
The issue only appears to be an issue on the first row you click on after you hit the "Enter" key. Any other click in the same search works just fine.
I used the attached example to test this with as well. I added the locator and checked the box in the example and received the same behavior.
Thanks
Ken Watts
Wasatch Consulting Services
[attachment deleted by admin]
62
Web Server - Ask For Help / Re: Record not found 5
« on: September 08, 2013, 10:02:55 PM »
Bruce,
I looked into this a little closer and found that it happens when I check "Link to Form" box on the "On Click" tab for a field. I noticed that the only thing different is "class='nt-fakeget'" is added to the code for the packet.
Locally, the issue is manifesting itself by requiring the user to click on the link twice to get the form to popup. Externally, it gives me the error 5.
If I use a "modify" button instead, the problem does not happen, but the client does not want to require the user to click on the row and then click on the modify button, they just want to click on the row and so this becomes an issue.
I modified example WEB (2) with a contain locator and checked the "link to form" box. This is giving me the same behavior as the local side. Maybe the fact I am using SQL has to with the error 5, but the example requires me to click on the row twice before it comes up, whereas the "change" button will open the form immediately.
Any thoughts will be appreciated.
Thanks
Ken Watts
Wasatch Consulting Services
I looked into this a little closer and found that it happens when I check "Link to Form" box on the "On Click" tab for a field. I noticed that the only thing different is "class='nt-fakeget'" is added to the code for the packet.
Locally, the issue is manifesting itself by requiring the user to click on the link twice to get the form to popup. Externally, it gives me the error 5.
If I use a "modify" button instead, the problem does not happen, but the client does not want to require the user to click on the row and then click on the modify button, they just want to click on the row and so this becomes an issue.
I modified example WEB (2) with a contain locator and checked the "link to form" box. This is giving me the same behavior as the local side. Maybe the fact I am using SQL has to with the error 5, but the example requires me to click on the row twice before it comes up, whereas the "change" button will open the form immediately.
Any thoughts will be appreciated.
Thanks
Ken Watts
Wasatch Consulting Services
63
Web Server - Ask For Help / Record not found 5
« on: September 05, 2013, 10:45:39 AM »
I have a browse form with a "contains" locator. I am getting a behavior that is different when using external URL verses using "localhost".
On the localhost, if I type in a string to search and press the "Enter Key" and then I need to click on the row twice to get it to pop up.
Using the external URL, it I type in a string to search and press the "Enter Key" and then I click on the row it gives me "Record Not Found (5) error 0 from Key". Close the error and click on the row again and all is well again.
It appears that there is "timing" issue only if the "Enter Key" is used. The localhost just deals with the issue different verses using the external URL. If I use the "Tab Key" in both, the behavior is just fine. Enter the string and press tab and then click on the row and it works the first time. It only appears to be an issue when using the "Enter Key".
If the external URL acted like the localhost, I would be okay, but the end user is getting the error. It becomes more difficult to test an "example" app using an external URL.
I am using Nettalk 7.22
Any thoughts as to what this issue might be, I would appreciate it.
Thanks
Ken Watts
Wasatch Consulting Services
On the localhost, if I type in a string to search and press the "Enter Key" and then I need to click on the row twice to get it to pop up.
Using the external URL, it I type in a string to search and press the "Enter Key" and then I click on the row it gives me "Record Not Found (5) error 0 from Key". Close the error and click on the row again and all is well again.
It appears that there is "timing" issue only if the "Enter Key" is used. The localhost just deals with the issue different verses using the external URL. If I use the "Tab Key" in both, the behavior is just fine. Enter the string and press tab and then click on the row and it works the first time. It only appears to be an issue when using the "Enter Key".
If the external URL acted like the localhost, I would be okay, but the end user is getting the error. It becomes more difficult to test an "example" app using an external URL.
I am using Nettalk 7.22
Any thoughts as to what this issue might be, I would appreciate it.
Thanks
Ken Watts
Wasatch Consulting Services
64
Web Server - Ask For Help / Processing PHP in XHmtl tab not working
« on: August 07, 2013, 04:37:56 PM »
I would like to run some PHP in the XHtml to post code based on a condition. I wanted to test this using the example in the PHP (58) folder (which I renamed to PHP) for this. The "pattern.php" runs just fine, but the same code in the XHtml tab in the MailboxesFormControl does not run in the example. It prints the code after the "print" command.
I would like to post the following PHP code in the PageHeaderTag procedure at the TOP:
<?php
if(stripos($_SERVER['SERVER_NAME'],"test",0) > 0);?>
<img src="images/test01.png"/>
<?php else;?>
<img src="images/test02.png"/>
<?php endif;?>
Thanks
Ken
I would like to post the following PHP code in the PageHeaderTag procedure at the TOP:
<?php
if(stripos($_SERVER['SERVER_NAME'],"test",0) > 0);?>
<img src="images/test01.png"/>
<?php else;?>
<img src="images/test02.png"/>
<?php endif;?>
Thanks
Ken
65
Looking To Hire / Nettalk Web Server Project
« on: July 26, 2013, 08:17:19 AM »
I am looking for some assistance in a Nettalk website. I have the base, but I need to get the project a bigger jump start to get the website up and running with ordering process and working as I need it. This is working with MSSQL.
Please contact me by email at ken@wasatchconsultingservices.com
Thanks
Ken Watts
Wasatch Consulting Services
Please contact me by email at ken@wasatchconsultingservices.com
Thanks
Ken Watts
Wasatch Consulting Services
66
Web Server - Ask For Help / Accessing another MSSQL table issue
« on: July 24, 2013, 06:44:55 PM »
This was working prior to version 7.12.
I have run into an issue with accessing an additional MSSQL table in the code to gather some additional information. The tables are related and I can add this as a related table to the primary table, but this ends up creating multiple rows for each primary record as there are multiple records in the child table.
I include the required table in the "Other Files" section for the procedure. When I try to access the file I get "connection is busy - s1000" error. I have the MARS option on the table, I even checked the code, but yet it still gives me this error.
Thanks
Ken Watts
Wasatch Consulting Services
I have run into an issue with accessing an additional MSSQL table in the code to gather some additional information. The tables are related and I can add this as a related table to the primary table, but this ends up creating multiple rows for each primary record as there are multiple records in the child table.
I include the required table in the "Other Files" section for the procedure. When I try to access the file I get "connection is busy - s1000" error. I have the MARS option on the table, I even checked the code, but yet it still gives me this error.
Thanks
Ken Watts
Wasatch Consulting Services
67
Web Server - Ask For Help / Calling form without browse
« on: July 16, 2013, 02:39:05 PM »
I am trying to call a form without a browse. I have the unique record id stored in a session value and so I have placed the following code in the INITFORM embed in the form:
p_web.SetValue('UniqueRecordID',p_web.GSV('SessionValue'))
This just keeps giving me an alert indicating that the record cannot be found (error -2). This is on an MSSQL table.
Thanks for your help.
Ken Watts
Wasatch Consulting Services
p_web.SetValue('UniqueRecordID',p_web.GSV('SessionValue'))
This just keeps giving me an alert indicating that the record cannot be found (error -2). This is on an MSSQL table.
Thanks for your help.
Ken Watts
Wasatch Consulting Services
68
Web Server - Ask For Help / Lookup width from EIP
« on: July 10, 2013, 08:06:55 PM »
I have a couple of lookups in an EIP browse. This works great, but I do not see where you can change the width of the lookup like you can from a form.
Thanks
Ken Watts
Wasatch Consulting Services
Thanks
Ken Watts
Wasatch Consulting Services
69
Web Server - Ask For Help / Re: EIP Lookup
« on: June 18, 2013, 10:13:00 AM »
Bruce,
I found my problem. I started from a new browse and worked through it. It was working until I placed some custom code in the "Procedure Setup". It boiled down to the following line of code:
p_web.SetSessionValue('StoreID','100')
When the procedure processes the "Procedure Setup" the first time, no problem. But this code is being processed every time you edit any EIP field. In fact, when you click into a EIP field, the "Procedure Setup" is processed. I have placed code so that this code is only processed once as there are things in that code that I absolutely want processed only once.
Is there are reason the "Procedure Setup" code is processed every time anything is processed for that procedure?
Thanks
Ken Watts
Wasatch Consulting Services
I found my problem. I started from a new browse and worked through it. It was working until I placed some custom code in the "Procedure Setup". It boiled down to the following line of code:
p_web.SetSessionValue('StoreID','100')
When the procedure processes the "Procedure Setup" the first time, no problem. But this code is being processed every time you edit any EIP field. In fact, when you click into a EIP field, the "Procedure Setup" is processed. I have placed code so that this code is only processed once as there are things in that code that I absolutely want processed only once.
Is there are reason the "Procedure Setup" code is processed every time anything is processed for that procedure?
Thanks
Ken Watts
Wasatch Consulting Services
70
Web Server - Ask For Help / Re: EIP Lookup
« on: June 13, 2013, 02:02:42 PM »
After further testing, I have found that the problem only exists when using a lookup with the EIP field. This holds true with the web21 example. If you add the lookup to the example, then the update does not work. The EIP does not get updated and you get an error 40 in the example web21 app. If I do not use the lookup, I do not get the "Field Invalid" error, but as soon as I add the lookup back, if I try typing anything in, it gives me the "Field Invalid" and the lookup does not work.
Ken Watts
Wasatch Consulting Services
Ken Watts
Wasatch Consulting Services
71
Web Server - Ask For Help / Re: EIP Lookup
« on: June 13, 2013, 08:02:11 AM »
I tried the same setup in the web21 example. At first, it gave me the "Field Invalid", but I realized that I had used a lookup field that was a numeric field with a string field. Changed it to match and the process stopped giving me the error and accepted the entry. I went back to my app and looked to see what the two field types were and they were both cstring and the same size. My application properties appear to be identical to the example. The question that I would have before posting a example of what I am doing, what causes the "Field Invalid" error and what are the rules for the EIP field so that this error does not appear.
Ken Watts
Wasatch Consulting Services
Ken Watts
Wasatch Consulting Services
72
Web Server - Ask For Help / EIP Lookup
« on: June 09, 2013, 02:38:37 PM »
I am using EIP string field on a browse that has a lookup. When I type in an entry that matches a record in the lookup file it says "Field Invalid". When using the same lookup in a form it works just fine. In addition, when I click on the "?" next to the field to select a record, no records appear to select. Everything works just fine from a form field using the same field and lookup. What I am doing wrong?
Ken Watts
Wasatch Consulting Services
Ken Watts
Wasatch Consulting Services
73
Web Server - Ask For Help / Slow SQL Update
« on: June 04, 2013, 01:01:21 PM »
I have noticed that saving and deleting records in a MSSQL table is extremely slow. Accessing a record and displaying it is just fine, but saving or deleting records slow down dramatically. In other Clarion apps that I have done, I use PROP:SQL to send SQL code to save and delete records as this improves speed and at times the normal Clarion code does not update the tables correctly if there are calculated fields in the tables. Where would I place SQL code instead of using the Clarion code to update or delete?
Ken Watts
Wasatch Consulting Services
Ken Watts
Wasatch Consulting Services
74
Web Server - Ask For Help / Re: Locator Dropdown
« on: June 04, 2013, 12:52:28 PM »
Kevin and Bruce,
Thanks for you help. This put me in the right direction and I have it working now.
Ken Watts
Wasatch Consulting Services
Thanks for you help. This put me in the right direction and I have it working now.
Ken Watts
Wasatch Consulting Services
75
Web Server - Ask For Help / Locator Dropdown
« on: June 03, 2013, 01:29:33 PM »
I have a browse with multiple columns of which there are 4 columns which the user can click on the header and then the user can type in a search parameter in the locator field. This client would like to have it so that instead of clicking on the column headers, one would use a drop box to select which column to search on.
Thanks
Ken Watts
Wasatch Consulting Services
Using Clarion 8 with Nettalk 7
Thanks
Ken Watts
Wasatch Consulting Services
Using Clarion 8 with Nettalk 7