Messages

46

Web Server - Ask For Help / Re: Parent/Child Issue

« on: February 11, 2020, 06:19:57 AM »

I must have had something that I just could not see that was the problem. I am in the early stages, so I just recreated the whole process and now it is working as expected.

Thanks
Ken Watts

47

Web Server - Ask For Help / Parent/Child Issue

« on: February 09, 2020, 01:37:52 PM »

I am trying to get a parent/child process working. I have followed example 25, but I must be missing something. I add a new parent record and all is well if I just save the record without trying to add a child record. If I start to add a parent record and then add a child record (without clicking on the save button of the parent first), the record is auto incremented and the child shows the correct parent ID, but as soon as I save the child record, it returns back to the parent record, the parent record now has a new ID and of course no child records show. If I try to save the parent record, it returns back to the child record page instead of the parent list. If you try to cancel, it goes back to the parent update page with a new ID and if you try to click on the cancel on the parent it returns back to the child page. It is in an endless loop. I can use the browser back button to get back to the parent list page, but now it has saved several parent records and clicking on delete does not delete anything and clicking on change gives me a fetch error.

I can upload the file to review if needed. Just don't know what I am doing wrong.

Thanks
Ken Watts

48

Web Server - Ask For Help / Re: File sent in email is empty

« on: June 21, 2017, 08:33:01 PM »

Thanks for the help. I simply closed the file, sent the email, and then re-opened the file again and it worked just fine.

Thanks
Ken Watts

49

Web Server - Ask For Help / File sent in email is empty

« on: June 20, 2017, 03:11:01 PM »

I am using NetTalk 9 and I am trying to send a text file as an attachment via email. The email is sent with an attachment, but the file getting sent is empty. Yet the file on the computer does have data in it. The process creates the file and then I use the NetTalk to send the email.

Any idea as to why this would happen? Am I missing something?

Thanks
Ken Watts

50

Web Server - Ask For Help / Re: MSSQL Text field processing

« on: November 10, 2015, 11:25:18 AM »

Found the issue.

I placed the code to get the text from the blob field in the "PreUpdate" embed and it was grabbing the data, but when I set the session variable "p_web.SetSessionValue('LOC:Text',LOC:Text)", it was blank. I just needed to clip the data field. The data field I am saving the text to is a STRING(65535) and so this needed to be clipped.

p_web.SetSessionValue('LOC:Text',CLIP(LOC:Text))

Ken

51

Web Server - Ask For Help / Re: MSSQL Text field processing

« on: November 10, 2015, 09:15:38 AM »

From what I see, this is used to send the contents of a blob to a file. Once you send the data to a file, are you displaying the file? I am trying to display the text in the blob and not send the data to a file so I am not sure how BLOBTOFILE applies, can you give me an example?

Thanks
Ken

52

Web Server - Ask For Help / Re: MSSQL Text field processing

« on: November 09, 2015, 08:36:58 AM »

Sorry, should have mentioned that I was trying to work with the blob on a web form. I was trying to read it with blobfield[0 : size(blobfield)] which causes a crash, so I used the FromBlob in string theory to read the blob.

Thanks
Ken

53

Web Server - Ask For Help / MSSQL Text field processing

« on: November 08, 2015, 11:27:41 PM »

I have am reading a MSSQL table with a "Text" field. This is translated as a "Blob" in Clarion. NetTalk crashes trying to read this file directly, so I have used the String Theory "FromBlob" to read the field successfully, but for the life of me, I cannot figure out how to get this to display. I have created a local variable to hold the data and it does get the data "in certain embeds", but does not show. I have placed the code to get the data in the "PreUpdate" start embed which does place the data in the local variable, but again, nothing on the screen shows. Tried using "do Refresh::Local", but this causing unexpected results at this point.

Thanks
Ken Watts

54

Web Server - Ask For Help / Re: net:f:filename

« on: October 28, 2015, 10:15:34 PM »

Thanks for tip on the location of the files. For some reason I wasn't thinking that is where the files needed to be and the documentation does not make that clear.

Thanks

55

Web Server - Ask For Help / net:f:filename

« on: October 26, 2015, 10:53:12 AM »

I am trying to use the "net:f:filename" to add some static code. If I go into the "IndexPage" procedure and add Xhtml to "After <body>" and type in "<!-- Net:f:filename.html -->" it does not bring in the specified file. Right now the file just says "<p>test</p>", but yet I get nothing. I am doing this incorrectly?

Thanks
Ken

56

Web Server - Ask For Help / Nettalk object and dll versions do not match

« on: April 10, 2014, 09:55:12 PM »

I just upgraded to Nettalk 8 and the new compiled program will not run. It is giving me an error 90 - Nettalk object and dll do not match. What files is the program not matching? I moved the new web folder into place.

Nettalk 8.07 with Clarion 8

Thanks
Ken Watts

57

Web Server - Ask For Help / Re: Record not found 5

« on: September 10, 2013, 06:13:16 AM »

Sorry about that
Ken

[attachment deleted by admin]

58

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]

59

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

60

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