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.
151
Web Server - Ask For Help / Re: Filter does not work on two browse on same "page"
« on: December 17, 2011, 01:49:05 AM »
Cannot upload PNG
"The upload folder is full. Please try a smaller file and/or contact an administrator."
?
It is a very small PNG file - and how do I contact the administrator?
Hi
Still no luck.
Current filter:
'ALOG:AvailableFromDate <= ' & p_web.GSV('LOG:DateRequired') & ' AND ALOG:AvailableToDate >= ' & p_web.GSV('LOG:DateRequiredTo') & ' AND ALOG:TaskType = <39>StaffAvailability<39> and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
Message shows something like this:
ALOG:AvailableFromDate <= AND ALOG:AvailableToDate >= AND ALOG:TaskType = 'StaffAvailability and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0
(I cannot post the PNG of message here)
This on its own works - ALOG:TaskType = <39>StaffAvailability<39> - no need for UPPER in this case.
See attached for the filter in message.
The values from p_web.GSV does not show?
Source from StaffAvailableBrowse
ThisView{prop:order} = p_web.CleanFilter(ThisView,clip(loc:vorder))
loc:FilterWas = 'ALOG:AvailableFromDate <= ' & p_web.GSV('LOG:DateRequired') & ' AND ALOG:AvailableToDate >= ' & p_web.GSV('LOG:DateRequiredTo') & ' AND ALOG:TaskType = <39>StaffAvailability<39> and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
ThisView{prop:Filter} = loc:FilterWas
Loc:LocatorValue = p_web.GetLocatorValue(Loc:LocatorType,'StaffAvailable',Net:Both)
! Start of "Browse Filter"
! [Priority 5000]
!message(loc:filterwas) ! display message here?
! End of "Browse Filter"
loc:FilterWas = ThisView{prop:filter}
if loc:filterwas <> p_web.GetSessionValue('StaffAvailable_Filter')
p_web.SetSessionValue('StaffAvailable_FirstValue','')
p_web.SetSessionValue('StaffAvailable_Filter',loc:filterwas)
end
p_web._SetView(ThisView,ALog,ALOG:pk_log_lognumber,loc:PageRows,'StaffAvailable',left(Loc:LocateField),loc:FileLoading,loc:LocatorType,clip(loc:LocatorValue),Loc:SortDirection,loc:ViewOptions,Loc:FillBack,Loc:Direction,loc:NextDisabled,loc:PreviousDisabled,Loc:LocatorCase)
! Start of "After SetView"
! [Priority 5000]
message(loc:filterwas) ! or display message here?
Maybe p_web.SSV('LOG:DateRequired') p_web.SSV('LOG:DateRequiredTo') must be done in StaffRequestBrowse?
When you click on row in StaffRequestBrowse the filtered rows must be shown in StaffAvailableBrowse
when you first land on screen with 2 browses from menu choice will the hilited row (1st row by default) in StaffRequestBrowse trigger the filter - or only after selecting a certain row by clicking on it?
Thx!
"The upload folder is full. Please try a smaller file and/or contact an administrator."
?It is a very small PNG file - and how do I contact the administrator?
Hi
Still no luck.
Current filter:
'ALOG:AvailableFromDate <= ' & p_web.GSV('LOG:DateRequired') & ' AND ALOG:AvailableToDate >= ' & p_web.GSV('LOG:DateRequiredTo') & ' AND ALOG:TaskType = <39>StaffAvailability<39> and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
Message shows something like this:
ALOG:AvailableFromDate <= AND ALOG:AvailableToDate >= AND ALOG:TaskType = 'StaffAvailability and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0
(I cannot post the PNG of message here)
This on its own works - ALOG:TaskType = <39>StaffAvailability<39> - no need for UPPER in this case.
See attached for the filter in message.
The values from p_web.GSV does not show?
Source from StaffAvailableBrowse
ThisView{prop:order} = p_web.CleanFilter(ThisView,clip(loc:vorder))
loc:FilterWas = 'ALOG:AvailableFromDate <= ' & p_web.GSV('LOG:DateRequired') & ' AND ALOG:AvailableToDate >= ' & p_web.GSV('LOG:DateRequiredTo') & ' AND ALOG:TaskType = <39>StaffAvailability<39> and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
ThisView{prop:Filter} = loc:FilterWas
Loc:LocatorValue = p_web.GetLocatorValue(Loc:LocatorType,'StaffAvailable',Net:Both)
! Start of "Browse Filter"
! [Priority 5000]
!message(loc:filterwas) ! display message here?
! End of "Browse Filter"
loc:FilterWas = ThisView{prop:filter}
if loc:filterwas <> p_web.GetSessionValue('StaffAvailable_Filter')
p_web.SetSessionValue('StaffAvailable_FirstValue','')
p_web.SetSessionValue('StaffAvailable_Filter',loc:filterwas)
end
p_web._SetView(ThisView,ALog,ALOG:pk_log_lognumber,loc:PageRows,'StaffAvailable',left(Loc:LocateField),loc:FileLoading,loc:LocatorType,clip(loc:LocatorValue),Loc:SortDirection,loc:ViewOptions,Loc:FillBack,Loc:Direction,loc:NextDisabled,loc:PreviousDisabled,Loc:LocatorCase)
! Start of "After SetView"
! [Priority 5000]
message(loc:filterwas) ! or display message here?
Maybe p_web.SSV('LOG:DateRequired') p_web.SSV('LOG:DateRequiredTo') must be done in StaffRequestBrowse?
When you click on row in StaffRequestBrowse the filtered rows must be shown in StaffAvailableBrowse
when you first land on screen with 2 browses from menu choice will the hilited row (1st row by default) in StaffRequestBrowse trigger the filter - or only after selecting a certain row by clicking on it?
Thx!
152
Web Server - Ask For Help / Re: Filter does not work on two browse on same "page"
« on: December 16, 2011, 06:57:30 AM »
Thx Rene!
Still cannot get it to work though - see 2 attached files.
If you click on ASCOT PARK there must be 1 row for StaffAvailable - that still does not display.
if you click on blank Hospital Name there must be none.
Still cannot get it to work though - see 2 attached files.
If you click on ASCOT PARK there must be 1 row for StaffAvailable - that still does not display.
if you click on blank Hospital Name there must be none.
153
Web Server - Ask For Help / Filter does not work on two browse on same "page"
« on: December 16, 2011, 05:21:45 AM »
Hi
LOG table with and alias ALOG
BrowseStaffRequest
and a child on the browse i.e.
BrowseStaffAvailable
when you click on a row in StaffRequest all available staff rows must be shown in StaffAvailable
Filters
This works:
ALOG:TaskType = ''StaffAvailability'' and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
This does not
'ALOG:AvailableFromDate <= p_web.GetSessionValue(''LOG:DateRequired'') AND ALOG:AvailableToDate => p_web.GetSessionValue(''LOG:DateRequiredTo'') AND ALOG:TaskType = ''StaffAvailability'' and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
Where exactly must I put the filer? Under Default Filter of BrowseStaffAvailable
Thx!
LOG table with and alias ALOG
BrowseStaffRequest
and a child on the browse i.e.
BrowseStaffAvailable
when you click on a row in StaffRequest all available staff rows must be shown in StaffAvailable
Filters
This works:
ALOG:TaskType = ''StaffAvailability'' and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
This does not
'ALOG:AvailableFromDate <= p_web.GetSessionValue(''LOG:DateRequired'') AND ALOG:AvailableToDate => p_web.GetSessionValue(''LOG:DateRequiredTo'') AND ALOG:TaskType = ''StaffAvailability'' and ALOG:HasBeenCompleted = 0 and ALOG:HasBeenCancelled = 0'
Where exactly must I put the filer? Under Default Filter of BrowseStaffAvailable
Thx!
154
Web Server - Ask For Help / Many to Many table - Description does not display in Form or Browse
« on: December 14, 2011, 10:52:07 PM »
Hi
Tables
Hospital
HospitalSysID
HospitalName
HospitalDept
HospitalDeptSysID
DepartmentName
Hospital_HospitalDept
Hospital_HospitalDeptSysID
HospitalSysID
HospitalDeptSysID
Log
must I use Hospital_HospitalDeptSysID or HospitalDeptSysID
with Foreign Key on ??
I want the DepartmentName to display in Log Form and Browse
Tables
Hospital
HospitalSysID
HospitalName
HospitalDept
HospitalDeptSysID
DepartmentName
Hospital_HospitalDept
Hospital_HospitalDeptSysID
HospitalSysID
HospitalDeptSysID
Log
must I use Hospital_HospitalDeptSysID or HospitalDeptSysID
with Foreign Key on ??
I want the DepartmentName to display in Log Form and Browse
155
Web Server - Ask For Help / Re: NTWS problem in IE
« on: December 14, 2011, 04:49:04 AM »what version of IE?
what version of NetTalk?
IE 9
NT 6.09
156
Web Server - Ask For Help / NTWS problem in IE
« on: December 14, 2011, 02:33:46 AM »
See attached docs.
Works fine in FireFox and Chrome.
[attachment deleted by admin]
Works fine in FireFox and Chrome.
[attachment deleted by admin]
157
Web Server - Ask For Help / Re: Cannot access 127.0.0.1:88 from other PC's on LAN
« on: December 14, 2011, 12:04:03 AM »
Hi
OK I'm on my own PC(the "server"). I run the Server app - then 127.0.0.1:88 in browser and all is well I can see my Menus, Browses etc.
But I cannot get it to work on any other PC on the LAN (SBS)
What must I enter in the browser of other PC's in the LAN to run the app as well?
Also 127.0.0.1:88?
Or \\ServerName:88
or whatever?
Must I add the Server.EXE in FireWall on my PC(the "server") only or on all participating PC's on LAN?
Must I open port 88 in Firewall on the "server" only or on all participating PC's on LAN?
OK I'm on my own PC(the "server"). I run the Server app - then 127.0.0.1:88 in browser and all is well I can see my Menus, Browses etc.
But I cannot get it to work on any other PC on the LAN (SBS)
What must I enter in the browser of other PC's in the LAN to run the app as well?
Also 127.0.0.1:88?
Or \\ServerName:88
or whatever?
Must I add the Server.EXE in FireWall on my PC(the "server") only or on all participating PC's on LAN?
Must I open port 88 in Firewall on the "server" only or on all participating PC's on LAN?
158
Web Server - Ask For Help / Re: Cannot even access 127.0.0.1
« on: December 10, 2011, 10:34:22 AM »
In my case it is 127.0.0.1:90, I tried that first - that gave the same error - then I tried 127.0.0.1 and even that does not work not on any WS or the Server itself.
159
Web Server - Ask For Help / Cannot even access 127.0.0.1
« on: December 10, 2011, 07:23:33 AM »
I run my Server.exe on a small LAN but cannot access 127.0.0.1 from the server or any of the of the WS.
This web page is not available
The connection to 127.0.0.1 was interrupted.
Here are some suggestions:
Reload this web page later.
Check your Internet connection. Reboot any routers, modems or other network devices that you may be using.
Add Google Chrome as a permitted programme in your firewall or antivirus software's settings. If it is already a permitted programme, try deleting it from the list of permitted programmes and adding it again.
If you use a proxy server, check your proxy settings or contact your network administrator to make sure that the proxy server is working. If you don't believe you should be using a proxy server, adjust your proxy settings: Go to the spanner menu > Options > Under the Bonnet > Change proxy settings... > LAN Settings and deselect the "Use a proxy server for your LAN" checkbox.
Error 101 (net::ERR_CONNECTION_RESET): The connection was reset.
This web page is not available
The connection to 127.0.0.1 was interrupted.
Here are some suggestions:
Reload this web page later.
Check your Internet connection. Reboot any routers, modems or other network devices that you may be using.
Add Google Chrome as a permitted programme in your firewall or antivirus software's settings. If it is already a permitted programme, try deleting it from the list of permitted programmes and adding it again.
If you use a proxy server, check your proxy settings or contact your network administrator to make sure that the proxy server is working. If you don't believe you should be using a proxy server, adjust your proxy settings: Go to the spanner menu > Options > Under the Bonnet > Change proxy settings... > LAN Settings and deselect the "Use a proxy server for your LAN" checkbox.
Error 101 (net::ERR_CONNECTION_RESET): The connection was reset.
160
Web Server - Share Knowledge / Re: CSS Tips for NetTalk programmers
« on: December 09, 2011, 12:04:59 AM »
DesignFestival
http://designfestival.com/10-top-css-design-resources/?utm_source=dlvr.it&utm_medium=facebook&utm_campaign=10-top-css-design-resources
SitePoint
http://reference.sitepoint.com/css
CSS Editors
http://speckyboy.com/2008/09/15/7-free-css-editors-which-is-the-best-you-choose/
http://www.smashingmagazine.com/2008/06/19/css-editors-reviewed/
http://www.hongkiat.com/blog/top-css-editors-reviewed/
http://sixrevisions.com/css/10-top-notch-css-editors/
http://designfestival.com/10-top-css-design-resources/?utm_source=dlvr.it&utm_medium=facebook&utm_campaign=10-top-css-design-resources
SitePoint
http://reference.sitepoint.com/css
CSS Editors
http://speckyboy.com/2008/09/15/7-free-css-editors-which-is-the-best-you-choose/
http://www.smashingmagazine.com/2008/06/19/css-editors-reviewed/
http://www.hongkiat.com/blog/top-css-editors-reviewed/
http://sixrevisions.com/css/10-top-notch-css-editors/
161
Web Server - Share Knowledge / Re: Rackspace Virtual Servers
« on: December 09, 2011, 12:00:16 AM »I've been trying out a virtual server for NetTalk lately using the Rackspace service.
http://www.rackspacecloud.com/1220.html
The low rate runs to about $60 per month. Bandwidth is extra at around 22c per gig.
Hi Bruce, are you still happy with RackSpace? Any other alternative? Is the pricing still about the same?
Can I serve multiple domains from there for that price?
Cheers
JVZ
162
Web Server - Ask For Help / RightReports txa
« on: December 01, 2011, 07:49:56 AM »
from RightReports Help
Import the RightReportsFunctionsABC.txa or RightReportsFunctionsLegacy.txa file in your clarionx\3rdparty\libsrc folder (if your application is Multi-DLL, import this into your reporting DLL). For NetWebServerApplications, import the RightReportsWebServerFunctionsABC.txa.
Just to be clear - for NetWebServerApplications we ONLY need RightReportsWebServerFunctionsABC.txa. and NOT RightReportsFunctionsABC.txa as well?
JVZ
Import the RightReportsFunctionsABC.txa or RightReportsFunctionsLegacy.txa file in your clarionx\3rdparty\libsrc folder (if your application is Multi-DLL, import this into your reporting DLL). For NetWebServerApplications, import the RightReportsWebServerFunctionsABC.txa.
Just to be clear - for NetWebServerApplications we ONLY need RightReportsWebServerFunctionsABC.txa. and NOT RightReportsFunctionsABC.txa as well?
JVZ
163
Web Server - Ask For Help / Update the Server while users are logged in?
« on: December 01, 2011, 01:20:45 AM »
Hi all
How to go about it - to update the server (say hosted by RackSpace) while users are logged in - say worldwide busy capturing data, printing reports, etc.
JVZ
EDIT:
OK just saw this: "Updating a live application"
BUT isn't there a way to warn users that an update is about to take place and that they must get OUT like in NOW?
Can one not upload a file, text file or whatever and the app polls for its presence and the text can be displayed in say the header?
How to go about it - to update the server (say hosted by RackSpace) while users are logged in - say worldwide busy capturing data, printing reports, etc.
JVZ
EDIT:
OK just saw this: "Updating a live application"
BUT isn't there a way to warn users that an update is about to take place and that they must get OUT like in NOW?
Can one not upload a file, text file or whatever and the app polls for its presence and the text can be displayed in say the header?
164
Web Server - Ask For Help / Re: Update of web folder required
« on: November 30, 2011, 11:11:53 PM »I am getting Update of Web Folder required - Server version = 6.02 but web folder = 6.03 but I have installed and compiled under 6.05
John
I don't know if I've got this right - under "normal" circumstances the Server should have a higher number than the webfolder? Then Ctrl-F% fixes that - except that now this is done for uou automtically.
165
Web Server - Ask For Help / data folder - where to put it?
« on: November 29, 2011, 10:46:47 PM »
Hi
How important is it to have your data folder (TPS files) within the web folder, as in
.\web\data
Can one have it here - c:\AppFolder\data ?
Thx
How important is it to have your data folder (TPS files) within the web folder, as in
.\web\data
Can one have it here - c:\AppFolder\data ?
Thx