Re: ADO - Retrieve and update values
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: 29 Sep 2005 04:43:25 -0700
IanJ wrote:
> Hi,
>
> D5, WinXP, SQLServer 2000, MDAC 2.7
>
> I have a table with one row that contains key values for other
> tables. To get the next key value I query the table, store the key
> value, close the query. I then use another query to update the table
> with an incremented value as the next available key. The code is
> shown below (uses ADO)
>
<snip>
i'm a bit confused about you want to accomplish. Specifically:
- Why a table with just one row? What sense has that?
- Why do you need an attribute to be set for *all* the records? Do you
really need that attribute?
- Are you trying to define some sort of master-detail relationship
between 2 tables? I mean like "1 author has written N books"?
--
Best regards :)
Guillem Vicens
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
--
in order to contact me remove the -nospam
.
- References:
- ADO - Retrieve and update values
- From: IanJ
- ADO - Retrieve and update values
- Prev by Date: ADO - Retrieve and update values
- Next by Date: Re: ADO - Retrieve and update values
- Previous by thread: ADO - Retrieve and update values
- Next by thread: Re: ADO - Retrieve and update values
- Index(es):
Relevant Pages
|
