RE: [DUG]: dbf indexes
This is the link you want: http://www.borland.com/devsupport/delphi/ti_list/TI868D.html and there are more Dbase TIs on the list here: http://www.borland.com/devsupport/delphi/ti_list/ > I just had a look at borland.com but couldn't find it. If > either of you > do have it / find it, I'd appreciate it if you could send me a copy. Cheers, Simon. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: dbf indexes
OK, I couldn't find this on the web site, but I found it on the latest conference CD: \BorlandOnline\docs\v0002329.htm I have uploaded the text content of this page to : ftp://www.delphi.org.nz/DUG/dBaseExpr.txt regards, Steve. -Original Message- From: Simon Mahony <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Thursday, 18 March 1999 15:12 Subject: RE: [DUG]: dbf indexes Yes, there's a white paper on the Borland.com site called "DBase Index Expression Primer" or something similar. It's quite good. I used it a lot in my Delphi 1 days. Cheers, Simon Mahony. > Thanks Steven - I did get this working - I hadn't realised > that Delphi > supported a few xbase functions for index expressions. > > Is there any documentation on this? --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: dbf indexes
Simon/Peter Actually I am interested in the data also, please post to the group or copy to me. best regards Leo Ramakers Soft Option Peter Vroegop wrote: > I just had a look at borland.com but couldn't find it. If either of you > do have it / find it, I'd appreciate it if you could send me a copy. > > Tnanks in advance. > > Simon Mahony wrote: > > > > Yes, there's a white paper on the Borland.com site called "DBase Index > > Expression Primer" or something similar. > > It's quite good. I used it a lot in my Delphi 1 days. > > Cheers, > > Simon Mahony. > > > > > Thanks Steven - I did get this working - I hadn't realised > > > that Delphi > > > supported a few xbase functions for index expressions. > > > > > > Is there any documentation on this? > > --- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: dbf indexes
I just had a look at borland.com but couldn't find it. If either of you do have it / find it, I'd appreciate it if you could send me a copy. Tnanks in advance. Simon Mahony wrote: > > Yes, there's a white paper on the Borland.com site called "DBase Index > Expression Primer" or something similar. > It's quite good. I used it a lot in my Delphi 1 days. > Cheers, > Simon Mahony. > > > Thanks Steven - I did get this working - I hadn't realised > > that Delphi > > supported a few xbase functions for index expressions. > > > > Is there any documentation on this? --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: dbf indexes
Yes, there's a white paper on the Borland.com site called "DBase Index Expression Primer" or something similar. It's quite good. I used it a lot in my Delphi 1 days. Cheers, Simon Mahony. > Thanks Steven - I did get this working - I hadn't realised > that Delphi > supported a few xbase functions for index expressions. > > Is there any documentation on this? --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: dbf indexes
Thanks Steven - I did get this working - I hadn't realised that Delphi
supported a few xbase functions for index expressions.
Is there any documentation on this?
I tried str() and dtos() OK, but others like descend() wouldn't work.
Any code fragments on creating indexes would be good, ta. Especially on the
different handling of production and non-production index files.
regards,
Steve.
-Original Message-
From: Steven Wild <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Tuesday, 16 March 1999 20:55
Subject: Re: [DUG]: dbf indexes
Steve
I have and am using dbase .dbf tables and Delphi/BDE with delphi
since the beta of Delphi 1 (with the exception of a short excursion
into Apollo).
Delphi with create an xbase expression as an index so that an
expression like
'fld1 + str(fld2,8,0) + dtos(fld3)'
will work fine.
I use 'locate' as my main find tool. Syntax like
table1.locate('fld1', MyValue, []);
works fine.
If you continue to have trouble - particularly with creating the
index using either the TTable method or the BDE method, let me know
and I will send code segments!
Alternatively send me some code fragments to audit.
Steven
Wild Software Ltd
P O Box 33-216
Christchurch
NEW ZEALAND
=
I haven't lost my mind; it's backed up on tape somewhere.
=
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
Re: [DUG]: dbf indexes
Steve
I have and am using dbase .dbf tables and Delphi/BDE with delphi
since the beta of Delphi 1 (with the exception of a short excursion
into Apollo).
Delphi with create an xbase expression as an index so that an
expression like
'fld1 + str(fld2,8,0) + dtos(fld3)'
will work fine.
I use 'locate' as my main find tool. Syntax like
table1.locate('fld1', MyValue, []);
works fine.
If you continue to have trouble - particularly with creating the
index using either the TTable method or the BDE method, let me know
and I will send code segments!
Alternatively send me some code fragments to audit.
Steven
> Has anyone here done much with dbase .dbf tables and Delphi/BDE?
>
> I am just trying to do a very simple price quote app for a customer against
> their existing dbf tables.
>
> I copy the table (small) to a local drive first, then create an index on 3
> fields using an expression i.e. 'fld1+fld2+fld3'
>
> First problem: This works if all those fields are character, but not if one
> is numeric - the index is created in this case but the sort order is not
> what would be expected. In dBase (or Clipper etc) we could do something
> like: 'fld1+str(fld2,5)+fld3' if one of the fields was numeric. Apart from
> using another product such as Apollo, has anyone got any tips here?
>
> I have actually worked around this by changing the field type from numeric
> to character on the fly on my local copy of the table (not nice but it
> works).
>
> Second problem: I can't seem to get table1.locate to work. What is the
> correct syntax when using dbf index expressions as above?
>
> Any general tips on working with dbf files from Delphi (3 or 4) would be
> appreciated.
>
> thanks,
>
> Steve.
>
>
>
>
> ---
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
>
Wild Software Ltd
P O Box 33-216
Christchurch
NEW ZEALAND
=
I haven't lost my mind; it's backed up on tape somewhere.
=
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
RE: [DUG]: dbf indexes
It's been a while since I used Clipper or dBase files but I seem to remember that you can use xBase functions in the expression to build the index. ie 'fld1 + str(fld2,5) + fld3' should work if you create the index in database desktop. Cheers Duane. > -Original Message- > From: Stephen Barker [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 15, 1999 1:36 AM > To: Multiple recipients of list delphi > Subject: [DUG]: dbf indexes > > Has anyone here done much with dbase .dbf tables and Delphi/BDE? > > I am just trying to do a very simple price quote app for a customer > against > their existing dbf tables. > > I copy the table (small) to a local drive first, then create an index > on 3 > fields using an expression i.e. 'fld1+fld2+fld3' > > First problem: This works if all those fields are character, but not > if one > is numeric - the index is created in this case but the sort order is > not > what would be expected. In dBase (or Clipper etc) we could do > something > like: 'fld1+str(fld2,5)+fld3' if one of the fields was numeric. Apart > from > using another product such as Apollo, has anyone got any tips here? > > I have actually worked around this by changing the field type from > numeric > to character on the fly on my local copy of the table (not nice but it > works). > > Second problem: I can't seem to get table1.locate to work. What is the > correct syntax when using dbf index expressions as above? > > Any general tips on working with dbf files from Delphi (3 or 4) would > be > appreciated. > > thanks, > > Steve. > > > > > -- > - > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
