[DUG] Datebases with Delphi

2007-07-02 Thread Nick
Hi there :-) When I create a database application, usually I create a MDB file with Access (create my tables etc) and then interact with the database in Delphi using TAdoConnection and TAdoQuery. What other standalone database's can I use with Delphi2006 Ent which, I can ship to the customer

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Steve Peacocke
Take a good look at ElevateDB from http://www.elevatesoft.com/ This is a reasonably full SQL compliant database that can compile directly into your code so you don't have to ship anything except your exe program. ElevateDB is the newer version of the old and trusted DBISAM database. It can be

RE: [DUG] Databases with Delphi

2007-07-02 Thread Sean Cross
I like sqlite. Small, fast and single file. The db engine comes in a single dll. Not very good for multi-user though. I use the Aducom components, but there are others. http://www.aducom.com Regards Sean Cross IT Systems Development Manager Catalyst Risk Management PO Box 230 50 Dalton

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Edward Koryagin
If you database is small - use TClientDataSet... --- Nick [EMAIL PROTECTED] wrote: Hi there :-) When I create a database application, usually I create a MDB file with Access (create my tables etc) and then interact with the database in Delphi using TAdoConnection and TAdoQuery. What

Re: [DUG] Databases with Delphi

2007-07-02 Thread Nick
Sean, Looks pretty good. Is there some gui out there where I can quickly add/edit/delete databases without using the command line that would be great. (im searching but if you know one) Cheers Sean Cross wrote: I like sqlite. Small, fast and single file. The db engine comes in a single

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Richard Vowles
Hi Nick, The next release of Delphi includes SQL Data Store (the .NET version of JDataStore). It fits that profile perfectly, it works with Delphi 32 and Delphi .NET but via DBX4. Nick wrote: Hi there :-) When I create a database application, usually I create a MDB file with Access (create

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Steve Peacocke
And if you are just after single user databases then there's always kbmMemtable from http://www.components4programmers.com/products/kbmmemtable/ Steve On 03/07/07, Nick [EMAIL PROTECTED] wrote: Hi there :-) When I create a database application, usually I create a MDB file with Access (create

Re: [DUG] Datebases with Delphi

2007-07-02 Thread bevan
Hi Nick What other standalone databaseĀ“s can I use with Delphi2006 Ent which, I can ship to the customer without them having to install anything special. I often use Accuracer (http://www.aidaim.com), which also has a GUI for creating/editing/modifying tables and suchlike. As well as a way

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Steve Peacocke
ElevateDB comes with a tool for creating / modifying the database, SQL testing, creating triggers, stored procedures and functions, views etc. It can also create in-memory tables that interact with external tables in the same way as any other ElevateDB table. I once wrote a SQL tool for its

[DUG] straw poll: june developer days

2007-07-02 Thread Richard Vowles
I wanted to know how many people knew about the CodeGear June Developer Days that finished last week? If you knew about them, how did you find out (email/word of mouth/ide notification)? Please email me offlist or here... Thanks! Richard -- Richard Vowles, Product Evangelist Developers Inc

RE: [DUG] Databases with Delphi

2007-07-02 Thread Sean Cross
I have one at home, but not here so I am not sure what the name is. Check http://sqlite.org/ and http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Regards Sean Cross IT Systems Development Manager Catalyst Risk Management PO Box 230 50 Dalton St Napier 4140 DDI: 06-8340362 mobile: 021 270

RE: [DUG] straw poll: june developer days

2007-07-02 Thread Conor Boyd
Didn't know. Borland's email notification seems so hit and miss (and seems to completely ignore most requests that I make to update my preferences) that I've given up on trying to get notifications that way. Never pay any attention to the welcome page in the IDE either, so never notice any

Re: [DUG] straw poll: june developer days

2007-07-02 Thread Alister Christie
Yes I new about it. No I did not attend. Yes I am watching the replays (the ones on Delphi at least) - which are awful. I found about them from dn.codegear.com and/or delphifeeds.com (which I check daily). Alister Christie Computers for People Ph: 04 471 1849 Fax: 04 471 1266

Re: [DUG] straw poll: june developer days

2007-07-02 Thread Richard Vowles
Alister Christie wrote: Yes I new about it. No I did not attend. Yes I am watching the replays (the ones on Delphi at least) - which are awful. I found about them from dn.codegear.com and/or delphifeeds.com (which I check daily). What is awful about them? So far it is 3 no, 1 yes. Thanks!

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Jeremy Coulter
I too develped using the ElevateDB predecessor, that was, until I tried to use it in a client server arrangment, and THEN it all turned to POOH !!! It had SERIOUS issues with indexing, and in some cases, it would transfer around the entire table to update just ONE field ! It was at that point

[DUG] Breakpoint in initialization?

2007-07-02 Thread Phil Scadden
I have had an application stop running and stack dump shows it during unit initialization. I want to debug, but setting breakpoints in relevant code just come up green-crosses (invalid break). I double checked for alternative version on disk but nothing. It seems to be because of the

Re: [DUG] straw poll: june developer days

2007-07-02 Thread Jeremy Coulter
I got an email about them, looked at one that was a reply, and got the date wrong for another one...and then forgot about it...DOH ! Jeremy -Original Message- From: Richard Vowles [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List delphi@delphi.org.nz Date: Tue, 03 Jul

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Steve Peacocke
I never came across any problems with the Client/Server side, but that doesn't mean there weren't any. I find that they are generally very good and can fix most bugs overnight. They do have a fully functional demo available - must have Delphi running when demo is running but otherwise a full

Re: [DUG] straw poll: june developer days

2007-07-02 Thread Alister Christie
Have you tried to watch them? Maybe it's just my computer, but the screen does not seem to get updated correctly and you end up with all sorts of junk on the screen. DavidI doesn't seem quite with it for them either, but it's really hard doing stuff live I guess. I found them a bit lacking

RE: [DUG] Datebases with Delphi

2007-07-02 Thread Paul Heinz
Jeremy wrote: I too develped using the ElevateDB predecessor, that was, until I tried to use it in a client server arrangment, and THEN it all turned to POOH !!! It had SERIOUS issues with indexing, and in some cases, it would transfer around the entire table to update just ONE field !

[DUG] Annoying Colin Fraser auto responder

2007-07-02 Thread Paul Heinz
Hi guys Am I the only one continually getting these pointless auto responses from Colin Fraser when ever I email to the DUG? Can someone unsubscribe him until his sysadmins figure out how not to autorespond to mailing lists. TTFN, Paul. -Original Message- From: [EMAIL PROTECTED]

Re: [DUG] Annoying Colin Fraser auto responder

2007-07-02 Thread Richard Vowles
Paul Heinz wrote: Hi guys Am I the only one continually getting these pointless auto responses from Colin Fraser when ever I email to the DUG? Can someone unsubscribe him until his sysadmins figure out how not to autorespond to mailing lists. Everyone who posts to the list gets them I

RE: Re: [DUG] Annoying Colin Fraser auto responder

2007-07-02 Thread Gary T. Benner
[Reply] HI all, Yup, have put his subscription on vacation where I presume he is. kr Gary At 12:37 on 3/07/2007 Richard wrote To : delphi@delphi.org.nz CC : From: Richard Vowles, [EMAIL PROTECTED] Paul Heinz wrote: Hi guys Am I the only one continually getting these pointless auto

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Robert martin
Hi Firebird is a nice open source / free relational DB (from the Interbase base code). It has an embedded option that simply requires putting some files in the same dir as the app. This is for single user DBs. But with little effor you can switch to a proper client server environment.

Re: [DUG] Datebases with Delphi

2007-07-02 Thread Nick
Rob, Thanks, firebird doesn't sound to bad, and you can use native Delphi components with firebird to from what i've read. All the aps i've done so far are simply for end user use - no client/server requirements. Will research this some more :-) Thanks. Nick Robert martin wrote: Hi

Re: [DUG] Breakpoint in initialization?

2007-07-02 Thread Wayne Roser
Breakpoint worked for me. If I turn Debug info off (Project|Options) and rebuild, my breakpoint becomes invalid. (D6) Wayne NZ Borland Developers Group - Delphi List delphi@delphi.org.nz on Tuesday, 3 July 2007 at 11:59 a.m. + wrote: I have had an application stop running and stack dump

Re: [DUG] Databases with Delphi

2007-07-02 Thread John Bird
Question: Do any of these databases embedded in products have any issues if there is already the same database installed in another product? For instance the coming Firefox Version 3 comes with a SQLite back end (to manage bookmarks etc). If someone also wants to use say SQLite on the same PC

RE: [DUG] Databases with Delphi

2007-07-02 Thread Sean Cross
With Sqlite, you can stick the dll in your app directory, or you can embed it in your app. In either case you are fine. If you stick the dll in a shared directory, then you might be in trouble. Don't know about firebird, but you should be ok with the dlls in the app directory. Regards Sean

RE: [DUG] Databases with Delphi

2007-07-02 Thread Jeremy Coulter
What about using it via say ASP or PHP? Are there ODBC drivers at all? Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean Cross Sent: 3 July 2007 15:37 To: [EMAIL PROTECTED]; NZ BorlandDevelopers Group - Delphi List Subject: RE: [DUG] Databases

RE: [DUG] Databases with Delphi

2007-07-02 Thread Sean Cross
There are bindings for everything. Sqlite is one of the most popular, invisible, databases out there. See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers It is already bundled with Php 5. Regards Sean Cross IT Systems Development Manager Catalyst Risk Management PO Box 230 50 Dalton St