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.
31
Web Server - Ask For Help / Upload File Name
« on: October 19, 2011, 11:23:00 PM »
How does Nettalk handle os invalid file names like 42" Monitor Quote[1].rtf
ie what would be the filename on disk?
Cheers,
Kev
ie what would be the filename on disk?
Cheers,
Kev
32
Web Server - Ask For Help / Change Text on OTHER Type Button
« on: September 27, 2011, 06:20:18 PM »
Hi All,
I have an "Other" type of button. The text is set as via GSV. What I'm trying to do is change the text value and disable it after it is clicked while a long process runs (10 sec) so users don't keep clicking the button.
I have added the following code to the embed before my process runs but the text value on screen never changes to wait. Is this possible?
Validate::L:SendForApprovalButton Routine
! Start of "Validate New Value"
! [Priority 5000]
! End of "Validate New Value"
! Start of "Validate New Value"
! [Priority 5000]
p_web.SSV('SendButtonText','Wait..')
do Value::L:SendForApprovalButton
! End of "Validate New Value"
I have an "Other" type of button. The text is set as via GSV. What I'm trying to do is change the text value and disable it after it is clicked while a long process runs (10 sec) so users don't keep clicking the button.
I have added the following code to the embed before my process runs but the text value on screen never changes to wait. Is this possible?
Validate::L:SendForApprovalButton Routine
! Start of "Validate New Value"
! [Priority 5000]
! End of "Validate New Value"
! Start of "Validate New Value"
! [Priority 5000]
p_web.SSV('SendButtonText','Wait..')
do Value::L:SendForApprovalButton
! End of "Validate New Value"
33
Web Server - Ask For Help / MSSQL MARS SPROCS
« on: May 31, 2011, 05:09:45 PM »
Hi All,
Does anyone have a web app or web app/back office windows app using a combination of all above?
I have a web app using MARS and back office app using Sprocs connecting to the same MSSQL DB. I think when the sproc is run the web app crashes. With MARS off no crashing but SQL record locking problems.
Anyone have experience with the above. Any way around the prob?
Cheers,
Kevin
Does anyone have a web app or web app/back office windows app using a combination of all above?
I have a web app using MARS and back office app using Sprocs connecting to the same MSSQL DB. I think when the sproc is run the web app crashes. With MARS off no crashing but SQL record locking problems.
Anyone have experience with the above. Any way around the prob?
Cheers,
Kevin
34
Web Server - Ask For Help / SSL Page not found
« on: April 11, 2011, 06:11:36 PM »
I have a couple of Mac users where they can hit my web app with SSL turned off but not with it turned on. Other users (inc Mac Users) can hit the app from different locations/networks so the SSL works but not from all locations.
I have reset my DNS but still no go.
Anyone have any idea's? I'm not running on the default secure port 443. Would it be their firewall?
Cheers,
Kev
I have reset my DNS but still no go.
Anyone have any idea's? I'm not running on the default secure port 443. Would it be their firewall?
Cheers,
Kev
35
Web Server - Ask For Help / Random redirection for browse ID fields
« on: October 27, 2010, 02:35:17 PM »
Hi Bruce,
I noticed you sneaked a new build up.
Can you elaborate on what Random redirection for browse ID fields is?
Were any of the following addressed in the current build?
- Do alerts work with popup change forms?
- Any way to refresh a lookup browse after inserting a new record? Tested on your example and same effect as I am seeing in my app
- Is there any way to update a browse on a form after closing a memory form popup? The popup is called from a button on the browse via Javascript which makes all the refresh options readonly. This is not a lookup, just a way for a user to enter some additional information which I display in the browse after closing the popup.
Cheers,
Kev
I noticed you sneaked a new build up.
Can you elaborate on what Random redirection for browse ID fields is?
Were any of the following addressed in the current build?
- Do alerts work with popup change forms?
- Any way to refresh a lookup browse after inserting a new record? Tested on your example and same effect as I am seeing in my app
- Is there any way to update a browse on a form after closing a memory form popup? The popup is called from a button on the browse via Javascript which makes all the refresh options readonly. This is not a lookup, just a way for a user to enter some additional information which I display in the browse after closing the popup.
Cheers,
Kev
36
Web Server - Ask For Help / MSSQL2005
« on: October 14, 2010, 05:00:50 PM »
Hi All,
I'm running MSSQL2005 as the backend for my web apps.
If I open the activity monitor I can see some open transactions on some of the DB's.
The details in 3 DB's are as follows:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
FETCH API_CURSOR000000000004CA39
FETCH API_CURSOR000000000005AA7B
and the status on all is sleeping.
Occasionally a DB will jam up with a whole bunch of locks. The only way to fix is to kill the locked process's and restart the web app which inadvertently leads to some data loss for the user.
I'm not sure if any of these open transactions end up causing the lock up.
I have selected all the default options when I setup SQL2005 and the databases.
Anyone got any suggestions?
Cheers,
Kevin
I'm running MSSQL2005 as the backend for my web apps.
If I open the activity monitor I can see some open transactions on some of the DB's.
The details in 3 DB's are as follows:
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
FETCH API_CURSOR000000000004CA39
FETCH API_CURSOR000000000005AA7B
and the status on all is sleeping.
Occasionally a DB will jam up with a whole bunch of locks. The only way to fix is to kill the locked process's and restart the web app which inadvertently leads to some data loss for the user.
I'm not sure if any of these open transactions end up causing the lock up.
I have selected all the default options when I setup SQL2005 and the databases.
Anyone got any suggestions?
Cheers,
Kevin
37
Web Server - Ask For Help / Insert and overwrite mode on a form
« on: July 12, 2010, 03:35:48 PM »
Is there any way on a form to set editing fields to overwrite?
I'm finding if I am on a field and make a change (some refreshing and server side code will run) when I tab to the next field the cursor is in insert mode at the end of the field. If I tab to that field without making any changes then the value in that field is highlighted in overwrite mode. Is there any way to force overwrite all the time?
Cheers,
Kevin
I'm finding if I am on a field and make a change (some refreshing and server side code will run) when I tab to the next field the cursor is in insert mode at the end of the field. If I tab to that field without making any changes then the value in that field is highlighted in overwrite mode. Is there any way to force overwrite all the time?
Cheers,
Kevin
38
Web Server - Ask For Help / Content Type
« on: June 24, 2010, 04:57:12 PM »
Is is standard behavior in Firefox to ask the user to open an excel file?
I'm setting the Content type via the GetContentType function.
Cheers,
Kevin
I'm setting the Content type via the GetContentType function.
Cheers,
Kevin
39
Web Server - Ask For Help / RI Message
« on: June 22, 2010, 05:52:02 PM »
Hi All,
I just tried to delete a record from a Browse that could not be deleted due to RI constraint and the error popped up on the server rather than in the browser. Is there a setting for this? On the form Validation I have everything ticked and Auto Dict Validation set to Default. Of course when you delete you don't see the form.
MSSQL2005, NTW5 PR21
Cheers,
Kevin
I just tried to delete a record from a Browse that could not be deleted due to RI constraint and the error popped up on the server rather than in the browser. Is there a setting for this? On the form Validation I have everything ticked and Auto Dict Validation set to Default. Of course when you delete you don't see the form.
MSSQL2005, NTW5 PR21
Cheers,
Kevin
40
Web Server - Ask For Help / Skip Field
« on: May 31, 2010, 04:08:48 AM »
Is there anything like the "skip" attribute in windows when tabbing through forms on the web?
Cheers,
Kevin
Cheers,
Kevin
41
Web Server - Ask For Help / SelectField
« on: May 29, 2010, 04:35:13 AM »
Hi All,
I can use selectfield (sets the field the cursor is on when a page loads) on a form but I can't seem to get it to work when I am trying to select a field on a browse embedded in a form. This is what I tried.
p_web.SetValue('SelectField',clip(loc:formname) & '.' & p_web.crc32('POC:ChartCode' & p_web.GSV('POC:ID')))
Cheers,
Kev
I can use selectfield (sets the field the cursor is on when a page loads) on a form but I can't seem to get it to work when I am trying to select a field on a browse embedded in a form. This is what I tried.
p_web.SetValue('SelectField',clip(loc:formname) & '.' & p_web.crc32('POC:ChartCode' & p_web.GSV('POC:ID')))
Cheers,
Kev
42
Web Server - Ask For Help / Server Side Code
« on: May 27, 2010, 06:11:27 PM »
Hi All,
Is there a way to pass what has been typed into a field to a session variable without tabbing off a field?
Here is my dilemma:
I have a vendor code field. I have implemented function keys to call the lookup window rather than a button. The problem is if I type PLU and then press F8 my server side code has not run and when I get to the lookup screen it is waiting at the top of the list. If I enter PLU tab and then shift tab back and press F8 then it works - not exactly user friendly.
Any suggestions?
Cheers,
Kevin
Is there a way to pass what has been typed into a field to a session variable without tabbing off a field?
Here is my dilemma:
I have a vendor code field. I have implemented function keys to call the lookup window rather than a button. The problem is if I type PLU and then press F8 my server side code has not run and when I get to the lookup screen it is waiting at the top of the list. If I enter PLU tab and then shift tab back and press F8 then it works - not exactly user friendly.
Any suggestions?
Cheers,
Kevin
43
Web Server - Ask For Help / Security Access
« on: May 16, 2010, 08:17:41 PM »
Hi All,
I have been using the security access options on the templates. It all works fine and does not bring up a screen if the user should not have access. The only problem is that there is no warning that access is blocked. Is there any template options I have overlooked? If not where in the source code could I trap this to bring up a warning screen? I presume it would work similar to the logon window.
Cheers,
Kevin
I have been using the security access options on the templates. It all works fine and does not bring up a screen if the user should not have access. The only problem is that there is no warning that access is blocked. Is there any template options I have overlooked? If not where in the source code could I trap this to bring up a warning screen? I presume it would work similar to the logon window.
Cheers,
Kevin
44
Web Server - Ask For Help / refresh control
« on: May 16, 2010, 08:14:07 PM »
Hi All,
I have a browse embedded in a form. I have tagging on the browse records. I have added a field to the form called TotalSelectedRecords and made this read only.
I would like to update/refresh this field when the user tags a record.
Is this possible?
Cheers,
Kevin
I have a browse embedded in a form. I have tagging on the browse records. I have added a field to the form called TotalSelectedRecords and made this read only.
I would like to update/refresh this field when the user tags a record.
Is this possible?
Cheers,
Kevin
45
Web Server - Ask For Help / Alert with Confirm
« on: May 16, 2010, 04:26:42 PM »
Is there a current or planned way to add ok and cancel to an alert message?
I would like to throw up a warning but let the user choose to continue or cancel.
eg 'Selected records do not equal zero - continue?' OK or Cancel
Bruce maybe your new modular popup window?
Either way it would need to work like clawin code
If Message('Selected items do not Equal zero.| Do you want to continue?','Reconcile',ICON:QUESTION,BUTTON:Yes+BUTTON:No,BUTTON:No) = BUTTON:Yes
Cheers,
Kevin
I would like to throw up a warning but let the user choose to continue or cancel.
eg 'Selected records do not equal zero - continue?' OK or Cancel
Bruce maybe your new modular popup window?
Either way it would need to work like clawin code
If Message('Selected items do not Equal zero.| Do you want to continue?','Reconcile',ICON:QUESTION,BUTTON:Yes+BUTTON:No,BUTTON:No) = BUTTON:Yes
Cheers,
Kevin