Re: [DUG]: Interbase

2000-12-18 Thread backup
Sorry I can't let this pass. Nevan wrote... So unfortunately does MSDE - and don't dump that small footprint dogma on me because at 64Mb ram at $75 and 15Gb disk at $200 it is irrelevant. Does it also, like it OS brethren, spend all it's idle time looking for available resources to hog?

Re: [DUG]: Interbase

2000-12-18 Thread Sandeep
Hi The following article describes how to lock the record. http://www.ibphoenix.com/doc0844.html I tried that (I execute an update query on BeforeEdit event) but it doesn't seem to work. Sandeep. --- New Zealand

Re: [DUG]: ComboBox List Index

2000-12-18 Thread Mike Osborne
Hi all With a TComboBox Style set at csDropDownList you can do: DocEntryDestCB.ItemIndex := DocEntryDestCB.Items.IndexOf(ImpDestCode); With the Style set at csDropDown, you can't. Is this in: * it doesn't compile * it crashes * it returns wrong result I am interested as I have

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Willie Three things 1/ My Name is Neven 2/ In my limited circle of developer friends I know of 2 (probably 3 actually - none of which are called Nevan or Nic) that have worked with both and they all prefer IB after their experiences. This is totally heresay, when you have some knowledge

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Sandeep Yes you could use pessimistic locking however I wouldn't suggest it. especially not in the application. As i have said before I you'd be better off accepting that SQL servers are not ISAM's and embrace the changes it will require, not fight them "To the man with a hammer all the world

[DUG]: Screen.Forms

2000-12-18 Thread Stacey Verner
I want to find out the number of forms that are visible in my application, however Screen.Forms doesn't tell me about the common dialogs, such as the open dialog. Is there any way i can find out what dialogs are currently visible? Stacey Stacey Verner Ph: +64-9-4154790Software Developer

Re: [DUG]: Interbase

2000-12-18 Thread Corey Murtagh
Neven MacEwan wrote: snip 2/ In my limited circle of developer friends I know of 2 (probably 3 actually - none of which are called Nevan or Nic) that have worked with both and they all prefer IB after their experiences. This is totally heresay, when you have some knowledge yourself

Re: [DUG]: Interbase

2000-12-18 Thread Nic Wise
1/ My Name is Neven Hi Neven! 2/ In my limited circle of developer friends I know of 2 (probably 3 actually - none of which are called Nevan or Nic) that have worked with both and they all prefer IB after their experiences. This is totally heresay, when you have some knowledge

Re: [DUG]: Interbase

2000-12-18 Thread Nic Wise
As i have said before I you'd be better off accepting that SQL servers are not ISAM's and embrace the changes it will require, not fight them Gotta agree here - I've only ever used explicit locking once - in a paradox app, where I had to lock the record or another paradox app would clobber

RE: [DUG]: Interbase

2000-12-18 Thread Myles Penlington
"you'll never lose your job by choosing Microsoft". (Only your data - we have had about 6 MS SQL7 DB corruptions since starting using MS SQL7 last year ... Thankfully they were only development DB's. ) A vi vrs Emacs or Mac vrs PC war, anyone!??! How about a OODB vs SQLDB instead?

Re: [DUG]: Interbase

2000-12-18 Thread Nic Wise
How about a OODB vs SQLDB instead? OK, but is anyone actually using an OODB? I'm using a OR mapping tools, which is close (I get to use OQL) but thats about it. N --- New Zealand Delphi Users group - Delphi List -

RE: [DUG]: Interbase

2000-12-18 Thread Myles Penlington
How about a OODB vs SQLDB instead? OK, but is anyone actually using an OODB? I'm using a OR mapping tools, which is close (I get to use OQL) but thats about it. Good point - Now that I think about it, I would be surprised if anybody on this list is using one ... Although I would be

[DUG]: Copying Files

2000-12-18 Thread Colin Dillicar
Hi all, I just got around to modifying my app this morning and now have a progress bar doing what it should. Being a Borland pascal programmer since BP/2 days I chose to use Steve Peacocke's solution as follows :- 1. Use a TAnimate component to simply give feedback that the files is

RE: [DUG]: Interbase

2000-12-18 Thread Carl Reynolds
I'm enjoying this thread. :-) I'll just add that that I've been using Interbase for over half of this year (seems like forever really) and I have mixed feelings about it. I used to say "an SQL language stands or falls on the strength of it's optimiser". But since Interbase's optimiser is a

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl I'm enjoying this thread. :-) It was getting a bit quiet there for a while I used to say "an SQL language stands or falls on the strength of it's optimiser". But since Interbase's optimiser is a steaming heap of dung, but I'm confused..what part of IB did you enjoy? :-) I do think

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Cory If you are any way suggesting I'm an braindead M$ sycophant then you Whoa, chill Neven. He was (as he pointed out) stating his opinion of MSSQL, NOT slamming you. Calm down and read the message again. You'll note I did say IF Neven

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Myles (Only your data - we have had about 6 MS SQL7 DB corruptions since starting using MS SQL7 last year ... Thankfully they were only development DB's. Maybe i'm blessed but I've only ever had one (and that was because I hadn't loaded sp1) Neven

[DUG]: Combo Box List Index

2000-12-18 Thread Mark Howard
I posted this yesterday pm but it I feel that I dropped out of the email system after that because I received no messages until about 11am today - and there was sign of this from DUG and no catch-up volume. So here it is again. Hi all With a TComboBox Style set at csDropDownList you can

RE: [DUG]: Interbase

2000-12-18 Thread Carl Reynolds
From: Neven MacEwan [mailto:[EMAIL PROTECTED]] I used to say "an SQL language stands or falls on the strength of it's optimiser". But since Interbase's optimiser is a steaming heap of dung, but I'm confused..what part of IB did you enjoy? :-) I never discuss the good points of things,

Re: [DUG]: Interbase

2000-12-18 Thread David Brennan
Myles (Only your data - we have had about 6 MS SQL7 DB corruptions since starting using MS SQL7 last year ... Thankfully they were only development DB's. Out of curiosity were you able to repair the databases? Or did you not try very hard because they were only development databases?

Re: [DUG]: Combo Box List Index

2000-12-18 Thread Neven MacEwan
Mark instead of DocEntryDestCB.ItemIndex := DocEntryDestCB.Items.IndexOf(ImpDestCode); for a csDropDown you can DocEntryDestCB.Text := ImpDestCode; a csDropDown doesn't enforce existance of the item - Original Message - From: Mark Howard [EMAIL PROTECTED] To: Multiple recipients of

RE: [DUG]: Interbase

2000-12-18 Thread Myles Penlington
Nope - could not repair - we consigned them to the scrap bin. (Only your data - we have had about 6 MS SQL7 DB corruptions since starting using MS SQL7 last year ... Thankfully they were only development DB's. Out of curiosity were you able to repair the databases? Or did you

Re: [DUG]: Combo Box List Index

2000-12-18 Thread Mark Howard
Yeah. Sorry, wasn't clear about this. I want to be able to handle an exception if the ImpDestCode is not in the list. Mark - Original Message - From: "Neven MacEwan" [EMAIL PROTECTED] To: "Multiple recipients of list delphi" [EMAIL PROTECTED] Sent: Monday, December 18, 2000 3:25 PM

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl isn't postgreSQL *nix only? see http://www.postgresql.org/docs/admin/supported-platforms.htm Neven --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

RE: [DUG]: Interbase

2000-12-18 Thread Carl Reynolds
isn't postgreSQL *nix only? see http://www.postgresql.org/docs/admin/supported-platforms.htm Whew, that was a long-winded "yes". :-) Cheers, Carl --- New Zealand Delphi Users group - Delphi List - [EMAIL

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl Read the bottom - Original Message - From: Carl Reynolds [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, 19 December 2000 15:29 Subject: RE: [DUG]: Interbase isn't postgreSQL *nix only? see

Re: [DUG]: Interbase

2000-12-18 Thread Phil Scadden
Interesting thread. Has Interbase got an ODBC driver yet? For many applications, the lack of one is probably a positive advantage but I need access via the likes of Arcview, excel etc and no ODBC driver is a distinct problem. -- Phil

RE: [DUG]: Interbase

2000-12-18 Thread Carl Reynolds
http://www.interbase2000.org/tools.htm#odbc Cheers, Carl From: Phil Scadden [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 December 2000 1:16 PM To: Multiple recipients of list delphi Subject: Re: [DUG]: Interbase Interesting thread. Has Interbase got an ODBC driver yet? For many applications,

Re: [DUG]: Combo Box List Index

2000-12-18 Thread Deepak Shenoy
Yeah. Sorry, wasn't clear about this. I want to be able to handle an exception if the ImpDestCode is not in the list. if DocEntryDestCB.Items.IndexOf(ImpDestCode) = -1 then raise Exception.Create('Item not in list') else DocEntryDestCB.Text := ImpDestCode; Deepak Shenoy Agni