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.
166
Web Server - Ask For Help / NTWS does not open a file if given absolute path
« on: June 23, 2011, 07:05:53 AM »
Hi all
App is here:
c:\Callcenter\callw.exe
file is here:
c:\callcenter\forms\doc1.pdf
In Browse
if Path is .\forms\doc1.pdf the it opens the file
if Path is c:\callcenter\forms\doc1.pdf then it does not. It says something about Page Not Found etc.
Solutions?
Thx everybody
JVZ
App is here:
c:\Callcenter\callw.exe
file is here:
c:\callcenter\forms\doc1.pdf
In Browse
if Path is .\forms\doc1.pdf the it opens the file
if Path is c:\callcenter\forms\doc1.pdf then it does not. It says something about Page Not Found etc.
Solutions?
Thx everybody
JVZ
167
Web Server - Ask For Help / Re: Hide field once again too small RESOLVED?
« on: April 18, 2011, 11:58:42 PM »
Put this code in After Generated Code of LOG:TaskType - is this the best place? - but it seems to work.
lb:hideemployeesysid = 1 !jvz 20110418
if INLIST(LOG:TaskType,'StaffAvailability','Incidents','StaffDevelopment','EmployeesPaymentQuery')
lb:hideemployeesysid = 0
else
lb:hideemployeesysid = 1 !jvz 20110419 not required
END
put lb:hideemployeesysid in hide field of EMP:EmplyoeeSysID
lb:hideemployeesysid = 1 !jvz 20110418
if INLIST(LOG:TaskType,'StaffAvailability','Incidents','StaffDevelopment','EmployeesPaymentQuery')
lb:hideemployeesysid = 0
else
lb:hideemployeesysid = 1 !jvz 20110419 not required
END
put lb:hideemployeesysid in hide field of EMP:EmplyoeeSysID
168
Web Server - Ask For Help / Hide field once again too small
« on: April 18, 2011, 02:17:33 AM »
Hide field is once again to small even with abbreviations
(p_web.GSV('LOG:TaskType')<>'RequestForStaff'
AND p_web.GSV('LOG:TaskType')<>'StaffAvailability'
AND p_web.GSV('LOG:TaskType')<>'Incidents'
AND p_web.GSV('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GSV('LOG:TaskType')<>'Registration')
AND p_web.GSV('LOG:TaskType')<>'EmployeePaymentQuery')
How about putting the lot in a local variable like loc:gsvstring (CSTRING(2001))
and plonking loc:gsvstring into th ehide field?
eg loc:gsvstring = p_web.GSV(''LOG:TaskType'')<>''RequestForStaff'' &'AND'& p_web.GSV(''LOG:TaskType'')<> ''StaffAvailability''
short version of the loooog string
But code does not work - with Customer waiting for update there is nothing like presure to make my mind blank.
Please help!
[attachment deleted by admin]
(p_web.GSV('LOG:TaskType')<>'RequestForStaff'
AND p_web.GSV('LOG:TaskType')<>'StaffAvailability'
AND p_web.GSV('LOG:TaskType')<>'Incidents'
AND p_web.GSV('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GSV('LOG:TaskType')<>'Registration')
AND p_web.GSV('LOG:TaskType')<>'EmployeePaymentQuery')
How about putting the lot in a local variable like loc:gsvstring (CSTRING(2001))
and plonking loc:gsvstring into th ehide field?
eg loc:gsvstring = p_web.GSV(''LOG:TaskType'')<>''RequestForStaff'' &'AND'& p_web.GSV(''LOG:TaskType'')<> ''StaffAvailability''
short version of the loooog string
But code does not work - with Customer waiting for update there is nothing like presure to make my mind blank.
Please help!
[attachment deleted by admin]
169
Web Server - Ask For Help / Re: Hide field too small to cater for my code?
« on: April 17, 2011, 09:43:52 PM »
If you could perhaps abbreviate p_web.GetSessionValue to p_web.GSV?<g>
170
Web Server - Ask For Help / Hide field too small to cater for my code?
« on: April 17, 2011, 09:35:58 PM »
This is what I type in
(p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffAvailability'
AND p_web.GetSessionValue('LOG:TaskType')<>'Incidents'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GetSessionValue('LOG:TaskType')<>'EmployeePaymentQuery')
After compiling
loc:prompt = Choose((p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffAvailability'
AND p_web.GetSessionValue('LOG:TaskType')<>'Incidents'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GetSes,'',p_web.Translate('Employee Name:'))
see attached.
This is a showstopper Hope help is at hand.
Many Thanks
[attachment deleted by admin]
(p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffAvailability'
AND p_web.GetSessionValue('LOG:TaskType')<>'Incidents'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GetSessionValue('LOG:TaskType')<>'EmployeePaymentQuery')
After compiling
loc:prompt = Choose((p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffAvailability'
AND p_web.GetSessionValue('LOG:TaskType')<>'Incidents'
AND p_web.GetSessionValue('LOG:TaskType')<>'StaffDevelopment'
AND p_web.GetSes,'',p_web.Translate('Employee Name:'))
see attached.
This is a showstopper Hope help is at hand.
Many Thanks
[attachment deleted by admin]
171
Web Server - Ask For Help / Re: DropDown/Must be In List - still getting errors
« on: April 15, 2011, 05:23:53 AM »
OK - Resolved.
at first I had only these choices:
No|Yes|NA
and therefore CSTRING(4) was good enough.
THEN I decided to add NotSelected as in
NotSelected|No|Yes|NA
but I did not increase the length of CSTRING!
Now with CSTRING(21) all is well!
Thx Bruce!
at first I had only these choices:
No|Yes|NA
and therefore CSTRING(4) was good enough.
THEN I decided to add NotSelected as in
NotSelected|No|Yes|NA
but I did not increase the length of CSTRING!
Now with CSTRING(21) all is well!
Thx Bruce!
172
Web Server - Ask For Help / DropDown/Must be In List - still getting errors
« on: April 15, 2011, 01:11:41 AM »
Hi
Must Be In List: NotSelected|Yes|No|NA
Attributes/Initial Value 'NotSelected' (I don't think NTWS uses this))
Field is Primed with 'NotSelected' om Form and I still get
LOG:HasPrivateExperience Must be one of NotSelected, Yes, No, NA
How do I resolve this?
See attachments.
Thx
[attachment deleted by admin]
Must Be In List: NotSelected|Yes|No|NA
Attributes/Initial Value 'NotSelected' (I don't think NTWS uses this))
Field is Primed with 'NotSelected' om Form and I still get
LOG:HasPrivateExperience Must be one of NotSelected, Yes, No, NA
How do I resolve this?
See attachments.
Thx
[attachment deleted by admin]
173
Web Server - Ask For Help / Re: Conditionaly Hide/UnHide columns on form
« on: April 14, 2011, 06:15:21 AM »
That was it thanks - and thanks to Bruce as well!
174
Web Server - Ask For Help / Re: Conditionaly Hide/UnHide columns on form
« on: April 14, 2011, 04:48:07 AM »
In Hide for LOG:HasBeenCancelled I have:
p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
Default value for LOG:HasBeenCancelled = 'No'
In Hide for LOG:DateCancelled and LOG:TimeCancelleDateCancelled and TimeCancelled I have:
(p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' OR p_web.GetSessionValue('LOG:HasBeenCancelled ')<>'Yes')
When changing LOG:HasBeenCancelled from 'No' to 'Yes' LOG:DateCancelled and LOG:TimeCancelleDateCancelled do not become visible immediately. I must 1st Save and Change - then I see them.
p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
Default value for LOG:HasBeenCancelled = 'No'
In Hide for LOG:DateCancelled and LOG:TimeCancelleDateCancelled and TimeCancelled I have:
(p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' OR p_web.GetSessionValue('LOG:HasBeenCancelled ')<>'Yes')
When changing LOG:HasBeenCancelled from 'No' to 'Yes' LOG:DateCancelled and LOG:TimeCancelleDateCancelled do not become visible immediately. I must 1st Save and Change - then I see them.
175
Web Server - Ask For Help / AutoIncrement LONG shows as ZERO on Form upon Insert
« on: April 14, 2011, 12:01:50 AM »
Hi
My client wants to see the actual number on the Form when inserting as they use it as a LogNumber on the Log table.
I know this has been discusssed to death all over the Clarion world and I know that if not Saved that the Number will be lost if anybody else has added a record in the mean time.
But is there a way to show the LogNumber on screen when Inserting?
My client wants to see the actual number on the Form when inserting as they use it as a LogNumber on the Log table.
I know this has been discusssed to death all over the Clarion world and I know that if not Saved that the Number will be lost if anybody else has added a record in the mean time.
But is there a way to show the LogNumber on screen when Inserting?
176
Web Server - Ask For Help / Conditionaly Hide/UnHide columns on form
« on: April 13, 2011, 11:37:17 PM »
The second part is only executed after Save and Change
in DateCancelled and TimeCancelled I have (p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' OR p_web.GetSessionValue('LOG:HasBeenCancelled ')<>'Yes')
1st you choose TaskType = 'RquestForStaff' then HasBeenCancelled appears with default = ''No' which keeps DateCancelled and TimeCancelled hidden which is correct.
If I now choose 'Yes' from DropDown then DateCancelled and TimeCancelled does not become visible untill I Save and Change.
How do I fix this?
THX!
in DateCancelled and TimeCancelled I have (p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' OR p_web.GetSessionValue('LOG:HasBeenCancelled ')<>'Yes')
1st you choose TaskType = 'RquestForStaff' then HasBeenCancelled appears with default = ''No' which keeps DateCancelled and TimeCancelled hidden which is correct.
If I now choose 'Yes' from DropDown then DateCancelled and TimeCancelled does not become visible untill I Save and Change.
How do I fix this?
THX!
177
Web Server - Ask For Help / DropDown/ValidityCheck/Must be in List Errors
« on: April 13, 2011, 09:09:26 AM »
NT 5.21 Clarion 9058
I get this seemingly intermittantly on various similar fields.
LOG:CommunicationMethod Must be one of Phone, SMS, Email, Other, NA
They all have Hide code similar to this:
p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
How do I resolve this?
Thx!
I get this seemingly intermittantly on various similar fields.
LOG:CommunicationMethod Must be one of Phone, SMS, Email, Other, NA
They all have Hide code similar to this:
p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff'
How do I resolve this?
Thx!
178
Web Server - Ask For Help / Include/Hide columns on NetWebForm
« on: April 12, 2011, 12:08:50 PM »
I have a Drop for TaskType - depending on which TastType was selected the Form must Include or Hide certain columns.
Sometimes a column is tied to 2 or more TaskTypes
This does not work - it only obeys for the 1st TaskType
Include (p_web.GetSessionValue('LOG:TaskType')='RequestForStaff' or p_web.GetSessionValue('LOG:TaskType')='Registration')
Hide (p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' p_web.GetSessionValue('LOG:TaskType')<>'Registration')
Please how do I get this to work?
ALSO
After choosing a TaskType - how can I immediately Include or Hide the appropriate columns without 1st having to Save record and then Change?
Thanks
Sometimes a column is tied to 2 or more TaskTypes
This does not work - it only obeys for the 1st TaskType
Include (p_web.GetSessionValue('LOG:TaskType')='RequestForStaff' or p_web.GetSessionValue('LOG:TaskType')='Registration')
Hide (p_web.GetSessionValue('LOG:TaskType')<>'RequestForStaff' p_web.GetSessionValue('LOG:TaskType')<>'Registration')
Please how do I get this to work?
ALSO
After choosing a TaskType - how can I immediately Include or Hide the appropriate columns without 1st having to Save record and then Change?
Thanks
179
Web Server - Ask For Help / Anybody using NetTalk's WebServer with PostGreSQL
« on: November 27, 2007, 08:39:48 AM »
Hi
I would like to use NetTalk's WebServer in combination with PostGreSQL but to find a Windows hosting company that will allow you to install a Clarion.exe (WebServer app) as well PostGreSQL seems impossible.
I have tried to install PostGreSQL on OAKPARKSOLUTIONS (http://www.oakparksolutions.com) but it was so EXCRUCIATINGLY slow! And got errors I never found solutions to.
Apparently they only guarantee something like 384MB ram, which does not sound like anywhere near enough for PostGreSQL?
Any suggestions please?
--
Johan van Zyl
johan@jvz.co.za http://www.jvz.co.za
johan@acctual.net http://www.acctual.co.za
johan@watzon.co.za http://www.watzon.co.za
079 549 0034 Cell/Mobile
012 543 2919 Huis/Home
086 622 9554 Fax
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
Teach a man how to surf the Internet and he will never bother you again.
I would like to use NetTalk's WebServer in combination with PostGreSQL but to find a Windows hosting company that will allow you to install a Clarion.exe (WebServer app) as well PostGreSQL seems impossible.
I have tried to install PostGreSQL on OAKPARKSOLUTIONS (http://www.oakparksolutions.com) but it was so EXCRUCIATINGLY slow! And got errors I never found solutions to.
Apparently they only guarantee something like 384MB ram, which does not sound like anywhere near enough for PostGreSQL?
Any suggestions please?
--
Johan van Zyl
johan@jvz.co.za http://www.jvz.co.za
johan@acctual.net http://www.acctual.co.za
johan@watzon.co.za http://www.watzon.co.za
079 549 0034 Cell/Mobile
012 543 2919 Huis/Home
086 622 9554 Fax
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
Teach a man how to surf the Internet and he will never bother you again.