RE: [DUG]: Convert Firebird to MSSQL

2003-11-09 Thread Paul Ritchie
Title: Message I'm assuming it's a URL of a publicly accessible document?   Or maybe is it a secret?   ;o)   cheers, Paul. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of C FraserSent: Monday, 10 November 2003 2:06 p.m.To: Multiple recipients

RE: [DUG]: Moving to MSDE

2003-10-06 Thread Paul Ritchie
> Sure just dont use any 2000 functions There is an MSDE 2000 therefore, assuming you are deploying that, you are free to use such functions. cheers, Paul. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTE

[DUG]: Software development job.

2003-07-01 Thread Paul Ritchie
PayGlobal is looking for an experienced software developer with good OO design skills. "There is now an excellent opportunity for a dynamic and innovative Software Engineer to join our head office in Christchurch, New Zealand. Reporting to the Development Manager, you will be required to develop D

RE: [DUG]: Interbase to SQL Server

2002-09-22 Thread Paul Ritchie
If there's an ODBC (or OLE DB) driver for Interbase you could try using Data Transformation Services (DTS) in SQL Server. /p --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

RE: [DUG]: mySQL

2002-08-11 Thread Paul Ritchie
David Brennan wrote: > And before you begin thinking that you couldn't be a > Microsoft Partner, we are, it hasn't cost us > anything to join, we don't have any Microsoft Certified > developers working for us etc. David, on the MS site it says: "Microsoft Certified Partners must have at least 2 M

RE: [DUG]: Windows Domains

2001-11-12 Thread Paul Ritchie
Maybe the NetServerEnum Windows API function is what youre after? >From MSDN: The NetServerEnum function lists all servers of the specified type that are visible in a domain. For example, an application can call NetServerEnum to list all domain controllers only or all SQL servers only. http://ms

RE: [DUG]: Best practice - To except or not

2001-11-01 Thread Paul Ritchie
At the risk of not appearing to not enter into the spirit of the discussion ;) aren't you talking about a database application? Therefore the number of clock cycles you can save by coding a certain way over another is more than swamped by relatively slow database operations. Therefore I'd err on

RE: [DUG]: automated HTTP file uploads

2001-10-31 Thread Paul Ritchie
John, > can you possibly tell me how (after getting connected) to change to an > ftp://xxx.xx.xxx address? I haven't used the TIdFTP component before, but maybe you need to call TIdFTP.Disconnect before changing the address, then Connect with the new address? Paul.

RE: [DUG]: automated HTTP file uploads

2001-10-22 Thread Paul Ritchie
> Thanks, I had a quick peek, but can't find any upload-related > logic. How about the component's Post method which is called in the btnGoClick method? >From the help: ++ TIdHTTP.Post - Send HTTP data to a web server or CGI program. procedure Post(URL: string; const Source: TStrin

RE: [DUG]: automated HTTP file uploads

2001-10-22 Thread Paul Ritchie
Have you checked out the Indy components? If not, there is an example (in Delphi 6) in Delphi\Demos\Indy\HTTPClient using the Indy TIdHTTP component which might be relevant. Paul. --- New Zealand Delphi Users group - D

RE: [DUG]: ADO Datasets

2001-09-11 Thread Paul Ritchie
Bob, > Two of our students have experienced problems with ADO > datasets connected to Access tables on their home P.C.s, > but not here on the college computers. > The data and source code are identical in both locations. You might want to check the ADO version is the same on both machines. (On

RE: [DUG]: Delphi to Interbase access options

2001-08-01 Thread Paul Ritchie
"relies" on the other. Paul Ritchie Radio Computing Services --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAI

RE: [DUG]: SQL Update question

2001-07-25 Thread Paul Ritchie
) Yuk. (I'd still seriously question the need to denormalise though.) Paul Ritchie Radio Computing Services. > -Original Message- > From: Steve Galyer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 26, 2001 9:30 AM > To: Multiple recipients of list delphi > Subjec

RE: [DUG]: SQL Update question

2001-07-24 Thread Paul Ritchie
h the addition of this field. ;-) Can you maybe achieve what you want to by calculating the total when you actually need it? Paul Ritchie Radio Computing Services --- New Zealand Delphi Users group - Delphi List - [EMAIL PROT

RE: [DUG]: [DUG-DB]: SQL

2001-06-25 Thread Paul Ritchie
oc and testing code in query analyzer though, as it worked for me in QA. Paul Ritchie Radio Computing Services. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.de

RE: [DUG]: [DUG-DB]: SQL

2001-06-24 Thread Paul Ritchie
You could use a temporary table? (Quotes corrected) select @sql='select au_lname into #temp from authors where au_id=''172-32-1176''' exec (@sql) select @result=au_lName from #temp Paul Ritchie Radio Computing Services. > -Original Message- > From

RE: [DUG]: [DUG-DB]: SQL

2001-06-24 Thread Paul Ritchie
You could use a temporary table? select @sql='select au_lname into #temp from authors where au_id='172-32-1176' exec (@sql) select @result=au_lName from #temp Paul Ritchie Radio Computing Services. > -Original Message- > From: Jim Zheng [mailto:[EMAIL PROTECTED]]

RE: [DUG]: OFFTOPIC PC Tools

2001-06-17 Thread Paul Ritchie
Neven, I use TreeSize Pro and find it quite handy. http://www.jam-software.com/treesize.html Don't know about quick though, as it has to traverse all files and directories on the drive. Paul Ritchie Radio Computing Services > -Original Message- > From: Neven MacEwan [ma

RE: [DUG]: ADO components and SQL 2K

2001-06-12 Thread Paul Ritchie
MSDN says 0x80040E37 is "The specified table does not exist". http://support.microsoft.com/support/kb/articles/Q168/3/54.asp Paul Ritchie Radio Computing Services Ltd. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Ju

RE: [DUG]: Tuning SQL

2001-06-10 Thread Paul Ritchie
you can delpoy an MSDE database for free. Doesn't the application need to have been written with an MS development tool, or do you just need to 'own' Office developer or Visual Studio? (We mainly use Visual C++.) Paul Rit

RE: [DUG]: OK I've heard enough

2001-05-09 Thread Paul Ritchie
where applicable, and update CDs arrive on monthly as new versions become available. Now I'm not saying Delphi isn't good - it's fantastic. But before I started here I had no idea that this MSDN resource existed, much less of it's comprehensive nature.

RE: [DUG]: Who has this file open?

2001-05-02 Thread Paul Ritchie
NetFileEnum would appear to enumerate file users, and the MSDN indicates that it should work on a remote server using by passing that server's UNC name. http://www.msdn.microsoft.com/library/psdk/network/ntlmapi2_5dm5.htm Paul Ritchie Radio Computing Services. > -Original

RE: [DUG]: [Q] Ideas for DB Issue?

2001-03-26 Thread Paul Ritchie
JOIN Table t2 ON t2.ID=t1.ID+1 JOIN Table t3 ON t3.ID=t1.ID+2 WHERE t1.ID % 3 = 1 (untested) There might be issues if your IDs are not consecutive, but otherwise something like that should work. Paul Ritchie Radio Computing Services. > -Original Message- > From: Don

RE: [DUG]: FileListView Control

2001-03-18 Thread Paul Ritchie
The Delphi\Demos\Virtual ListView project might help. FileSearch, FindFirst & FindNext functions are useful to fill controls manually. And depending on whether you need a Listview, there is also TFileListBox and other related stuff in the Filectrl unit. HTH Paul Ritchie Radio Compu

RE: [DUG]: SQL question

2001-03-14 Thread Paul Ritchie
(c1) will return a count of all rows where c1 IS NOT NULL. But that's SQL Server - I have no idea about Interbase. Paul Ritchie Radio Computing Services. > -Original Message- > From: Neven MacEwan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 14 March 2001 11:39 a.m.

RE: [DUG]: Tabs

2001-02-07 Thread Paul Ritchie
I think Delphi translates Tabs to spaces in the source code whereas Visual Studio saves the Tabs. Therefore VS can change what the Tab is represented by, but Delphi can't. Maybe there's an editor setting that changes this? Pa

RE: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Paul Ritchie
> > Can you point me to a link that confirms that? I found a newsgroup thread on Deja on this issue: ++ > This makes me think the @@identity variable is extremely unreliable > when used in the middle tier. If you return/use the value from the same batch, you don't have a problem w

RE: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Paul Ritchie
n so connection > pooling can stuff it up (under heavy loads) > > Neven > > - Original Message - > From: Paul Ritchie <[EMAIL PROTECTED]> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > Sent: Thursday, 11 January 2001 18:04 > Subject: RE:

RE: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Paul Ritchie
Neven, Well you learn something new every day eh? > a/ They are only unique to a connection and I didn't think so. Aren't they generated from within the database? I use them in stored procedures and I don't see how they could be only unique to a connection. Can you point me to documentation

RE: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Paul Ritchie
> (Interbase is so easy in this sense because generators are > produced outside any transactions). So are SQL Server identity columns, and I've got to say they're even easier. Paul Ritchie. --- Ne

RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Paul Ritchie
umn already provides. As Nic implied, do you really need consecutive IDs? Paul Ritchie. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email

RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Paul Ritchie
k copy fails, or if the transaction is rolled back." It goes on further about accomplishing consecutive IDs in this situation, but I would be more tempted to add a seperate timestamp or datetime column containing the time the row was inserted to achiev

RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Paul Ritchie
itself. Paul Ritchie. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"

RE: [DUG]: SQL Builder

2000-12-20 Thread Paul Ritchie
> An old client of mine > ... > Should I dob them in? Inbelieveable. Paul Ritchie. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz

RE: [DUG]: Locking Records

2000-12-14 Thread Paul Ritchie
How about the BDE? I haven't looked, but I would have thought if anything was built to move from Paradox to Interbase then it would be that. Paul Ritchie. > -Original Message- > From: Sandeep [mailto:[EMAIL PROTECTED]] > Sent: Friday, 15 December 2000 13:21 > To: Mu

RE: [DUG]: Simple Email

2000-12-06 Thread Paul Ritchie
ould appear to be a mistake to use NetMasters. Paul Ritchie. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"

RE: [DUG]: embedded database.

2000-11-27 Thread Paul Ritchie
r mans' multi-tier". It is clear I am looking at this from a different perspective to you, and as such these generalisations aren't going to achieve much. I'll therefore leave you to it. Paul Ritchie. --

RE: [DUG]: embedded database.

2000-11-27 Thread Paul Ritchie
;nth tier', or stored procedure on the database. The fact that they operate on the same tables is not in itself an indication that the "wheels have fallen off" - IMHO of course. Paul Ritchie. --- New Zealand Del

RE: [DUG]: embedded database.

2000-11-26 Thread Paul Ritchie
h SELECT * INTO on one selection, and then apply remaining restrictions to that set. Depends on your situation I guess. Paul Ritchie Radio Computing Services --- New Zealand Delphi Users group - Delphi List - [EMAIL P

RE: [DUG]: embedded database.

2000-11-26 Thread Paul Ritchie
you providing for a single view or table? Paul Ritchie Radio Computing Services --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email

RE: [DUG]: embedded database.

2000-11-26 Thread Paul Ritchie
imple, with code highlighting, and tooltip-style variable inspection. I have heard the argument that all updates to a database should be done through stored procedures to easily ensure consistency (for a complex operation) and enhance security as users no longer need permissions to update tables directly

RE: [DUG]: Basic HTML/Delphi Question

2000-10-26 Thread Paul Ritchie
Next; end; end; end; Or you could replace it with the contents of an HTML file or the output from another PageProducer. Paul Ritchie Radio Computing Services (NZ) Ltd. --- New Zealand Delphi Users group -

RE: [DUG]: ForceNewPage - QuickReports3

2000-10-04 Thread Paul Ritchie
ould always do this anyway. Paul Ritchie Radio Computing Services. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAI

RE: [DUG]: [Q] Trapping keystrokes....

2000-09-28 Thread Paul Ritchie
SetWindowsHookEx. Hours of fun - guaranteed. Paul Ritchie Radio Computing Services > -Original Message- > From: Donovan J. Edye [mailto:[EMAIL PROTECTED]] > Sent: Friday, 29 September 2000 09:39 > To: Multiple recipients of list delphi > Subject: [DUG]: [Q] Trap

RE: [DUG]: ForceNewPage - QuickReports3

2000-09-25 Thread Paul Ritchie
How about just:-     Sender.ForceNewPage := true;   I assume that is the intention - to force the band that is about to print onto a new page?      Paul Ritchie Radio Computing Services (NZ) Ltd. -Original Message-From: David Brennan [mailto:[EMAIL PROTECTED]]Sent: Tuesday

RE: [DUG]: anyone done video with Delphi?

2000-09-24 Thread Paul Ritchie
suite for playing audio files, eg. fading one track while the next started playing - that sort of thing. They struck me as being a very professional set of components, with lots of relevant demo applications as well. Paul Ritchie Radio Computing Services (NZ) Ltd. > -Original Message

RE: [DUG]: Delphi and XML

2000-06-15 Thread Paul Ritchie
o: Multiple recipients of list delphi > Subject: Re: [DUG]: Delphi and XML > > > Paul > > You are trying to tempt me aren't you? > > The question is what do you truly pay going to an MS > seminar...what do you > truly PAY!!!! > > Regards > Neven > &g

RE: [DUG]: Delphi and XML

2000-06-15 Thread Paul Ritchie
At the risk of a violent flaming, can I point out that MS seminars are $99 (incl GST) for a full day including lunch? What prices are you planning this time? Paul Ritchie RCS (NZ) Ltd > -Original Message- > From: Richard Vowles [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 15

RE: [DUG]: Determining SQL Servers on a subnet...

2000-06-13 Thread Paul Ritchie
the Win32 Programmers Reference help file for details. Paul Ritchie RCS (NZ) Ltd. > -Original Message- > From: Donovan J. Edye [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 13 June 2000 17:46 > To: Multiple recipients of list delphi > Subject: [DUG]: Determining SQL Serv

RE: [DUG]: controlling mouse.

1999-10-12 Thread Paul Ritchie
> I have an app where I don't want any mouse events to be > registered after a certain point. This includes all onclick > events. Is there a way I can intercept all of these for all > controls on the form or simply just shut down the mouse for > this app. You could install a mouse hook proced

RE: [DUG]: System wide keytrap

1999-03-17 Thread Paul Ritchie
You could use SetWindowsHookEx() with the WH_KEYBOARD parameter. Unfortunately a system wide hook must be set from within a DLL. Fortunately DLLs aren't so bad in Delphi. Paul Ritchie RCS (NZ) Ltd. > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] >

RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Paul Ritchie
t writers? >if your DB is anything larger than small (say 50MB) then Crystal is useless. We are using CR6 on Access (900 MB) and MS SQL Server 6.5 databases up to 1.2Gb with no problems. Paul Ritchie