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
E-Mail - Ask For Help / NetTalk version upgrade problem. Possible regression bug
« on: January 06, 2023, 09:46:46 AM »
I upgraded from NT 12.28 to NT 12.53 recently and my program that downloads email stopped working. The NetEmailRecieve object is throwing an error number -36 ?The connection is not open and therefore the data can not be sent? in the ErrorTrap. The same program compiled with NT 12.28 works fine. The demo program ?receive.app? in the Jump Start example has the same problem. I tried to email Bruce with slightly modified ?receive.app? with the local variables initialized the credentials of a Outlook account that I am using. However, I know my sympatico ISP email sometimes does not reach Bruce. Bruce if you need the credentials to this Outlook account, let me know.
I saw on NetTalk Central, a post about Outlook requiring Auth2, but I have not seen that requirement for me though. The program using NT 12.28 downloads emails just fine
I saw on NetTalk Central, a post about Outlook requiring Auth2, but I have not seen that requirement for me though. The program using NT 12.28 downloads emails just fine
2
Web Server - Ask For Help / Re: Net Talk Client Tables Sync
« on: January 11, 2016, 07:37:32 AM »
Hello Bruce,
I have a new table for mobile users that has the password, rights and other information of the user to be stored on the mobile app I am writing for Windows. I made the table with the ServerTimeStamp field (and key), but I have made my own code API code to sync this only current users record of the table directly to control security and I only keep the records for the users of that device, not a complete table sync. For now, I will remove the table from the queue. Later I may rename the ServerTimeStamp field, or find that I will have to use the sync methods provided to work with the phone gap app.
Thanks,
Rob
Quote
At this point only tables with a ServerTimeStamp field (and key) will be added to the queue.And it is just a Queue (so you can remove records in embed code if you like.)Okay, I was afraid that the procedure tried to sync all the tables declared in the app.
Quote
I'm not sure that there's a use case for tables which have a ServerTimeStamp field, but should not be sync'd. I guess we'll find out.I believe there are special cases where the programmer may wish to do build their own sync API. For example,
I have a new table for mobile users that has the password, rights and other information of the user to be stored on the mobile app I am writing for Windows. I made the table with the ServerTimeStamp field (and key), but I have made my own code API code to sync this only current users record of the table directly to control security and I only keep the records for the users of that device, not a complete table sync. For now, I will remove the table from the queue. Later I may rename the ServerTimeStamp field, or find that I will have to use the sync methods provided to work with the phone gap app.
Thanks,
Rob
3
Web Server - Ask For Help / Net Talk Client Tables Sync
« on: January 10, 2016, 04:14:55 PM »
Bruce,
I was experimenting with the desktop and server apps for the NT 9 disconnected app . I noticed that the Tables tab was blank of the "Sync client tables with server" extension. I assume then that all tables in the client application have to be synced with the server. In the next release, will the developer be able to select which tables are synced?
or am I missing something?
Also the desktop app had FM with the app. I do not own FM. I removed the DLL from the solution and it compiled and ran fine.
How soon to a new NT9 release?
Thanks,
Rob Kolanko
I was experimenting with the desktop and server apps for the NT 9 disconnected app . I noticed that the Tables tab was blank of the "Sync client tables with server" extension. I assume then that all tables in the client application have to be synced with the server. In the next release, will the developer be able to select which tables are synced?
or am I missing something?
Also the desktop app had FM with the app. I do not own FM. I removed the DLL from the solution and it compiled and ran fine.
How soon to a new NT9 release?
Thanks,
Rob Kolanko
4
Web Server - Ask For Help / NT 9A3 DisconnectedDesktop example is missing Dictionary
« on: November 18, 2015, 08:29:03 AM »
Hi Bruce,
The NT9 Apps Alpha 3 install does install the DisconnectedDesktop example, except the modified invoice.dct dictionary is not included. Thus the app does not load into clarion. Please upload/email/skype the dictionary file to me.
Thanks
Rob
The NT9 Apps Alpha 3 install does install the DisconnectedDesktop example, except the modified invoice.dct dictionary is not included. Thus the app does not load into clarion. Please upload/email/skype the dictionary file to me.
Thanks
Rob
5
Web Server - Ask For Help / Re: ExportToExcel Routine
« on: October 22, 2015, 07:57:45 AM »
Hi Bruce,
To answer your question, occasionally I have the data fields displayed in the browse that are derived in the field's value routine and the local variable is displayed in the column. To me, good coding practice would be to declare the variables used to calculate the column's value with the value routine, since these variables are not used elsewhere. I could simply declare the variable in the NetWebBrowse procedure and the ExportToExcel procedure will pick it up to compile, however will the variable have the correct value? I do not know if the field value routine is called by ExportToExcel routine when the column value is added to the excel file. It should be.
On the other topic on whether if the ExportToExcel routine should be included in every browse. Right now, I guess that I have created over 75 browses and maybe two of them could be a candidate for export to excel. And should I wish to use the feature, I would do what is necessary to validate that the results are correct. The documentation should describe where the values for the excel are generated. I can see no reason to have the template generate code that will not be used, when the option exists to tell the template not to generate the code?
Thanks Rob.
To answer your question, occasionally I have the data fields displayed in the browse that are derived in the field's value routine and the local variable is displayed in the column. To me, good coding practice would be to declare the variables used to calculate the column's value with the value routine, since these variables are not used elsewhere. I could simply declare the variable in the NetWebBrowse procedure and the ExportToExcel procedure will pick it up to compile, however will the variable have the correct value? I do not know if the field value routine is called by ExportToExcel routine when the column value is added to the excel file. It should be.
On the other topic on whether if the ExportToExcel routine should be included in every browse. Right now, I guess that I have created over 75 browses and maybe two of them could be a candidate for export to excel. And should I wish to use the feature, I would do what is necessary to validate that the results are correct. The documentation should describe where the values for the excel are generated. I can see no reason to have the template generate code that will not be used, when the option exists to tell the template not to generate the code?
Thanks Rob.
6
Web Server - Ask For Help / Re: Database triggers and Nettalk web handler
« on: October 15, 2015, 12:20:02 PM »
I have a problem with the proposed method.
pp_web &= p_web
does not compile after the CODE statement in the web handler, because the p_web is not the name of the NetWebServerWorker class in WebHandler. But
pp_web &= ThisNetWorker
seems to work fine.
I have not had the time to figure out why thread pools do not work in my applications yet, but this will be something else to check when I get around to it.
Rob
pp_web &= p_web
does not compile after the CODE statement in the web handler, because the p_web is not the name of the NetWebServerWorker class in WebHandler. But
pp_web &= ThisNetWorker
seems to work fine.
I have not had the time to figure out why thread pools do not work in my applications yet, but this will be something else to check when I get around to it.
Rob
7
Web Server - Ask For Help / Re: ExportToExcel Routine
« on: October 15, 2015, 08:04:25 AM »
Bruce,
These settings are not preventing the ExportToExcel routine from being generated. My tests with example apps show that once the xfiles global extension is added the application, the ExportToExcel routine is generated for every NetWeb Browse. The default global setting has the "Include Export button on browses" as unchecked, thus by default the ExportToExcel routine should not be generated for every browse. Also changing the browse's local setting of "Include Export Button" to No, the ExportToExcel routine is still generated.
Please check your template logic or explain if this is the proper operation.
Thanks
Rob Kolanko
These settings are not preventing the ExportToExcel routine from being generated. My tests with example apps show that once the xfiles global extension is added the application, the ExportToExcel routine is generated for every NetWeb Browse. The default global setting has the "Include Export button on browses" as unchecked, thus by default the ExportToExcel routine should not be generated for every browse. Also changing the browse's local setting of "Include Export Button" to No, the ExportToExcel routine is still generated.
Please check your template logic or explain if this is the proper operation.
Thanks
Rob Kolanko
8
Web Server - Ask For Help / ExportToExcel Routine
« on: October 13, 2015, 01:18:02 PM »
Bruce,
I am not sure if the upgrade to NT8.60 or the addition of xfiles to an application caused the ExportToExcel routine to be generated for all NetWeb Browses, regardless if the browse is going to be used to create an excel file. In some of my browses, the value displayed is a local variable in the column's value routine. Thus compile errors are created because the value for the excel cell is a unknown variable in the ExporToExcel routine. To correct the problem, I have used the embeds in the ExportToExcel routine to omit the routine's code.
Since the code for this feature is not trivial and those that use this feature will not need it for every browse, could the generation of the ExportToExcel routine code be an option on the NetWeb Browse template? Or is there some other way to suppress this code generation.
Thanks,
Rob
I am not sure if the upgrade to NT8.60 or the addition of xfiles to an application caused the ExportToExcel routine to be generated for all NetWeb Browses, regardless if the browse is going to be used to create an excel file. In some of my browses, the value displayed is a local variable in the column's value routine. Thus compile errors are created because the value for the excel cell is a unknown variable in the ExporToExcel routine. To correct the problem, I have used the embeds in the ExportToExcel routine to omit the routine's code.
Since the code for this feature is not trivial and those that use this feature will not need it for every browse, could the generation of the ExportToExcel routine code be an option on the NetWeb Browse template? Or is there some other way to suppress this code generation.
Thanks,
Rob
9
Web Server - Ask For Help / Database triggers and Nettalk web handler
« on: October 12, 2015, 10:37:05 PM »
Hi,
I would like to use Clarion database triggers to execute code whenever certain tables are maintained. This code will need the to use the Nettalk web handler (p_web) methods. I think that this can only be done by creating a new file manager class and and a new relation manager class, where the all database methods would need a web handler parameter. Is there an easier way?
Thanks
Rob
I would like to use Clarion database triggers to execute code whenever certain tables are maintained. This code will need the to use the Nettalk web handler (p_web) methods. I think that this can only be done by creating a new file manager class and and a new relation manager class, where the all database methods would need a web handler parameter. Is there an easier way?
Thanks
Rob
10
Web Server - Ask For Help / Re: Webservice Question
« on: October 05, 2015, 11:46:23 AM »
I asked Bruce about blob fields during a Nettalk webinar and he said that blob fields are not handled by the templates. However you can send and receive binary data as stringtheory fields. When sending a blob from a web service, create a stringtheory return field. In the service method embed, pass your blob data to the stringtheory object, then do a Base64 encode on the value. The client program will receive the string value in XML or JSON object in the page received from the web service. In the AssignField embed of the XML or JSON object intercept the field name of the stringtheory field. Place the value into a client side string theory object. Base64 decode the stringtheory value, then copy the value to the blob field on the client database.
I hope this helps.
Rob
I hope this helps.
Rob
11
Web Server - Ask For Help / Re: NetWebServiceMethod with a File Parameter
« on: August 27, 2015, 08:33:37 AM »
Bump
12
Web Server - Ask For Help / NetWebServiceMethod with a File Parameter
« on: August 24, 2015, 10:44:25 AM »
Hi Bruce,
I was able to upload an image file to a web service using the "FIle" parameter type. The documentation for the File parameter has a format problem. See Attached.
Rob
[attachment deleted by admin]
I was able to upload an image file to a web service using the "FIle" parameter type. The documentation for the File parameter has a format problem. See Attached.
Rob
[attachment deleted by admin]
13
Web Server - Ask For Help / Re: NetWebServiceMethod Template issues.
« on: August 18, 2015, 07:30:33 AM »
Hi Bruce,
If this is not an isolated problem in this app, then it is fairly serious because recompiling clarion applications would not give a reproducible result. Thus I think it has to be in the template or how clarion is interrupting the template. I have upgraded to the most recent version of Clarion 10 (11897) and the problem still exists. I have uploaded the web77 and client apps. A recap:
1) Compile web77 and client apps,
2) With client app, use dbCustomer to get customer ID 10. It may return the list the of customers, or customer 10.
3) In the web77 app, open the dbCustomer procedure. select Actions, Parameters tab, and the Customer Parameter. Now press the OK buttons all the way through the dialogs and recompile.
4) With client app, use dbCustomer to get customer ID 10. It will return customer 10.
5) Save and close web77. Open web77 and compile. Here is the scary part, you will see clarion generate web77002.clw again for no reason without the customer ID parameter and filter in the code, even though the settings are still in the templates and you have not touched them.
Rob
[attachment deleted by admin]
If this is not an isolated problem in this app, then it is fairly serious because recompiling clarion applications would not give a reproducible result. Thus I think it has to be in the template or how clarion is interrupting the template. I have upgraded to the most recent version of Clarion 10 (11897) and the problem still exists. I have uploaded the web77 and client apps. A recap:
1) Compile web77 and client apps,
2) With client app, use dbCustomer to get customer ID 10. It may return the list the of customers, or customer 10.
3) In the web77 app, open the dbCustomer procedure. select Actions, Parameters tab, and the Customer Parameter. Now press the OK buttons all the way through the dialogs and recompile.
4) With client app, use dbCustomer to get customer ID 10. It will return customer 10.
5) Save and close web77. Open web77 and compile. Here is the scary part, you will see clarion generate web77002.clw again for no reason without the customer ID parameter and filter in the code, even though the settings are still in the templates and you have not touched them.
Rob
[attachment deleted by admin]
14
Web Server - Ask For Help / NetWebServiceMethod Template issues.
« on: August 17, 2015, 11:02:55 AM »
Hello Bruce,
I trying to learn web services with the WEB77 example. When I compile the program for the first time, Clarion upgrades the application to version 10, in the process I get a message that a templates missing from the registry will be removed. I do not have the JFiles template. Nevertheless the program compiles and works with the accompanying CLIENT app. Next, I open and save the WEB77 dbCustomer procedure without making any changes to the procedure and recompile, the program still works OK. Next save, close, and open the WEB77 app and recompile again, now the Customer ID parameter does not work to retrieve one customer record using the dbCustomer procedure. All GETs from the CLIENT app on the dbCustomer database returns the whole table. Also I can see from the clarion source that the code for the filter on the view is missing. Now open the dbCustomer procedure again, select Actions, Parameters tab, and the Customer Parameter. Now press the OK buttons all the way through the dialogs and recompile, then WEB 77 dbCustomer procedure will work properly again. But just save, close, open and recompile the app, the dbCustomer procedure code is regenerated without the Customer ID parameter filter again. Using NT 8.59.
Rob
I trying to learn web services with the WEB77 example. When I compile the program for the first time, Clarion upgrades the application to version 10, in the process I get a message that a templates missing from the registry will be removed. I do not have the JFiles template. Nevertheless the program compiles and works with the accompanying CLIENT app. Next, I open and save the WEB77 dbCustomer procedure without making any changes to the procedure and recompile, the program still works OK. Next save, close, and open the WEB77 app and recompile again, now the Customer ID parameter does not work to retrieve one customer record using the dbCustomer procedure. All GETs from the CLIENT app on the dbCustomer database returns the whole table. Also I can see from the clarion source that the code for the filter on the view is missing. Now open the dbCustomer procedure again, select Actions, Parameters tab, and the Customer Parameter. Now press the OK buttons all the way through the dialogs and recompile, then WEB 77 dbCustomer procedure will work properly again. But just save, close, open and recompile the app, the dbCustomer procedure code is regenerated without the Customer ID parameter filter again. Using NT 8.59.
Rob
15
Web Server - Ask For Help / Re: Crash - PLEASE HELP!
« on: August 17, 2015, 10:45:15 AM »
My experience with server applications, it is very hard to know what is causing program to lockup or crash without the right tools.
1) Make sure you have Message and Halt hooks to store any internal clarion messages to a file. Clarion can throw messages for array index errors, etc and unless you are running the app on the console you will not see the message.
2) Add Capesoft GPF Reporter to trap all the source lines of the procedures that called the procedure that caused the GPF. This way you can see the last line in your code which caused the error. I understand the Clarion 10 has a feature to read the Exception Log File from a GPF to trace the program stack,but I have not tried it.
3) Remember that there a lot of parallel processing going on in different threads a Net Talk web app. Your expected order of operations may not be what is happening.
With step 2, at least you have a starting point for investigation. Your problem will be something that you least expected. For example I was using the javascript timer to log off the user as well as the Net Talk server was set to terminate the user after a period of inactivity. What I forgot was that when a user timed out, my session cleanup procedure was run twice at the same time and caused a GPF when memory was freed.
I hope this helps.
Rob
1) Make sure you have Message and Halt hooks to store any internal clarion messages to a file. Clarion can throw messages for array index errors, etc and unless you are running the app on the console you will not see the message.
2) Add Capesoft GPF Reporter to trap all the source lines of the procedures that called the procedure that caused the GPF. This way you can see the last line in your code which caused the error. I understand the Clarion 10 has a feature to read the Exception Log File from a GPF to trace the program stack,but I have not tried it.
3) Remember that there a lot of parallel processing going on in different threads a Net Talk web app. Your expected order of operations may not be what is happening.
With step 2, at least you have a starting point for investigation. Your problem will be something that you least expected. For example I was using the javascript timer to log off the user as well as the Net Talk server was set to terminate the user after a period of inactivity. What I forgot was that when a user timed out, my session cleanup procedure was run twice at the same time and caused a GPF when memory was freed.
I hope this helps.
Rob