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.


Messages - John Hickey

Pages: [1] 2 3
1
Test attachment.  This should be fixed now.

[attachment deleted by admin]

2
Web Server - Ask For Help / Re: MSSQL Deadlocks
« on: November 05, 2009, 02:33:05 PM »
Interestingly, I found this earlier this week:

http://blogs.msdn.com/psssql/archive/2009/10/26/reduce-locking-and-other-needs-when-updating-data-better-performance.aspx

==================================

The following pattern typically stems from an old practice used in SQL 4.x and 6.x days, before IDENTITY was introduced.

    begin tran
    declare @iVal int

    select @iVal = iVal from CounterTable (HOLDLOCK) where CounterName = 'CaseNumber'

    update CounterTable
    set iVal = @iVal + 1
    where CounterName = 'CaseNumber'

    commit tran

    return @iVal

This can be a dangerous construct.  Assume that the query is cancelled (attention) right after the select.  SQL Server treats this as a batch termination and does not execute other statements.   The application now holds a lock under the open transaction and without proper handling it leads to blocking.

One Statement Fix

    declare @iVal int

    update CounterTable
    set @iVal = iVal = iVal + 1
    where CounterName = 'CaseNumber'

    return @iVal

SQL Server allows you to update a value and return the updated value into a variable.   A single update statement can do all the work.   If the query is cancelled by the application the update is atomic and will complete or rollback but the application has much better control over the lock and transaction scope.

Use this to help reduce blocking and possible deadlock issues.   Since the lookup only takes place one time it can also increase performance of you application.

3
News And Views / New anti-spam mod added to forum
« on: May 31, 2009, 06:03:47 PM »
I just added a new anti-spam mod to the board, it shouldn't affect anyone but let me know if there are any unusual happening!

--John

4
Web Server - Ask For Help / Re: Multi lines in NetWebBrowse
« on: February 19, 2008, 10:13:06 PM »
Yes, I placed the code in an embed.  I created a STRING called l:Address, then filled it like so at the "Set Queue Record" embed:

! Start of "Set Queue Record"
      l:Address = 'Account: ' & CLIP(CUS:CustID) & ' Code: ' & CLIP(CUS:Code)
      l:Address = CLIP(l:Address) & '<BR>' & clip(CUS:FNam) & ' ' & clip(CUS:LNam)
      l:Address = CLIP(l:Address) & '<BR>' & clip(CUS:Address1)
 ...etc. ...


5
Web Server - Ask For Help / Re: Cell phone browsers
« on: February 15, 2008, 04:22:10 PM »
I have not solved this yet, I haven't had time to really dig into it.  I think it has something to do with Java (but then, what doesn't?).

6
Your Views and Comments / Re: Creating Profile?
« on: September 29, 2007, 07:09:59 AM »
and thanks for uploading and sharing!

7
Your Views and Comments / Re: Creating Profile?
« on: September 27, 2007, 08:47:43 PM »
oops, not anymore  ;)

8
Your Views and Comments / Re: Creating Profile?
« on: September 26, 2007, 03:02:05 PM »
The system is supposed to approve everyone automatically so it can create a profile, but it is not.  So, I have to go in and approve everyone manually.  This can take some time since I didn't realize it wasn't approving everyone and there are quite a few accounts to approve.  I'll work on it tonight while watching Bionic Woman!

9
Your Views and Comments / Re: Wiki?
« on: August 13, 2007, 05:24:00 PM »
Wiki is up!

I don't know a lot about Wikis, but I added a few pages to get it started.  Feel free to start building it and changing it however you might like!

11
Your Views and Comments / Re: Powered by NetTalk
« on: July 27, 2007, 09:00:27 AM »
Already available!  You can post in the Forum under the appropriate heading (Webserver - Links To Sites), or there is a "Links" menu item on the left you can click on to submit your link.

12
Web Server - Ask For Help / Re: Template error in 4.27
« on: July 09, 2007, 10:45:00 AM »
Does 4.28 resolve the problem?

13
Web Server - Ask For Help / Re: WebServer - deleting a related record
« on: June 28, 2007, 12:48:21 PM »
You could try "hooking" the message box so that it goes to your own WebPage procedure that would display the message (or log it or whatever).  If you have Capesoft's Message Box, you could adapt their Messagebox procedure, or it's not too hard to write your own.

PROP:MessageHook:  "A property of the SYSTEM built-in variable that sets the override procedure for the MESSAGE internal Clarion procedure. Equivalent to {PROP:LibHook,6}. Assign the ADDRESS of the overriding procedure, and the runtime library will call the overriding procedure instead of the MESSAGE procedure. Assign zero and the runtime library will once again call its internal procedure. The overriding procedure's prototype must be exactly the same as the MESSAGE procedure. (WRITE-ONLY)"

14
Web Server - Ask For Help / Re: Cell phone browsers
« on: June 26, 2007, 08:09:46 AM »
I'm using Windows Mobile 5, the IE browser.  The login button doesn't show up at all, so there is nothing to submit.   

15
Web Server - Ask For Help / Cell phone browsers
« on: June 25, 2007, 02:33:43 PM »
Has anyone tried accessing a web server app using a cell phone web browser?  I can't get past the login screen, the login button does not function.  Is there a work-around for this problem?

Pages: [1] 2 3