Chris Moore
|
Posted: 07/14/2003, 1:34 PM |
|
I need to be able to programaticly update a field on the database everytime
an insert occurs (I need to add the SQL string that was just used to create
the recordset to a field in my Access database). Where is an example of how
to do this? I have seen one somewhere but not sure where.
Thanks
Chris
|
|
|
Frank Rocco
|
Posted: 07/14/2003, 1:48 PM |
|
Why not add it as a hidden field on the form.
Regards,
Frank
"Chris Moore" <chris@dblayout.com> wrote in message
news:Xns93B89F08516D7cabubba@66.180.229.147...
> I need to be able to programaticly update a field on the database
everytime
> an insert occurs (I need to add the SQL string that was just used to
create
> the recordset to a field in my Access database). Where is an example of
how
> to do this? I have seen one somewhere but not sure where.
>
> Thanks
>
> Chris
|
|
|
Chris Moore
|
Posted: 07/14/2003, 1:55 PM |
|
How do I get the SQL statement that was used to retrieve my data? I need
to keep that string in my DB. I am using ASP.
Thanks.
"Frank Rocco" <farocco@hotmail.com> wrote innews:bev4v2$qsn$1
@news.codecharge.com:
> Why not add it as a hidden field on the form.
>
> Regards,
>
> Frank
>
>
> "Chris Moore" <chris@dblayout.com> wrote in message
>news:Xns93B89F08516D7cabubba@66.180.229.147...
>> I need to be able to programaticly update a field on the database
> everytime
>> an insert occurs (I need to add the SQL string that was just used to
> create
>> the recordset to a field in my Access database). Where is an example
of
> how
>> to do this? I have seen one somewhere but not sure where.
>>
>> Thanks
>>
>> Chris
>
>
>
|
|
|
Chris Moore
|
Posted: 07/14/2003, 2:21 PM |
|
Never mind, I got it.
Thanks
Chris Moore <chris@dblayout.com> wrote in news:Xns93B8A2906522Ecabubba@
66.180.229.147:
> How do I get the SQL statement that was used to retrieve my data? I
need
> to keep that string in my DB. I am using ASP.
>
> Thanks.
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote innews:bev4v2$qsn$1
> @news.codecharge.com:
>
>> Why not add it as a hidden field on the form.
>>
>> Regards,
>>
>> Frank
>>
>>
>> "Chris Moore" <chris@dblayout.com> wrote in message
>>news:Xns93B89F08516D7cabubba@66.180.229.147...
>>> I need to be able to programaticly update a field on the database
>> everytime
>>> an insert occurs (I need to add the SQL string that was just used to
>> create
>>> the recordset to a field in my Access database). Where is an example
> of
>> how
>>> to do this? I have seen one somewhere but not sure where.
>>>
>>> Thanks
>>>
>>> Chris
>>
>>
>>
>
>
|
|
|