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.

Delphi 6, dbase to ADT... Setrange... Endrange... applyrange issue

3 posts in Delphi Last posting was on 2003-09-18 15:02:30.0Z
DA Brookes Posted on 2003-09-15 11:21:52.0Z
From: "DA Brookes" <david.brookes@nospaminterserveprojects.com>
Newsgroups: advantage.delphi
Subject: Delphi 6, dbase to ADT... Setrange... Endrange... applyrange issue
Date: Mon, 15 Sep 2003 12:21:52 +0100
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.173.110.62
Message-ID: <3f65a0b5@solutions.advantagedatabase.com>
X-Trace: 15 Sep 2003 05:21:25 -0700, 62.173.110.62
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.173.110.62
Xref: solutions.advantagedatabase.com Advantage.Delphi:13948
Article PK: 1107382

Hi I posted on the 11th, but I'm not sure if the posting worked...

The following code generates the error "Index not set"

The table has an index "tot_ref" combining two fields "con_no" and "Wc_no"
How do I get past this ?

I thought the migration path from dbase to ADT was a simple one. This is the
first real test I've tried and I've falled flat on my face with, what should
be, a simple set of instructions...

Can anyone advise the work-around for this ? Or tell me what I'm doing wrong
?

Regards
Dave

with proj_dir do
begin
IndexName := 'tot_ref';
disablecontrols;
EditRangeStart;;
fieldbyname('group').asstring :=
groups.fieldbyname('group').asstring;
fieldbyname('con_no').asstring := '';
EditRangeend;
fieldbyname('group').asstring :=
groups.fieldbyname('group').asstring;
fieldbyname('con_no').asstring := '%';
applyrange;
enablecontrols;
end;


Corey Wood Posted on 2003-09-15 11:47:29.0Z
From: "Corey Wood" <corey.wood@nospam.sunfiretechnologies.com>
Newsgroups: advantage.delphi
References: <3f65a0b5@solutions.advantagedatabase.com>
Subject: Re: Delphi 6, dbase to ADT... Setrange... Endrange... applyrange issue
Date: Mon, 15 Sep 2003 07:47:29 -0400
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 12.15.91.94
Message-ID: <3f65a72b@solutions.advantagedatabase.com>
X-Trace: 15 Sep 2003 05:48:59 -0700, 12.15.91.94
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!12.15.91.94
Xref: solutions.advantagedatabase.com Advantage.Delphi:13949
Article PK: 1107385

Dave,

As I recall, using SetRangeStart/SetRangeEnd or EditRangeStart/EditRangeEnd
requires that the fields be indexed. However, you stated that the index
"tot_ref" has the fields "con_no" and "Wc_no", with no mention of the field
"group" (which you are using in your code example), which I believe is
causing your "Index not set" error. Is that the case?

Corey Wood

"DA Brookes" <david.brookes@nospaminterserveprojects.com> wrote in message
news:3f65a0b5@solutions.advantagedatabase.com...
> Hi I posted on the 11th, but I'm not sure if the posting worked...
>
> The following code generates the error "Index not set"
>
> The table has an index "tot_ref" combining two fields "con_no" and
"Wc_no"
> How do I get past this ?
>
> I thought the migration path from dbase to ADT was a simple one. This is
the
> first real test I've tried and I've falled flat on my face with, what
should
> be, a simple set of instructions...
>
> Can anyone advise the work-around for this ? Or tell me what I'm doing
wrong
> ?
>
> Regards
> Dave
>
> with proj_dir do
> begin
> IndexName := 'tot_ref';
> disablecontrols;
> EditRangeStart;;
> fieldbyname('group').asstring :=
> groups.fieldbyname('group').asstring;
> fieldbyname('con_no').asstring := '';
> EditRangeend;
> fieldbyname('group').asstring :=
> groups.fieldbyname('group').asstring;
> fieldbyname('con_no').asstring := '%';
> applyrange;
> enablecontrols;
> end;
>
>
>


DA Brookes Posted on 2003-09-18 15:02:30.0Z
From: "DA Brookes" <david.brookes@nospaminterserveprojects.com>
Newsgroups: advantage.delphi
References: <3f65a0b5@solutions.advantagedatabase.com> <3f65a72b@solutions.advantagedatabase.com>
Subject: Re: Delphi 6, dbase to ADT... Setrange... Endrange... applyrange issue
Date: Thu, 18 Sep 2003 16:02:30 +0100
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.173.110.62
Message-ID: <3f69c8e7@solutions.advantagedatabase.com>
X-Trace: 18 Sep 2003 09:01:59 -0700, 62.173.110.62
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.173.110.62
Xref: solutions.advantagedatabase.com Advantage.Delphi:13967
Article PK: 1107406

Hi... My Fault, I should have said "con_no" and "group"... not "Wc_no"
that's an error somewhere else... :-(

Any ideas ???
Regards

Dave

"Corey Wood" <corey.wood@nospam.sunfiretechnologies.com> wrote in message
news:3f65a72b@solutions.advantagedatabase.com...
> Dave,
>
> As I recall, using SetRangeStart/SetRangeEnd or
EditRangeStart/EditRangeEnd
> requires that the fields be indexed. However, you stated that the index
> "tot_ref" has the fields "con_no" and "Wc_no", with no mention of the
field
> "group" (which you are using in your code example), which I believe is
> causing your "Index not set" error. Is that the case?
>
> Corey Wood
>
>
> "DA Brookes" <david.brookes@nospaminterserveprojects.com> wrote in message
> news:3f65a0b5@solutions.advantagedatabase.com...
> > Hi I posted on the 11th, but I'm not sure if the posting worked...
> >
> > The following code generates the error "Index not set"
> >
> > The table has an index "tot_ref" combining two fields "con_no" and
> "Wc_no"
> > How do I get past this ?
> >
> > I thought the migration path from dbase to ADT was a simple one. This is
> the
> > first real test I've tried and I've falled flat on my face with, what
> should
> > be, a simple set of instructions...
> >
> > Can anyone advise the work-around for this ? Or tell me what I'm doing
> wrong
> > ?
> >
> > Regards
> > Dave
> >
> > with proj_dir do
> > begin
> > IndexName := 'tot_ref';
> > disablecontrols;
> > EditRangeStart;;
> > fieldbyname('group').asstring :=
> > groups.fieldbyname('group').asstring;
> > fieldbyname('con_no').asstring := '';
> > EditRangeend;
> > fieldbyname('group').asstring :=
> > groups.fieldbyname('group').asstring;
> > fieldbyname('con_no').asstring := '%';
> > applyrange;
> > enablecontrols;
> > end;
> >
> >
> >
>
>