Re: > 1 Alternate Row?

In article <8bntp9$44t$1_at_nnrp1.deja.com>, Zdenek Zavadil <zzavadil_at_my-deja.com> wrote:
> In article <8bnmn7$sam$1_at_nnrp1.deja.com>,
> jehall_at_my-deja.com wrote:
> > In article <8bn0vb$5ab$1_at_nnrp1.deja.com>,
> > Zdenek Zavadil <zzavadil_at_my-deja.com> wrote:
> > > In article <8bgi8m$fhm$1_at_nnrp1.deja.com>,
> > > jehall_at_my-deja.com wrote:
> > > > I keep seeing messages posted on setting the Alternate Row ID to
> the
> > > > primary key and then passing the p_arg_value to automatically
> query
> > > the
> > > > form. 2 Questions?
> > > >
> > > > 1) What if you have a table which has to keys to have a unique
> > value?
> > > > 2) If this can be done, how do you pass the value of a
parameter.
> > For
> > > > instance p_arg_values=x where x might be assigned the value 10,
> > so...
> > > > p_arg_values=VAL(X) not ='x'!!!???
> > > >
> > > > Jason
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > Hi Jason,
> > > you can use the ROWID pseudocolumn, which uniquely identifies a
row
> in
> > > a table, no matter how many keys it has.
> > >
> > > Zdenek
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> > Can you give me an example of this, if say, my table has KEYA and
> KEYB.
>
> If you want to retrieve the one unique row in a form,
> pass into that form p_arg_names=_rowid&p_arg_values=x,
> where the x is a value obtained somewhere (e.g. in a report)
> using SELECT ROWID from any_table WHERE keya = a AND keyb = b
>
> > And also concerning question 2!!! Where I want to pass in the URL
not
> a
> > string literal value, but the value of a parameter field, say X
where
> X
> > might = '10'. i.e., p_arg_values =VAL(X) not p_arg_values='X'!!1
> >
>
> You always must use pairs p_arg_names + p_arg_values, i.e.
> p_arg_names=x&p_arg_values=10
>
> > Thanks Again!!!
> >
> > Jason.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
The value is not coming from a WEBDB report. It is coming from a Report 6.0 report.

Jason.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 17:34:35 CEST