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 / DDesktop Question
« on: April 19, 2016, 12:01:28 PM »
Disconnected Desktop question
With Net Talk 9-07
Using Capesoft examples of Server & Desktop
I delete a table from the DCT - LinkCountriesShippers
When I compile the desktop it throws an error that the SYNCSERVER proc cant find that table to sync
thats reasonable
But does anyone know WHERE to set the tables that the syncServer will sync?
I thought it was under the extensions in the older version of NT9
With Net Talk 9-07
Using Capesoft examples of Server & Desktop
I delete a table from the DCT - LinkCountriesShippers
When I compile the desktop it throws an error that the SYNCSERVER proc cant find that table to sync
thats reasonable
But does anyone know WHERE to set the tables that the syncServer will sync?
I thought it was under the extensions in the older version of NT9
2
Web Server - Ask For Help / Re: Disconnected Desktop - reminder for Bruce
« on: April 18, 2016, 12:29:48 AM »
Please note Bruce, I am not up to DELETES yet, I had troubles adding and changing.
With 9-01 it all worked.
K
With 9-01 it all worked.
K
3
Web Server - Ask For Help / Re: Disconnected Desktop - reminder for Bruce
« on: April 04, 2016, 07:48:20 PM »
Just confirming Alejandro's comment, the Disconnected Desktop was working in 901 and I just tested 902, its broken.
by working I mean the client can send an update to the server and the server will update its record.
K
by working I mean the client can send an update to the server and the server will update its record.
K
4
Web Server - Ask For Help / Re: Web40.app FileDownload Example won't compile
« on: April 04, 2016, 07:42:32 PM »
Here are my older app and dct for #40, I just compiled them with NT906 and they are good.
hope this helps
hope this helps
5
Web Server - Ask For Help / Re: p_web._SendFile Question
« on: April 03, 2016, 09:22:26 PM »
Try this
Case
of 1; p_web.Script( p_web.WindowOpen( 'IndexPage' ))
of 2; p_web.Script( p_web.WindowOpen( 'CustomerPage' ))
and if you want to change the theme for different users
of 3
p_web.ChangeTheme( 'Shoestrap' )
p_web.Script( p_web.WindowOpen( 'NiceUserPage' ))
Case
of 1; p_web.Script( p_web.WindowOpen( 'IndexPage' ))
of 2; p_web.Script( p_web.WindowOpen( 'CustomerPage' ))
and if you want to change the theme for different users
of 3
p_web.ChangeTheme( 'Shoestrap' )
p_web.Script( p_web.WindowOpen( 'NiceUserPage' ))
6
Web Server - Ask For Help / Re: Programmatically (without user intervention) run javascript using NT9
« on: March 29, 2016, 11:01:00 PM »
Y'know, I was going to msg you a similar possibility yesterday, but I was trying to think of a more elegant solution. But then there is the invoice at the end of the month... Good man, you got out of the woods.
It was all about an easy (time effective) way to run js on the server side.
K
It was all about an easy (time effective) way to run js on the server side.
K
7
Web Server - Ask For Help / Re: HTTP Request (get and post)
« on: March 29, 2016, 08:01:47 PM »
Oggy, I sent you an email - give me a call
8
Web Server - Ask For Help / Disconnected Desktop - reminder for Bruce
« on: March 29, 2016, 07:59:49 PM »
Re NTUG-93 Alejandro had an issue with the disconnected desktop
I have compiled the Capesoft example with 9.06 and it still has the bug, if you delete the servers data and do a sync it is not inserting or updating
The bug
in PrimeParameters routine using JSON the SyncCloud_Action is set to 'insert' but the lines below
If json.GetPropertyValue('SyncCloud_Action',1) <> ''
SyncCloud_Action = json.GetPropertyValue('SyncCloud_Action',1) !!! sets it back to 'sync'
--------------
then AutoService:SyncCloud is called where sync is not part of the case statement. ie no insert
I have compiled the Capesoft example with 9.06 and it still has the bug, if you delete the servers data and do a sync it is not inserting or updating
The bug
in PrimeParameters routine using JSON the SyncCloud_Action is set to 'insert' but the lines below
If json.GetPropertyValue('SyncCloud_Action',1) <> ''
SyncCloud_Action = json.GetPropertyValue('SyncCloud_Action',1) !!! sets it back to 'sync'
--------------
then AutoService:SyncCloud is called where sync is not part of the case statement. ie no insert
9
Web Server - Ask For Help / Re: PHP MS Sql connection error
« on: March 02, 2016, 05:20:47 AM »
To osquiabro
Hi, thanks for your hints regarding PHP
I am still not getting Net Talk Server to send via php to a database and get a result.
Can you tell me please if you can do a SELECT and get a result set back via PHP ?
Would you mind sending me your PHP.INI as I think that this is where I am having trouble with some setting
Also - did you have to move the php-cgi.exe to another folder (the web folder) to avoid triggering the PHP redirection security alert?
Thanks for any help you can pass me.
Hi, thanks for your hints regarding PHP
I am still not getting Net Talk Server to send via php to a database and get a result.
Can you tell me please if you can do a SELECT and get a result set back via PHP ?
Would you mind sending me your PHP.INI as I think that this is where I am having trouble with some setting
Also - did you have to move the php-cgi.exe to another folder (the web folder) to avoid triggering the PHP redirection security alert?
Thanks for any help you can pass me.
10
Web Server - Ask For Help / Re: PHP MS Sql connection error
« on: February 28, 2016, 12:47:02 AM »
I now have Server 2008 running and it looks like the drivers are working as I no longer get that error, I have moved on to this error
Security Alert! The PHP CGI cannot be accessed directly.
This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.
So I will try to understand this tomorrow
either to go back to Capesoft's 5.29 PHP in their example, and try to find drivers to suit 5.2. Perhaps it was compiled to allow direct access from a Net Talk Server
or
Find a way for NT to set this, as Google suggests setting the PHP.ini to allow direct access (but it didnt work for me)
cgi.redirect_status_env ='yes'
Thanks again for you suggestions
Security Alert! The PHP CGI cannot be accessed directly.
This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a page will only be served up if the REDIRECT_STATUS CGI variable is set, e.g. via an Apache Action directive.
So I will try to understand this tomorrow
either to go back to Capesoft's 5.29 PHP in their example, and try to find drivers to suit 5.2. Perhaps it was compiled to allow direct access from a Net Talk Server
or
Find a way for NT to set this, as Google suggests setting the PHP.ini to allow direct access (but it didnt work for me)
cgi.redirect_status_env ='yes'
Thanks again for you suggestions
11
Web Server - Ask For Help / Disconnected Web issue
« on: February 27, 2016, 10:08:25 PM »
With two desktop browsers and a mobile phone connected to the lan via wifi
I start a desktop Firefox session and browse shippers, but none of the records from the suppliers.tps come over, like FedEx ups etc
I enter one shipper in Firefox (upper half image 1)
I enter one shipper in Chrome (lower half image 1)
I cant get the browser to sync
Nothing I do with the browser will hit the NT server.
If I force the url to 127.0.0.1 I can see the server take the request, but still no sync.
I then ask for suppliers or customers, nothing.
using a phone that has NO cache, i hit the server on 192 168 0 101-88 and it gets no records (img 2)
Is there some bug / setting in the examples that prevents the sync happening?
Is there any way to force it to sync?
Image 3 shows suppliers.tps
I start a desktop Firefox session and browse shippers, but none of the records from the suppliers.tps come over, like FedEx ups etc
I enter one shipper in Firefox (upper half image 1)
I enter one shipper in Chrome (lower half image 1)
I cant get the browser to sync
Nothing I do with the browser will hit the NT server.
If I force the url to 127.0.0.1 I can see the server take the request, but still no sync.
I then ask for suppliers or customers, nothing.
using a phone that has NO cache, i hit the server on 192 168 0 101-88 and it gets no records (img 2)
Is there some bug / setting in the examples that prevents the sync happening?
Is there any way to force it to sync?
Image 3 shows suppliers.tps
12
Web Server - Ask For Help / Disconnected Desktop issues
« on: February 27, 2016, 09:41:28 PM »
Using the Capesoft example, with a server running
and two desktops running (D1 & D2) in separate folders - ie they hold individual data when disconnected.
Issue 1
if you hit insert on D1 the form opens, lets say it shows Invoice=1 , your user looks at the form for a while (makes coffee for 1 min - sync occurs) and decides not to do this and hits cancel.
Look at D2 (refresh invoices) it now has an empty record with Invoice=1
Is there a way to stop this happening ?
Issue 2
In the example - the update invoice form has no range limit (by table) set, but even when you fix this
The Invoice has a child browse of Line Items
If you enter any, these items dont get updated.
Is this a "to-do" - or is the sync of children the programers responsibility, and if so, is it correct procedure to call the Sync LineItems ?
Using NT 906 / J Files 119 / String 243 / X 277
and two desktops running (D1 & D2) in separate folders - ie they hold individual data when disconnected.
Issue 1
if you hit insert on D1 the form opens, lets say it shows Invoice=1 , your user looks at the form for a while (makes coffee for 1 min - sync occurs) and decides not to do this and hits cancel.
Look at D2 (refresh invoices) it now has an empty record with Invoice=1
Is there a way to stop this happening ?
Issue 2
In the example - the update invoice form has no range limit (by table) set, but even when you fix this
The Invoice has a child browse of Line Items
If you enter any, these items dont get updated.
Is this a "to-do" - or is the sync of children the programers responsibility, and if so, is it correct procedure to call the Sync LineItems ?
Using NT 906 / J Files 119 / String 243 / X 277
13
Web Server - Ask For Help / Re: session counting
« on: February 27, 2016, 08:17:48 PM »
Hi, maybe you can look at the user agent to see if its mobile
see NT-User Group Meeting 92 at 17mins Bruce talks about what is mobile
things like SetMobileBaseOnAgent( )
should get you android / ios / etc
see http://www.capesoft.com/accessories/NetTalkUserGroup.htm
see NT-User Group Meeting 92 at 17mins Bruce talks about what is mobile
things like SetMobileBaseOnAgent( )
should get you android / ios / etc
see http://www.capesoft.com/accessories/NetTalkUserGroup.htm
14
Web Server - Ask For Help / Re: DisconnectedDesktop
« on: February 25, 2016, 06:50:19 PM »
Bruce hid mine in Clarion10\capesoft\NetTalk\Apps
dont look in Web Server
dont look in Web Server
15
Web Server - Ask For Help / Re: PHP MS Sql connection error
« on: February 25, 2016, 06:27:00 PM »
thanks for the reply - bit of a mixture
ms sql is on server 2003
iis - I have 2 pcs that I have been trying, one is server 2008, and one is Win7
I cant see that the sql machine matters, its just a transaction to port 1433
Both Server 2012 and Win 7 box is running IIS 7 and php 5.4
I am running php 5.4 as I had endless troubles loading php 7 and gave up, started over again with 5.4
ms sql is on server 2003
iis - I have 2 pcs that I have been trying, one is server 2008, and one is Win7
I cant see that the sql machine matters, its just a transaction to port 1433
Both Server 2012 and Win 7 box is running IIS 7 and php 5.4
I am running php 5.4 as I had endless troubles loading php 7 and gave up, started over again with 5.4