Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Newbee idiot question... I hope

5 posts in Delphi Last posting was on 2003-09-08 23:18:39.0Z
Craig Leidy Posted on 2003-09-06 02:48:49.0Z
Reply-To: "Craig Leidy" <surfsoft@comcast.net>
From: "Craig Leidy" <surfsoft@comcast.net>
Newsgroups: advantage.delphi
Subject: Newbee idiot question... I hope
Date: Fri, 5 Sep 2003 22:48:49 -0400
Lines: 44
Organization: SurfSide Software, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4927.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200
NNTP-Posting-Host: 24.129.204.232
Message-ID: <3f594b34@solutions.advantagedatabase.com>
X-Trace: 5 Sep 2003 20:49:24 -0700, 24.129.204.232
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.129.204.232
Xref: solutions.advantagedatabase.com Advantage.Delphi:13896
Article PK: 1107333

I was pretty impressed with this here
new fangled Advantage data base.
Not only is it free but they'd call every
so often to see how I'm doing.

They was downright helpful whenever
I come up with a problem.... until today.
It seems the honeymoon is over and
the thrill is gone...

"Sorry Mr. Leidy, your free support
has expired we are banishing you to
the nether realm of the NewsGroup".

Nothing good ever lasts very long.
The better the ride the shorter the trip.

Anyway...I was using Paradox files.
I'm recursively stepping thru BOM's
(Bills of Materials).

Got that solved OK buy selecting a range
and keeping track of where I'm at in the
range in each level of recursion.

So... in Paradox I would...
SetRangeStart;
<set the start string>
SetRangeEnd;
<set the end string>
ApplyRange;

In Advantage I get "Index is not set"
on the SetRangeStart.
Do you have to explicitly name an index?

Old databases are like old girlfriends...
No surprises and you understand how
they function.

Thanks, Craig.


francois Posted on 2003-09-06 07:40:19.0Z
Reply-To: "francois" <fransh_@westnet.com.au>
From: "francois" <fransh_@westnet.com.au>
Newsgroups: advantage.delphi
References: <3f594b34@solutions.advantagedatabase.com>
Subject: Re: Newbee idiot question... I hope
Date: Sat, 6 Sep 2003 15:40:19 +0800
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
NNTP-Posting-Host: 202.72.180.11
Message-ID: <3f59906e@solutions.advantagedatabase.com>
X-Trace: 6 Sep 2003 01:44:46 -0700, 202.72.180.11
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!202.72.180.11
Xref: solutions.advantagedatabase.com Advantage.Delphi:13897
Article PK: 1107335

Hi Craig
I suspect that you rely on the primary index of your Paradox table.
ADS/ALS convert those to an index named 'PRIMARY'.
Any setrange (Paradox too) requires that the fields coincide with the
current indexfieldnames.
Thus you must specify the indexname before setting the range.

You'll however find lots of other nice goodies in the ADS indexing
department.
My favourite is the ability to index multiple times on one field where
another field is conditional say:
ID where Ftype='Creditor'
ID where Ftype='Client'
ID where Ftype='Staff'
Each of these much smaller indexes now has an implicit setrange on a field
not usually in the indexfieldname list.

Regards
Francois

"Craig Leidy" <surfsoft@comcast.net> wrote in message
news:3f594b34@solutions.advantagedatabase.com...
> I was pretty impressed with this here
> new fangled Advantage data base.
> Not only is it free but they'd call every
> so often to see how I'm doing.
>
> They was downright helpful whenever
> I come up with a problem.... until today.
> It seems the honeymoon is over and
> the thrill is gone...
>
> "Sorry Mr. Leidy, your free support
> has expired we are banishing you to
> the nether realm of the NewsGroup".
>
> Nothing good ever lasts very long.
> The better the ride the shorter the trip.
>
> Anyway...I was using Paradox files.
> I'm recursively stepping thru BOM's
> (Bills of Materials).
>
> Got that solved OK buy selecting a range
> and keeping track of where I'm at in the
> range in each level of recursion.
>
> So... in Paradox I would...
> SetRangeStart;
> <set the start string>
> SetRangeEnd;
> <set the end string>
> ApplyRange;
>
> In Advantage I get "Index is not set"
> on the SetRangeStart.
> Do you have to explicitly name an index?
>
> Old databases are like old girlfriends...
> No surprises and you understand how
> they function.
>
> Thanks, Craig.
>
>
>


Craig Leidy Posted on 2003-09-06 12:43:06.0Z
Reply-To: "Craig Leidy" <surfsoft@comcast.net>
From: "Craig Leidy" <surfsoft@comcast.net>
Newsgroups: advantage.delphi
References: <3f594b34@solutions.advantagedatabase.com> <3f59906e@solutions.advantagedatabase.com>
Subject: Re: Newbee idiot question... I hope
Date: Sat, 6 Sep 2003 08:43:06 -0400
Lines: 18
Organization: SurfSide Software, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4927.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200
NNTP-Posting-Host: 24.129.204.232
Message-ID: <3f59d68d@solutions.advantagedatabase.com>
X-Trace: 6 Sep 2003 06:43:57 -0700, 24.129.204.232
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.129.204.232
Xref: solutions.advantagedatabase.com Advantage.Delphi:13898
Article PK: 1107334

francois:

> I suspect that you rely on the primary index of your Paradox table.
> ADS/ALS convert those to an index named 'PRIMARY'.
> Any setrange (Paradox too) requires that the fields coincide with the
> current indexfieldnames.
> Thus you must specify the indexname before setting the range.

The conversion created a proper PRIMARY index with only
one field BOMID just like the Paradox file.
What do I do.... PRIMARY SetRangeStart?

And Thanks, Craig.


Lance Schmidt Posted on 2003-09-06 21:25:07.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.delphi
References: <3f594b34@solutions.advantagedatabase.com> <3f59906e@solutions.advantagedatabase.com> <3f59d68d@solutions.advantagedatabase.com>
Subject: Re: Newbee idiot question... I hope
Date: Sat, 6 Sep 2003 15:25:07 -0600
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 198.60.232.39
Message-ID: <3f5a50d1@solutions.advantagedatabase.com>
X-Trace: 6 Sep 2003 15:25:37 -0700, 198.60.232.39
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.60.232.39
Xref: solutions.advantagedatabase.com Advantage.Delphi:13899
Article PK: 1107332

Hello Craig,

If you are using a Data Dictionary then you can set a default index on the
table. A default index in Advantage is the same concept as a primary index
with Paradox. If you are not using a data dictionary, then you can descend
your own class from TAdsTable and have it always the IndexName property to
'primary'.

Good Day,

Lance Schmidt
Advantage R&D
LanceSc@ExtendSys.com

"Craig Leidy" <surfsoft@comcast.net> wrote in message
news:3f59d68d@solutions.advantagedatabase.com...
> francois:
>
> > I suspect that you rely on the primary index of your Paradox table.
> > ADS/ALS convert those to an index named 'PRIMARY'.
> > Any setrange (Paradox too) requires that the fields coincide with the
> > current indexfieldnames.
> > Thus you must specify the indexname before setting the range.
>
> The conversion created a proper PRIMARY index with only
> one field BOMID just like the Paradox file.
> What do I do.... PRIMARY SetRangeStart?
>
> And Thanks, Craig.
>
>
>
>
>


Jeremy D. Mullin Posted on 2003-09-08 23:18:39.0Z
From: Jeremy D. Mullin <jeremym@extendsys.com>
Newsgroups: advantage.delphi
Subject: Re: Newbee idiot question... I hope
Date: Mon, 8 Sep 2003 17:18:39 -0600
Message-ID: <MPG.19c6bc37301a6f52989b90@solutions.advantagedatabase.com>
References: <3f594b34@solutions.advantagedatabase.com> <3f59906e@solutions.advantagedatabase.com> <3f59d68d@solutions.advantagedatabase.com>
Organization: ESI
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: 198.60.232.45
X-Trace: 8 Sep 2003 17:19:05 -0700, 198.60.232.45
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.60.232.45
Xref: solutions.advantagedatabase.com Advantage.Delphi:13919
Article PK: 1107355

In article <3f59d68d@solutions.advantagedatabase.com>,
surfsoft@comcast.net says...

> The conversion created a proper PRIMARY index with only
> one field BOMID just like the Paradox file.
> What do I do.... PRIMARY SetRangeStart?

MyTable.Indexname := 'primary';
SetRangeStart;
etc.

J.D. Mullin
Advantage R&D