I would use an Xtra. Director can search the data fairly efficiently but with extreme limits. If you need to do things like multi table searches or have a LOT of records it can bog lingo down. The ones I use the most are...
ADO - (I market this so just my disclaimer that I have a vested interest in this one). Works great with standard Databases like Access, etc. Great if the client needs to use an existing DB and keep it in its native format. - PC only Arca - Tabuleiro's Arca is really nice. Been using it for a few months and its speed is great, easy to use and takes standard SQL. Inexpensive and cross platform. V12 - Also a good choice and is cross platform. My only negative is the lack of multi table joins. Valentina - Fast and effective. Also cross platform. There is good support and a pretty active group of users. One added bonus for Valentina is that it also comes in "flavors" for other languages like real basic, etc. I have my own lingo "database" objects as well but generally I find that they have too many limitations and the time to develop a good one is more than the cost of a good DB Xtra. Once you have the Xtra it's a LOT easier to just use it from then on out. Unless price is a huge issue on this I would recommend the Xtra. -Chuck -------------------------- Chuck Neal CEO, MediaMacros, Inc. [EMAIL PROTECTED] http://www.mediamacros.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Ingrum Sent: Monday, June 07, 2004 9:40 PM To: [EMAIL PROTECTED] Subject: Re: <lingo-l> database lingo vs. xtra I'm thinking about just doing the project with lingo and perhaps PropSave (and of course, some buddyAPI thrown in there for good measure), but I wanted to get the groups response before I start- Details: the "database" will be updated by only 1 (or maybe 2) people ever. it will contain 1200-1500 entries each entry will contain firstname, lastname, storenumber, images(anywhere from 0-5), other misc textbased fields The client *really* only wants the application to keep track of these images (he takes them throughout the year). The client will use the data at the end of the year to make a "yearbook" of images/quotes, etc... Anyway, does anybody have any good reasons that I should just create it with Lingo? or should I create it with V12 or one of the others? Stephen [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!] [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
