Advantage is fine, we use it for some of our internal testing via ADO and have had no problems. One thing I don't like about Advantage is that it doesn't have a true Varchar; if you do a Create Table, Varchars become Memos. This means, for example, that you can't have a Varchar in a key and that the overhead per field is higher than Varchar. Also can't use Like on a memo. We end up changing many of our Varchars to Chars and just wasting the space, but that also gets into recordsize limitations.
If you're working on a small database, this may not be important. If the database is large or you need to use varchars in keys or with the Like operator, it may be important. YMMV. At 01:25 AM 12/5/2008, [EMAIL PROTECTED] wrote: >I use Advantage database. What they call Local server is available free. >But even better is the two user development server that has beeen made >available at http://www.sybase.com/ads_developer_guide_book. >Then explore the advantage site to download the TTable replcement and >ordert the book . Total cost about $30 for realy exalant product. And your >application will be fully scalable. > > > > > >"Cédric Joubert" <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] >04/12/2008 11:15 >Please respond to >Moderated discussion list about database programming with Borland's >Delphi <delphi-db@elists.org> > > >To >delphi-db@elists.org >cc > >Subject >Choose DB for Delphi > > > > > > >Hi, > >It's me again ;-) > >Which best DB would you use with Delphi7 today for a single user >application >(medium size, 50 unit/forms) ? > >1/ I need one that fit with : >- secure data >- dynamic (auto startup like Interbase/Firebird) >- freeware if possible >- querying with good performance >- transactionnal > >5 years ago, I would think about the open source Firebird... but today >i've >no idea... > > >2/ which access method is recommanded, DvExpress, Ado, other ? > > >Thanks in advance >Cédric >_______________________________________________ >Delphi-DB mailing list >Delphi-DB@elists.org >http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db > > >*********************************************************************** >NOTICE: This e-mail transmission, and any documents, files or previous >e-mail messages attached to it, may contain confidential or privileged >information. If you are not the intended recipient, or a person >responsible for delivering it to the intended recipient, you are >hereby notified that any disclosure, copying, distribution or use of >any of the information contained in or attached to this message is >STRICTLY PROHIBITED. If you have received this transmission in error, >please immediately notify the sender and delete the e-mail and attached >documents. Thank you. >*********************************************************************** >_______________________________________________ >Delphi-DB mailing list >Delphi-DB@elists.org >http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db Regards, Sid Gudes PIA Systems Corporation [EMAIL PROTECTED] _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
