At the risk of teaching you to suck eggs :')
SELECT cropcode, formulation, upper(substring(labeltext,1,250)) AS test1
from labeltx
where upper(substring(labeltext,1,250)) LIKE '%QUARTS%'
Order by upper(substring(labeltext,1,250))
CREATE TABLE vchar_test (
f1 VarChar( 250 ),
id Char( 10 )) IN DATABASE;
EXECUTE PROCEDURE sp_CreateIndex90(
'vchar_test',
'vchar_test.adi',
'F1',
'f1',
'',
2,
1024,
'' );
I do not use varchar at all, and I do not use memo's much but I find that
substring gets round my problems with this. The modern way is I suppose to
use the Full Text Search (FTS) stuff but I have not tried any of it yet. I
will have to make some time.
Sid Gudes <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/12/2008 16:51
Please respond to
Moderated discussion list about database programming with Borland's
Delphi <delphi-db@elists.org>
To
Moderated discussion list about database programming with Borland's Delphi
<delphi-db@elists.org>
cc
Subject
Re: Choose DB for Delphi
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
***********************************************************************
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
