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.
Pages: [1]
1
Web Server - Ask For Help / Example 26 - webclient
« on: February 21, 2012, 12:25:03 AM »
Hi Bruce,
In example 26client.app, when posting:
net.SetValue('MAI__MailBoxName',clip(MailBoxName))
should be change to:
net.SetValue('MAI__Name',clip(MailBoxName))
This to reflect the changes made in the dct.
Cheers
Koen Chen
Nettalk 6.21
In example 26client.app, when posting:
net.SetValue('MAI__MailBoxName',clip(MailBoxName))
should be change to:
net.SetValue('MAI__Name',clip(MailBoxName))
This to reflect the changes made in the dct.
Cheers
Koen Chen
Nettalk 6.21
2
Web Server - Ask For Help / PHP mysql / sqldrv access + Nettalk 6
« on: February 12, 2012, 05:31:50 AM »
Hi everyone,
Since there is a lot of PHP software around and NTWS supports PHP, I wanted to run PHP software with Nettalk as webserver instead of IIS or apache. According to the documentation It is should possible to include Nettalk tags in PHP pages, because these tags are processed after the PHP code.
So theoretically one should, for instance, be able to run for instance joomla + nettalk objects under NTWS.
But this gave problems with connection to databases (I tested with Mysql).
The PHP software (with mysql access) runs impeccable under IIS, but when trying to run with NTWS it will give errors and refuses to connect tot database (all conditions the same, I also tried with firewall disabled, but to no avail). Tot test the connection I use 2 scripts, both attached.
TestMysql.php to test the connection to the database:
Extload.php to test if the drivers are loaded.
Can someone else confirm having the same problems, or is it something with my particular install / php.ini?
Or is it perhaps Nettalk that interferes with the connection? On the other hand, when looking at the server, I only see one request - the get of the requested php file. I am stuck what to do next..
Does someone has any suggestion how to proceed?
Cheers,
Koen Chen
Nettalk 6.18
Tested with
PHP version 5.2.9.2 (examplefolder NT6.18)
PHP 5.3.1 (lastest version of PHP)
[attachment deleted by admin]
Since there is a lot of PHP software around and NTWS supports PHP, I wanted to run PHP software with Nettalk as webserver instead of IIS or apache. According to the documentation It is should possible to include Nettalk tags in PHP pages, because these tags are processed after the PHP code.
So theoretically one should, for instance, be able to run for instance joomla + nettalk objects under NTWS.
But this gave problems with connection to databases (I tested with Mysql).
The PHP software (with mysql access) runs impeccable under IIS, but when trying to run with NTWS it will give errors and refuses to connect tot database (all conditions the same, I also tried with firewall disabled, but to no avail). Tot test the connection I use 2 scripts, both attached.
TestMysql.php to test the connection to the database:
Extload.php to test if the drivers are loaded.
Can someone else confirm having the same problems, or is it something with my particular install / php.ini?
Or is it perhaps Nettalk that interferes with the connection? On the other hand, when looking at the server, I only see one request - the get of the requested php file. I am stuck what to do next..
Does someone has any suggestion how to proceed?
Cheers,
Koen Chen
Nettalk 6.18
Tested with
PHP version 5.2.9.2 (examplefolder NT6.18)
PHP 5.3.1 (lastest version of PHP)
[attachment deleted by admin]
3
Web Server - Ask For Help / NTWS + Windows Azure
« on: June 24, 2011, 12:38:00 AM »
Hi Bruce,
Can a NTWS application be easily moved over to Windows Azure / SQL Azure platform?
Microsoft mentions adding Web roles and Worker roles in Visual Studio 2010.
Do we also have to programs these roles in NTWS or is that not necessary?
And if necessary, how to do that in NT5?
Cheers
Koen chen
Can a NTWS application be easily moved over to Windows Azure / SQL Azure platform?
Microsoft mentions adding Web roles and Worker roles in Visual Studio 2010.
Do we also have to programs these roles in NTWS or is that not necessary?
And if necessary, how to do that in NT5?
Cheers
Koen chen
4
Web Server - Share Knowledge / Re: Row ID's
« on: May 23, 2011, 02:30:39 PM »
Hi Bruce,
Hashing the ID is a very very nice and elegant improvement.
As to: p_web.AddBrowseValue('browsecustomers','customers',cus:idkey,2), you mentioned that the procedure name ('browsecustomers') is an internal optimizer. What do you mean by that? From your example I understand that the procedure name is the name of the calling procedure. But I tried example 24 with the procedure name left blanc and that also works. I did notice that the hash differs between the two, but does leaving it empty will potentially impact the performance?
Cheers,
Koen
Hashing the ID is a very very nice and elegant improvement.
As to: p_web.AddBrowseValue('browsecustomers','customers',cus:idkey,2), you mentioned that the procedure name ('browsecustomers') is an internal optimizer. What do you mean by that? From your example I understand that the procedure name is the name of the calling procedure. But I tried example 24 with the procedure name left blanc and that also works. I did notice that the hash differs between the two, but does leaving it empty will potentially impact the performance?
Cheers,
Koen
5
Web Server - Ask For Help / Re: How to refresh Browseinvoices when LineItems updated or insertd (Example 31)
« on: May 20, 2011, 06:43:21 AM »
Hi Robert,
It indeed works.
Thanks.
Cheers,
Koen
It indeed works.
Thanks.
Cheers,
Koen
6
Web Server - Ask For Help / Re: How to refresh Browseinvoices when LineItems updated or insertd (Example 31)
« on: May 20, 2011, 02:23:11 AM »
Hi Robert,
Yes, I use a popup form.
Cheers,
Koen
Yes, I use a popup form.
Cheers,
Koen
7
Web Server - Ask For Help / Re: How to refresh Browseinvoices when LineItems updated or insertd (Example 31)
« on: May 20, 2011, 12:57:06 AM »
Hi Terryd,
The BrowseInvoices procedure returns a page with two browses. Between these two browses exists a parent – child relationship. The first browse is the invoice browse (parent), the second browse is the line-items browse (child).
When I update or insert into the child browse (line-items), this child-browse itself is refreshed, but the parent browse (Invoices) is not refreshed.
If the whole page is refreshed manually (in the InternetBrowser), then the first browse will also be refreshed and will show the new situation. So I thought the easiest solution was to refresh the whole page after the update either via a javascipt (window.location.reload) or by calling the BrowseInvoices procedure again. But unfortunately I cannot find the right embed to code this refresh.
Cheers,
Koen
The BrowseInvoices procedure returns a page with two browses. Between these two browses exists a parent – child relationship. The first browse is the invoice browse (parent), the second browse is the line-items browse (child).
When I update or insert into the child browse (line-items), this child-browse itself is refreshed, but the parent browse (Invoices) is not refreshed.
If the whole page is refreshed manually (in the InternetBrowser), then the first browse will also be refreshed and will show the new situation. So I thought the easiest solution was to refresh the whole page after the update either via a javascipt (window.location.reload) or by calling the BrowseInvoices procedure again. But unfortunately I cannot find the right embed to code this refresh.
Cheers,
Koen
8
Web Server - Ask For Help / How to refresh Browseinvoices when LineItems updated or insertd (Example 31)
« on: May 18, 2011, 05:17:32 AM »
In example 31 (Accounts): when a LineItem has been changed or a new record inserted, the LineItems Browse is refreshed, but the Invoices Browse is not refreshed automatically. I have to do that manually.
How can I make it automatically refresh the invoicebrowse after the LineItems file is changed? (i.e.not via a button).
Cheers,
Koen
How can I make it automatically refresh the invoicebrowse after the LineItems file is changed? (i.e.not via a button).
Cheers,
Koen
9
Web Server - Ask For Help / Re: How to override filemanager global to autonumber
« on: May 17, 2011, 02:30:00 AM »
Hi Bruce,
Thanks for showing me the direction.
Hi Charl,
Thanks for your suggestion.
I have been playing around with autonumber On and Off in the dct.
As I am concerned, if I put the code in the Pre-Insert embed, both cases will be work. I think it is a matter of preference and perhaps old habits.
As to unique keys handling in SQL databases:
If not only Clarion, but also other software (Microsoft / Vb / Django, or whatever) update the SQL database, then indeed the best way is to have the database provide for the unique key.
But if all the programming is done in Clarion, then it might be easier and more flexible to do that in Clarion. When changing to another type of database or to a non-sql database, one does not have to worry about the unique key, because that is all handled by oneself.
Cheers,
Koen
Thanks for showing me the direction.
Hi Charl,
Thanks for your suggestion.
I have been playing around with autonumber On and Off in the dct.
As I am concerned, if I put the code in the Pre-Insert embed, both cases will be work. I think it is a matter of preference and perhaps old habits.
As to unique keys handling in SQL databases:
If not only Clarion, but also other software (Microsoft / Vb / Django, or whatever) update the SQL database, then indeed the best way is to have the database provide for the unique key.
But if all the programming is done in Clarion, then it might be easier and more flexible to do that in Clarion. When changing to another type of database or to a non-sql database, one does not have to worry about the unique key, because that is all handled by oneself.
Cheers,
Koen
10
Web Server - Ask For Help / Re: How to override filemanager global to autonumber
« on: May 16, 2011, 04:53:27 AM »
Hi Rene,
Good question.
As I understand, the way the Nettalk deals with autonumber is different from the way Clarion does. The Clarion templates start by creating an empty record with a value for the autonumber key. Nettalk does not create the autonumber key beforehand. The autonumber key(value) is created when the record is saved. I personally think the Nettalk method is preferable to the Clarion way. Anyway, when in the dictionary autonumber is ticked, Nettalk will take care the autonumbering for you.
What to do if I want to autonumber, and I want to replace the automatic autonumber algorithm with my own algorithm? (In this context 'autonumbering' does not necessary means a sequential number, but it could also mean calculating a unique id / guid).
I thought overriding the autoinc procedure in the global embeds would do the trick. But it seems the templates do the autonumbering somewhere else. So as to answer your question, I do not want to use both methods, but I want to replace it with my own. And the replacement should preferably be at the filemanager level, so that I do not need to code it each time I use the table with the autoinc key.
Cheers,
Koen
Good question.
As I understand, the way the Nettalk deals with autonumber is different from the way Clarion does. The Clarion templates start by creating an empty record with a value for the autonumber key. Nettalk does not create the autonumber key beforehand. The autonumber key(value) is created when the record is saved. I personally think the Nettalk method is preferable to the Clarion way. Anyway, when in the dictionary autonumber is ticked, Nettalk will take care the autonumbering for you.
What to do if I want to autonumber, and I want to replace the automatic autonumber algorithm with my own algorithm? (In this context 'autonumbering' does not necessary means a sequential number, but it could also mean calculating a unique id / guid).
I thought overriding the autoinc procedure in the global embeds would do the trick. But it seems the templates do the autonumbering somewhere else. So as to answer your question, I do not want to use both methods, but I want to replace it with my own. And the replacement should preferably be at the filemanager level, so that I do not need to code it each time I use the table with the autoinc key.
Cheers,
Koen
11
Web Server - Ask For Help / How to override filemanager global to autonumber
« on: May 16, 2011, 02:38:53 AM »
In the dct I have ticked the option autonumber.
In global embeds Primeautoinc /-primerecords or -primefields (after parentcall) I tried to put my own code of autonumbering the field / key.
But the result is the autonumber of Clarion used and not my own code.
What am I doing wrong as to override globally?
Cheers,
Koen
In global embeds Primeautoinc /-primerecords or -primefields (after parentcall) I tried to put my own code of autonumbering the field / key.
But the result is the autonumber of Clarion used and not my own code.
What am I doing wrong as to override globally?
Cheers,
Koen
Pages: [1]