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.
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.