NetTalk Central

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.


Topics - Alan Telford

Pages: [1] 2
1
I have a nettalk server (mostly REST API methods) which has worked well for +1 year.
Without having changed anything (apart from windows updates on the VM) it now intermittently doesn't work.
After a server restart, it works correctly, but then several hours later it STOPS.

I have put the capesoft example WEB9 on the same server, and this is running fine, before and after the restart.
Web9 is using local TPS, whereas my WEBAPI is using MSSQL to a network SQL server.

When it stops working the SERVER LOG repeatedly shows these two lines:
Listening on IP Port: 4550
ERROR: 10048 Unable to Listen on TCP Port 4550



Any ideas?

2
Web Server - Ask For Help / Erratic browse refreshing - can't fix
« on: February 12, 2009, 08:03:57 PM »
I've been using the latest PR31 version, and have been having some browse problems.
If I click on a col to sort, the busy indicator shows in the bottom left corner, but it NEVER stops. If I refresh the page the browse does now show the new sort order.
Similarly, if I enter a locator, it does nothing until I refresh the page, then it locates on the field.

I've tested on both IE7 and FF3.0.6.
I've ensured the scripts folder exactly match that in the \clarion6\3rdparty\libsrc\netweb\web folder.
I've cleared all the cache.

But ... I still have this problem. I am using MSSQL2005.
But I have 1 browse which is working (as a child of the parent).

Is this a problem in PR31 or is it just me?
What else can I try to fix it?

Alan

3
Web Server - Ask For Help / Order on DROP boxes issue
« on: February 12, 2009, 01:20:13 PM »
I set the order on my drop list to be "-ShCom:CompanyActive,+ShCom:CompanyName", and the generated line was
filter:id_company_maxtel_OptionView{prop:order} = 'UPPER(-ShCom:CompanyActive,+ShCom:CompanyName)'

I was able to override in the following embed point to:
filter:id_company_maxtel_OptionView{prop:order} = '-ShCom:CompanyActive,+ShCom:CompanyName'

But the templates incorrectly wrap UPPER() around all fields.

Regards,
Alan

4
Web Server - Ask For Help / Multi-Select on DROP lists
« on: February 03, 2009, 07:10:11 PM »
How do I use multi-select on DROP lists?
Is there an example provided?

I want the admin person to select which of a set of branches a user is allowed to view. I thought the "multi-select" might be just the trick.

Alan

5
I've been using browses which have unique keys which have two components.
A parentId and a ChildId (autonumber).
A browse/form on this table was working in earlier versions but I've noticed it not longer works.

e.g. one table "Uni_BranchMachine" has a single unique key "UniBM_pk_BranchMachine" with two field: uniBM:Id_Branch + uniBM:MachineNumber

I notice that when I click on the change button I get a
GET /browseuni_updatemachine?&_ParentProc=&_Clicked=1&id=uniBM:Id_Branch&Value=3&_=

but to uniquely identify the row, it needs to have
uniBM:id_Branch=51 and uniBM:MachineNumber=3

For some reason it is only using the 2nd key component (machinenumber=3), and then it tried to lookup the record by setting the 1st key component to the value of the 2nd key component.

Please can you confirm --- are unique multi-component keys supported? (it was working fine in an earlier version April last year).

Note - you can reproduce in e.g. web31 accounts by changing the BrowseLineItems to use the dual component LIN:InvKey (which is unique).

Regards,
Alan Telford

6
Web Server - Ask For Help / 4.31pre10 fails to remember current tab
« on: August 12, 2008, 02:12:17 PM »
Hi
I finally got time to download the latest preview release and give it a quick whirl.
I have a number of netwebform with multiple tabs. Tab 1+2 are memory forms with a save button. Tab 3-6 are various browses with dropdown filters etc.

I open the form, change to tab3, press change on a row, make changes, and press save.
The table is updated, and nettalk reloads the form and switches from TAB3 to TAB1.

i.e. if a user has 10 fields to change on tab3, he has to go through a rigmarole
- select tab 3
- press next/prev to locate the appropriate row in page-loaded browse
- press chg
- make changes
- wait for page to reload
- repeat from top again.

It would be wonderful if when the page reloaded (after saving a record on the browse) that it remembered what the current tab was.

The related issue (of selecting the row just changed) when the browse reloads looks *GREAT*. It's working nicely.

Alan

7
Web Server - Ask For Help / How do I block certain IPs?
« on: July 31, 2008, 04:37:00 PM »
After implementing some logging on my nettalk site yesterday, I've discovered about  300 attempts from a certain IP to login. They haven't succeeded yet.

What should I do to prevent this? Any ideas/suggestions?

Thanks,
Alan

8
Web Server - Ask For Help / Firefox 3 supported?
« on: June 19, 2008, 06:34:41 PM »
It seems as if all the AJAX functionality (e.g. column sorting, next/previous on browse) does not work in FF3.

If I use IE7, then it all works, but if I switch to FF3 it all stops working.
The odd thing is I've been using FireFox3 for 2-3 weeks (Release Candidate 1) and sometimes it has worked - but other times it doesn't work.

I get the same behaviour on 2 different computers (WinXp and Vista). I've checked "Tools | Options | Content" and I have both "Enable Java" and "Enable JavaScript" turned on.
I also get the same behaviour in the "web31 - Accounting" example app, as well as in my application.

Is anyone else having problems with FF3?

9
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

10
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

11
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

12
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

13
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?

14
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

15
Web Server - Ask For Help / 4.30 calendar bug
« on: November 25, 2007, 05:57:16 PM »
When I use the calendar in 4.30 it shows up as "Page not found".
I reproduced it by:
1. opening the "Accounts (31)" example app.
2. change the date from mm/dd/yyyy to the correct <g> dd/mm/yyyy format.
3. generate, compile, run
4. click on invoices
5. click on insert
6. click on "Calendar" button (this works)
7. select date, and window closes.
8. click on "Calendar" button again - THIS DOES NOT WORK.

On my apps, the first invocation fails, but in the example the 1st invocation seems to work. Weird!.

Alan

Pages: [1] 2