[DUG]: [Q] T-SQL and exception / error handling....

2001-05-16 Thread Donovan J. Edye
G'Day, I am using SQL Server 2K and was just wondering if someone had a more elegant way for me to handle errors. Below is a sample stored procedure showing how I am trapping errors. As you can see it is rather messy and requires a GOTO once we get an error. Is there a more elegant way to do

[DUG]: Task bar

2001-05-16 Thread Graham Mayes
:) Thanks Chrissy. I would have been disappointed not to have got that answer. Thank you Glen, you're wonderful. Graham --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

[DUG]: Sleep Command

2001-05-16 Thread Eion McIntosh (CHCH)
Hi I'm sorry if you received again but I sent this late yesterday afternoon and I haven't seen it come back to me from the group so I'm trying again. I have noticed in a passing message the 'Sleep' command which I think will be handy for a problem we have. We are currently using a counter up to

[DUG]: ADO Performance

2001-05-16 Thread Moises Lopez
hi guys.. i'm using ADO 2.5 in MS SQL Server 7.0 (MIDAS on D5 Enterprise), and i'm experiencing quite a few problems regarding performance, it just seems too slow. i've seen a few post every now and then regarding the issue.. any one has any tips? TIA Moises Lopez

[DUG]: Borlands Business is your E-Business - JB5/D6 Launch

2001-05-16 Thread Nic Wise
** for more infomation and FREE registration, please visit http://register.borland.co.nz/ebusiness ** # Enterprise Solutions Breakfast - Dr Kevin McIsaac, from Meta

Re: [DUG]: ADO Performance

2001-05-16 Thread Neven MacEwan
Moises Make sure you are using static/client datasets (work like a BDE cached dataset) HTH Neven - Original Message - From: Moises Lopez [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 17 May 2001 14:06 Subject: [DUG]: ADO Performance hi

[DUG]: IDSN Modem

2001-05-16 Thread vss
Hi all. Is there a way to detect promatically if an ISDN modem is connected ? This is my first time using an ISDN modem, so I am curious, plus I need to know for a wee app. I have to write. thanks, Jeremy Coulter Jeremy Coulter (Manager) Visual Software Solutions Christchurch, New

[DUG]: WinExec

2001-05-16 Thread Graham Mayes
I have a programme which runs others using WinExec (CreateProcess seems a little complicated for my small understanding). Upon returning from the called programme (eg Word), I want my programme to perform an action immediately and automatically, but . . it appears the window of my programme is

RE: [DUG]: WinExec

2001-05-16 Thread Luke Pascoe
== Demo code == type TForm1 = class(TForm) private Identifier: Integer; WndHandle: hWnd; Watching: Boolean; function WinExecAndGetHWnd(const fn: String): Boolean; procedure WaitUntilGone; end; implementation {$R *.DFM} var TPI: TProcessInformation; function

Re: [DUG]: WinExec

2001-05-16 Thread Edward Aretino
In D5, the ApplicationEvents component has OnActivate OnDeactivate events, as does the AppEvents component in RxLib. At 16:11 17/05/2001 +1200, you wrote: I have a programme which runs others using WinExec (CreateProcess seems a little complicated for my small understanding). Upon returning

RE: [DUG]: IDSN Modem

2001-05-16 Thread Laurence Bevan
Is there a way to detect promatically if an ISDN modem is connected ? This is my first time using an ISDN modem, so I am curious, plus I need to know for a wee app. I have to write. Jeremy, Does the connection you use the ISDN modem for show up in Dial-Up Networking? If so, then yes there is