Move between records.

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Jorge Leibowich Thu, 11 Jan 2001 13:33

#5917

Author: Jorge Leibowich
Date: Thu, 11 Jan 2001 13:33

14 lines
1111 bytes

Hello, I got a table ordered by numbers, and I need to print in the printer
like this

1    6    11
2    7     12
3    8    13
4    9    14
5    10   15


Using for's is very complex!!! Are there any function to go DIRECTLY to a
record (for example Query1->GORECORD(3) )

Thanks you!

Re: Move between records.

#5918

Author: Alexei Karas
Date: Thu, 11 Jan 2001 16:08

27 lines
1539 bytes

Conserning ADO - NO. You may only use bookmarks or
MoveFirst/Last/Next/Previous since SQL-oriented databases (and providers)
have no idea about record number. Such thing is meaningless in SQL
databases.

HTH,
    Alexei

"Jorge Leibowich" <jorge@lid.com.ar> wrote in message
news:3a5db631_2@dnews...
> Hello, I got a table ordered by numbers, and I need to print in the
printer
> like this
>
> 1    6    11
> 2    7     12
> 3    8    13
> 4    9    14
> 5    10   15
>
>
> Using for's is very complex!!! Are there any function to go DIRECTLY to a
> record (for example Query1->GORECORD(3) )
>
> Thanks you!
>
>

Re: Move between records.

#5920

Author: Jirzi
Date: Fri, 12 Jan 2001 07:10

42 lines
1843 bytes

What about MoveBy method?
Maybe you can do this:

DataSet1->First();
DataSet1->MoveBy(3);

and you are on the third record.

Jirzi

"Alexei Karas" <nospam_AlexKaras_thatsextraaswell@hotmail.com> wrote in
message news:3a5dda31_1@dnews...
> Conserning ADO - NO. You may only use bookmarks or
> MoveFirst/Last/Next/Previous since SQL-oriented databases (and providers)
> have no idea about record number. Such thing is meaningless in SQL
> databases.
>
> HTH,
>     Alexei
>
> "Jorge Leibowich" <jorge@lid.com.ar> wrote in message
> news:3a5db631_2@dnews...
> > Hello, I got a table ordered by numbers, and I need to print in the
> printer
> > like this
> >
> > 1    6    11
> > 2    7     12
> > 3    8    13
> > 4    9    14
> > 5    10   15
> >
> >
> > Using for's is very complex!!! Are there any function to go DIRECTLY to
a
> > record (for example Query1->GORECORD(3) )
> >
> > Thanks you!
> >
> >
>
>

Re: Move between records.

#5924

Author: Alexei Karas
Date: Mon, 15 Jan 2001 10:56

57 lines
2280 bytes

I spoke about pure ADO, as the question was asked in this NG. In ADO there
is no MoveBy method. Although you may use something like
ADODataSet->MoveFirst();
for (int i=0; i<3; i++)
    ADODataSet->MoveNext();

But the record you'll appear will have no attitude to the digit 3 in no way.

Sincerely,
    Alexei
"Jirzi" <jirzi@hotmail.com> wrote in message news:3a5eadac_1@dnews...
> What about MoveBy method?
> Maybe you can do this:
>
> DataSet1->First();
> DataSet1->MoveBy(3);
>
> and you are on the third record.
>
> Jirzi
>
> "Alexei Karas" <nospam_AlexKaras_thatsextraaswell@hotmail.com> wrote in
> message news:3a5dda31_1@dnews...
> > Conserning ADO - NO. You may only use bookmarks or
> > MoveFirst/Last/Next/Previous since SQL-oriented databases (and
providers)
> > have no idea about record number. Such thing is meaningless in SQL
> > databases.
> >
> > HTH,
> >     Alexei
> >
> > "Jorge Leibowich" <jorge@lid.com.ar> wrote in message
> > news:3a5db631_2@dnews...
> > > Hello, I got a table ordered by numbers, and I need to print in the
> > printer
> > > like this
> > >
> > > 1    6    11
> > > 2    7     12
> > > 3    8    13
> > > 4    9    14
> > > 5    10   15
> > >
> > >
> > > Using for's is very complex!!! Are there any function to go DIRECTLY
to
> a
> > > record (for example Query1->GORECORD(3) )
> > >
> > > Thanks you!
> > >
> > >
> >
> >
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads