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 / Suggestion for prime on form
« on: June 19, 2008, 04:43:10 PM »
I was using the PRIME field values for insert on a netwebform.
This generates the following code
ProSub:rowguid = getNewId()
p_web.SetSessionValue('ProSub:rowguid', getNewId())
But ... the problem is that my function GetNewId() returns a unique value everytime it is called. Therefore the 2nd call when using p_web.ssv() returns a different value than the 1st call.
I suggest that the template should generate code:
PRE:field = <user-entered-value>
p_web.SetSessionValue('PRE:field ', PRE:field )
This would prevent the double call of a function.
Alan
This generates the following code
ProSub:rowguid = getNewId()
p_web.SetSessionValue('ProSub:rowguid', getNewId())
But ... the problem is that my function GetNewId() returns a unique value everytime it is called. Therefore the 2nd call when using p_web.ssv() returns a different value than the 1st call.
I suggest that the template should generate code:
PRE:field = <user-entered-value>
p_web.SetSessionValue('PRE:field ', PRE:field )
This would prevent the double call of a function.
Alan
32
Web Server - Ask For Help / Remember TAB after SAVE record?
« on: June 19, 2008, 01:12:26 PM »
I have a memory FORM with multiple tabs.
The 1st tab has form fields.
The 2nd through 6th have filters and browses on each.
If I'm on tab 3, and edit a row on the browse, then when I press SAVE, it takes me back to tab 1.
In this case, my customers may be changing MANY rows on the browse, and they're getting really irritated with having to reselect the 3rd tab every time they save a record.
Is there anything I can do to force it to return to the current TAB?
Alan
The 1st tab has form fields.
The 2nd through 6th have filters and browses on each.
If I'm on tab 3, and edit a row on the browse, then when I press SAVE, it takes me back to tab 1.
In this case, my customers may be changing MANY rows on the browse, and they're getting really irritated with having to reselect the 3rd tab every time they save a record.
Is there anything I can do to force it to return to the current TAB?
Alan
33
Web Server - Ask For Help / Re: Retain row after changing record?
« on: June 19, 2008, 01:08:46 PM »
I'm using MSSQL 2005 standard edition sp2.
I originally thought it was only when changing records on a CHILD browse.
But in this case, it was a standalone browse.
This is definitely not working for me.
Alan
I originally thought it was only when changing records on a CHILD browse.
But in this case, it was a standalone browse.
This is definitely not working for me.
Alan
34
Web Server - Ask For Help / Re: Display extra fields in drop list?
« on: June 19, 2008, 12:59:27 PM »
Thanks so much!!!
I'd tried before, but I guess I'd probably forgotten to add the extras as HOT fields.
I'd tried before, but I guess I'd probably forgotten to add the extras as HOT fields.
35
Web Server - Ask For Help / Display extra fields in drop list?
« on: June 18, 2008, 07:37:30 PM »
How do I display extra fields in drop list.
This works fine for a single display field:
Display = EMP:Name
Value EMP:ID
But how do I do the following:
Display = EMP:FirstName & ' ' & EMP:Lastname
Value EMP:ID
i.e. I want a calculated field to show in the dropdownlist.
Is this possible?
Alan
This works fine for a single display field:
Display = EMP:Name
Value EMP:ID
But how do I do the following:
Display = EMP:FirstName & ' ' & EMP:Lastname
Value EMP:ID
i.e. I want a calculated field to show in the dropdownlist.
Is this possible?
Alan
36
Web Server - Ask For Help / Retain row after changing record?
« on: June 18, 2008, 06:35:24 PM »
Is it possible to remember the current ROW on the browse, so that after the user has pressed SAVE on the form, it comes back to the current row.
I have NT4.30, running on a SQL2005 db, with Page-Loaded browse.
It works as long as I change a record on the 1st page.
But ... if I switch to the 2nd page, and change and save a record, then the browse seems to always RESET to the very 1st row.
If I have 3-4 items to change on e.g. the 4th page, then this is VERY SLOW.
Press NEXT 3 times (to get to page 4).
Press CHANGE, to edit the record, then SAVE.
Browse resets to TOP.
Press NEXT 3 times to get back to page 4 ...(etc)...
Alan
I have NT4.30, running on a SQL2005 db, with Page-Loaded browse.
It works as long as I change a record on the 1st page.
But ... if I switch to the 2nd page, and change and save a record, then the browse seems to always RESET to the very 1st row.
If I have 3-4 items to change on e.g. the 4th page, then this is VERY SLOW.
Press NEXT 3 times (to get to page 4).
Press CHANGE, to edit the record, then SAVE.
Browse resets to TOP.
Press NEXT 3 times to get back to page 4 ...(etc)...
Alan
37
Web Server - Ask For Help / Re: Filters and locaters using MSSQL
« on: April 29, 2008, 01:00:20 PM »
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=288.0;topicseen
Try the above link. It is a slightly different problem, but the solution is the same, in that you need to embed some code in the _SendFile method of the WebHandler procedure.
I have a static link with a name of "datasmart_importsales_sample.csv" which I want to ensure has the option of SAVE AS.
The following is code in my _SendFIle method.
case SELF.GetPageName(Lower(p_FileName))
of 'datasmart_importsales_sample.csv'
p_filename = filepathonly(p_filename) & filenamenoextension(p_filename)
end
Use the idea and adapt for your needs.
Regards,
Alan
PS Also try a search on _SENDFILE in this forum for other threads on this topic.
Try the above link. It is a slightly different problem, but the solution is the same, in that you need to embed some code in the _SendFile method of the WebHandler procedure.
I have a static link with a name of "datasmart_importsales_sample.csv" which I want to ensure has the option of SAVE AS.
The following is code in my _SendFIle method.
case SELF.GetPageName(Lower(p_FileName))
of 'datasmart_importsales_sample.csv'
p_filename = filepathonly(p_filename) & filenamenoextension(p_filename)
end
Use the idea and adapt for your needs.
Regards,
Alan
PS Also try a search on _SENDFILE in this forum for other threads on this topic.
38
Web Server - Ask For Help / Re: SQL Server Login Window
« on: March 03, 2008, 11:44:00 AM »
I do something similar to you.
in WebHandler procedure, ProcessLink method, I first do a PROP:Disconnect, then I look up the ownername from the session queue, and open a table in the database.
myTableName{prop:disconnect}
GLO:DbOwner = ThisNetWorker.gsv('glo:dbowner')
myTableName{prop:logonscreen} = false
open(mytablename)
It seems to work ok.
Alan
in WebHandler procedure, ProcessLink method, I first do a PROP:Disconnect, then I look up the ownername from the session queue, and open a table in the database.
myTableName{prop:disconnect}
GLO:DbOwner = ThisNetWorker.gsv('glo:dbowner')
myTableName{prop:logonscreen} = false
open(mytablename)
It seems to work ok.
Alan
39
Web Server - Ask For Help / Re: Multi lines in NetWebBrowse
« on: February 20, 2008, 12:29:21 PM »
There is an option [ ]Allow XHTML in column.
This will stop the "cleaning" from happening.
You will need valid XHTML which means everything must have a closing tag.
I believe if you use <br /> with trailing slash it should work.
i.e. l:address = clip(line1) & <br /> & clip(line2) & <br /> & clip(line3)
This will stop the "cleaning" from happening.
You will need valid XHTML which means everything must have a closing tag.
I believe if you use <br /> with trailing slash it should work.
i.e. l:address = clip(line1) & <br /> & clip(line2) & <br /> & clip(line3)
40
Web Server - Ask For Help / Re: How do I get out of Frames
« on: January 31, 2008, 12:15:34 PM »
I don't know all the settings, but if you set TARGET to "_blank", then it will open the URL in a new window without being inside your frame.
Alan
Alan
41
E-Mail - Ask For Help / How do I FWD a copy of email received?
« on: January 09, 2008, 07:27:52 PM »
I currently use nettalk to clear a POP3 account (and then process attachments).
I need to continue doing this, but also FWD a copy of all email to another email address.
How do I do this?
Any hints?
I need to continue doing this, but also FWD a copy of all email to another email address.
How do I do this?
Any hints?
42
Web Server - Ask For Help / Re: Anyone hvaing issues using CHT classes within NetTalk Web Procs?
« on: January 07, 2008, 12:39:53 PM »
I use a small utility template of mine described in my *old* http://www.clarionmag.com/cmag/v2/v2n8busobjects.html clarion mag article.
You don't need to use the template.
1. switch to module view, and add the line
INCLUDE('hndutil.inc'),ONCE
2. select your procedure (eg MailboxesFormControl) and in the local data embed put
HUtil HNDUtil
Compile and you're away.
To test I added a field on the general tab.
use equate = hutil_test
Type = display
text = 'Path='&hutil.slashpath( path())
Cheers,
Alan
You don't need to use the template.
1. switch to module view, and add the line
INCLUDE('hndutil.inc'),ONCE
2. select your procedure (eg MailboxesFormControl) and in the local data embed put
HUtil HNDUtil
Compile and you're away.
To test I added a field on the general tab.
use equate = hutil_test
Type = display
text = 'Path='&hutil.slashpath( path())
Cheers,
Alan
43
Web Server - Ask For Help / Re: Anyone hvaing issues using CHT classes within NetTalk Web Procs?
« on: January 06, 2008, 12:01:12 PM »
I've got no issues using CHT classes in my app.
I suggest you take one of the example web apps and add CHT to this, just to check it works ok.
Then (assuming it works) find out what's different in your app.
Alan
I suggest you take one of the example web apps and add CHT to this, just to check it works ok.
Then (assuming it works) find out what's different in your app.
Alan
44
Web Server - Share Knowledge / 4.30 preview 4 bugs - identity field and readonly checkbox
« on: December 03, 2007, 03:31:58 PM »
Just a short post in case anyone is also struggling with a couple of bugs in 4.30 preview 4.
1. If you display an identity field on your form, and the picture displays with a "," for thousands separator, then you cannot save the form.
The URL is malformed and includes the "," which makes the database believe you're trying to change the identity field.
e.g. if PRE:IDFIELD = 9,999 then this shows as part of the URL &PRE_IDFIELD=9%2c999
2. If you have a checkbox, and the checkbox has a READONLY condition, then it is impossible to turn the checkbox off.
Regards,
Alan
1. If you display an identity field on your form, and the picture displays with a "," for thousands separator, then you cannot save the form.
The URL is malformed and includes the "," which makes the database believe you're trying to change the identity field.
e.g. if PRE:IDFIELD = 9,999 then this shows as part of the URL &PRE_IDFIELD=9%2c999
2. If you have a checkbox, and the checkbox has a READONLY condition, then it is impossible to turn the checkbox off.
Regards,
Alan
45
Web Server - Ask For Help / Re: Blogging with Nettalk?
« on: November 26, 2007, 12:06:50 PM »
Gregg,
Look at http://www.pimpmyclarion.com/.
He talks about a tool called "jaymoe", which is a blog/forum etc tool.
Alan
Look at http://www.pimpmyclarion.com/.
He talks about a tool called "jaymoe", which is a blog/forum etc tool.
Alan