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 / NetWebService, how to exclude all Example and Help
« on: April 03, 2020, 02:29:14 PM »
How to exclude all documentations for Examples and Help routine from all the syncTables?
By removing those, the generated source code will be reduce by 550%
Only want to do the Data Synchronization for Disconnect App, Server and Client.
By removing those, the generated source code will be reduce by 550%
Only want to do the Data Synchronization for Disconnect App, Server and Client.
2
Web Server - Ask For Help / Server and Client Disconnect ts and sts problem with Date+time Clock
« on: April 01, 2020, 06:29:51 PM »
C11 ABC, NTApp ver11.31
After debugging for past 3 days.
Finally....
A. Server disconnect, the Server's computer clock
B. Local LAN PC clock (App.exe access the "A" server database)
Both A and B on same LAN
C. Client disconnect, the Local PC clock (from different department)
Both A and B clock is off by 3 minutes.
Example:
A=10:33:00am and B=10:30:10am C=10:32:50am
When "B" insert a new record to the server database, the ts and sts stored 10:30:10am
When "C", start to Sync with the "A" Server, the Server Log "everythingafter" show example 158579xxx like 10:33:00am.
The "C", cannot fetch any record that "B" had inserted at 10:30:10am
After changed the "B" computer to clock to match the "A" clock, everything work out, ok.
If I don't change the "B" PC clock, and do "Force Fetch All Data" or "Force Send All Data", every records will synchronize because, "C" will send "everythingafter" = -1
Is there a way to prevent the situation where ts, sts, and dts date+time is behind the server clock?
Regards,
KC Chin
After debugging for past 3 days.
Finally....
A. Server disconnect, the Server's computer clock
B. Local LAN PC clock (App.exe access the "A" server database)
Both A and B on same LAN
C. Client disconnect, the Local PC clock (from different department)
Both A and B clock is off by 3 minutes.
Example:
A=10:33:00am and B=10:30:10am C=10:32:50am
When "B" insert a new record to the server database, the ts and sts stored 10:30:10am
When "C", start to Sync with the "A" Server, the Server Log "everythingafter" show example 158579xxx like 10:33:00am.
The "C", cannot fetch any record that "B" had inserted at 10:30:10am
After changed the "B" computer to clock to match the "A" clock, everything work out, ok.
If I don't change the "B" PC clock, and do "Force Fetch All Data" or "Force Send All Data", every records will synchronize because, "C" will send "everythingafter" = -1
Is there a way to prevent the situation where ts, sts, and dts date+time is behind the server clock?
Regards,
KC Chin
3
Web Server - Ask For Help / NetTalk extension template - NetDip Class
« on: January 02, 2019, 08:34:15 PM »
NetTalk.tpl
#Boxed,Where(%ABCBaseClass='NetDIP'),at(2,20),section
#Prompt('&Room Name',@s255),%RoomName,Default('myRoom'),Req
#Display('This will be the room added and used on the server.')
#prompt('Server &Address:',@s80),%NetAppSite,default('''dip.capesoft.com''')
#display('You can use the free DIP server at ''dip.capesoft.com''')
#display('Or you can also run your own DIP Server')
#prompt('Server &Port (def 6873)',@n9),%NetAppPort,default(6873)
#display('This is the site address and port of the DIP server.')
Hi Bruce,
Instead I modify the template,
Is it possible for Capesoft to change the
#prompt('Server &Port (def 6873)',@n9),%NetAppPort,default(6873)
to STRING
#prompt('Server &Port (def 6873)',@S9),%NetAppPort,default(6873)
where I can place Local Variable at NetAppPort.
TIA
#Boxed,Where(%ABCBaseClass='NetDIP'),at(2,20),section
#Prompt('&Room Name',@s255),%RoomName,Default('myRoom'),Req
#Display('This will be the room added and used on the server.')
#prompt('Server &Address:',@s80),%NetAppSite,default('''dip.capesoft.com''')
#display('You can use the free DIP server at ''dip.capesoft.com''')
#display('Or you can also run your own DIP Server')
#prompt('Server &Port (def 6873)',@n9),%NetAppPort,default(6873)
#display('This is the site address and port of the DIP server.')
Hi Bruce,
Instead I modify the template,
Is it possible for Capesoft to change the
#prompt('Server &Port (def 6873)',@n9),%NetAppPort,default(6873)
to STRING
#prompt('Server &Port (def 6873)',@S9),%NetAppPort,default(6873)
where I can place Local Variable at NetAppPort.
TIA
4
Web Server - Ask For Help / CapeSoft.NetTalk.Do Not Sync this Table
« on: December 25, 2018, 02:19:32 AM »
Why it generates after setting the Table Option to NOSYSNC?
Kindly refer to the 3 attachments.
Regards
Chin
Kindly refer to the 3 attachments.
Regards
Chin
5
Web Server - Ask For Help / App Sync, Must the Tables and fields name be the same?
« on: November 28, 2018, 06:52:42 AM »
Hi,
NetTalkApps.Htm Introduction,...
"In some ways this means thinking "beyond SQL". SQL has traditionally been the store of choice for many programs, and indeed there are many benefits to having SQL as a store, but data inside a SQL database requires clients to connect to that database. In order to create disconnected programs we have to allow the data to escape the SQL database, returning (possibly changed) at some later point. Of course this does not replace the SQL database - your primary store will likely remain as a SQL database (although it could also be TPS) - but rather it expands the horizons of the database."
Must the Tables and fields name be the same where Server is SQL, and Desktop app is TPS and XML when Sync App Disconnect?
NetTalkApps.Htm Introduction,...
"In some ways this means thinking "beyond SQL". SQL has traditionally been the store of choice for many programs, and indeed there are many benefits to having SQL as a store, but data inside a SQL database requires clients to connect to that database. In order to create disconnected programs we have to allow the data to escape the SQL database, returning (possibly changed) at some later point. Of course this does not replace the SQL database - your primary store will likely remain as a SQL database (although it could also be TPS) - but rather it expands the horizons of the database."
Must the Tables and fields name be the same where Server is SQL, and Desktop app is TPS and XML when Sync App Disconnect?
6
Web Server - Ask For Help / NetSimple and NetWebSocketServer
« on: November 23, 2018, 12:09:55 AM »
Hi,
I am not using the Webserver that need browsers. NetWebServer Allow WebSockets
I have an app which use the NetSimple as a server.
This app does not do web. It is just receiving and sending data from/to client or another server).
(all apps are Clarion)
Questions:
1. Adding the Extension, NetWebSocketServer, how to use or share the same IpAddress and Port?
2. Must the WebSockets requires Web?
Regards,
KC
I am not using the Webserver that need browsers. NetWebServer Allow WebSockets
I have an app which use the NetSimple as a server.
This app does not do web. It is just receiving and sending data from/to client or another server).
(all apps are Clarion)
Questions:
1. Adding the Extension, NetWebSocketServer, how to use or share the same IpAddress and Port?
2. Must the WebSockets requires Web?
Regards,
KC
7
Web Server - Ask For Help / Webserver and WinEvent serial port
« on: November 14, 2018, 01:28:52 AM »
Hi,
I know how to read the serial port without problem.
Question is how to I post it the web from webserver? I just need to update a single field in real time (maybe a delay of 2 seconds or so) where the webserver is posting the value to client side.
I know how to read the serial port without problem.
Question is how to I post it the web from webserver? I just need to update a single field in real time (maybe a delay of 2 seconds or so) where the webserver is posting the value to client side.
8
Web Server - Ask For Help / NT11.01 WebCam Example 79
« on: November 14, 2018, 01:12:11 AM »
Testing WebCam Example 79,
error on procedure, PageFooterTag and PageHeaderTag
XHTML one, condition not p_web.IsMobile()
After I removed it, and webcam just doesn't work.
error on procedure, PageFooterTag and PageHeaderTag
XHTML one, condition not p_web.IsMobile()
After I removed it, and webcam just doesn't work.
9
The Rest - Ask For Help / What is the differences 4.32 and 4.31 pre release 38
« on: May 25, 2009, 01:20:11 AM »
What is the different between 4.32 and 4.31 pre-release 38?
Presently, I am using the 4.31 pre-release 38.
Need some advice.
Regards
KC Chin
Presently, I am using the 4.31 pre-release 38.
Need some advice.
Regards
KC Chin
10
Web Server - Ask For Help / Possible bug: Path on PDF preview
« on: March 11, 2009, 04:49:23 AM »
Global - Program Setup
SYSTEM{Prop:Datapath} = 'D:\STank64\Data'
PDFReporter.SetUp PROCEDURE
CODE
...
If Not p_Web &= NULL
SELF.SetFileName(clip(p_web.site.WebFolderPath) & '\' & clip(loc:PDFName))
End
Error Message
TARGET Openfile
ERROR:(3) Path Not Found
Can't create target file web\$$$55769.pdf
Looks like the pdf output to different path
when I create a folder 'D:\STank64\Data\web', the report will print/save to the web folder. from there, no display or "Page Load Error" on web page.
message(p_web.site.WebFolderPath ) = web
If I set the path at
PDFReporter.SetUp PROCEDURE
SELF.SetFileName('D:\STank64\TheWeb\' & clip(p_web.site.WebFolderPath) & '\' & clip(loc:PDFName))
everything works fine.
SYSTEM{Prop:Datapath} = 'D:\STank64\Data'
PDFReporter.SetUp PROCEDURE
CODE
...
If Not p_Web &= NULL
SELF.SetFileName(clip(p_web.site.WebFolderPath) & '\' & clip(loc:PDFName))
End
Error Message
TARGET Openfile
ERROR:(3) Path Not Found
Can't create target file web\$$$55769.pdf
Looks like the pdf output to different path
when I create a folder 'D:\STank64\Data\web', the report will print/save to the web folder. from there, no display or "Page Load Error" on web page.
message(p_web.site.WebFolderPath ) = web
If I set the path at
PDFReporter.SetUp PROCEDURE
SELF.SetFileName('D:\STank64\TheWeb\' & clip(p_web.site.WebFolderPath) & '\' & clip(loc:PDFName))
everything works fine.
11
Web Server - Ask For Help / How to create autoincrement both Parent Child New Record when Save
« on: March 10, 2009, 07:48:58 PM »
Hi Bruce,
Tried for a week, still confuse.
Is there an example of Parent-Child where no autoincrement occurred when user Insert New Parent and Insert New Child records? Only autoincrement(both parent & child) after user Save the record.
I went thru' all the examples, still can't figure which one.
Parent Table, pt:pk_pt_sysid(auto)
pt:pt_sysid (long)
Child Table, ct:pk_ct_sysid(auto) and ct:fk_pt_sysid(non auto and link to pt:pk_pt_sysid)
ct:ct_sysid (long)
pt:pt_sysid (long)
Parent(Browse) > FormBrowse (Parent-Form, Child Browse) >Form(Child)
Tried for a week, still confuse.
Is there an example of Parent-Child where no autoincrement occurred when user Insert New Parent and Insert New Child records? Only autoincrement(both parent & child) after user Save the record.
I went thru' all the examples, still can't figure which one.
Parent Table, pt:pk_pt_sysid(auto)
pt:pt_sysid (long)
Child Table, ct:pk_ct_sysid(auto) and ct:fk_pt_sysid(non auto and link to pt:pk_pt_sysid)
ct:ct_sysid (long)
pt:pt_sysid (long)
Parent(Browse) > FormBrowse (Parent-Form, Child Browse) >Form(Child)
Pages: [1]