SQL Newbie Question

[doctor2001]

Hi -
I am banging my head against the wall trying to figure out this query:

arcycle_add_week.Open "UPDATE arcycle SET arcycle.week = " & Text2.Text & " " & "Where arcycle.document = " & Text3.Text & "", acn, adOpenKeyset, adUseClient

What I am hoping it does is:

update a table(arcycle) in column(week) with data from text2 where the critria from text3 is reached.

Can any help !!!

Thanks

 

[Transcend]

What is arcycle_add_week?

Transcend

 

[ArtieChoke]

Are both fields numeric? If they are character, you need to use single quotes around the values.

You don't need to use a recordset, as an update doesn't return any values. Just use the execute method of the connection object.

If you have a way to test your update statement directly in the db (like with query analyzer for SQL Server), try that first with actual data to verify it works.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[Transcend]

That's what i was going to say

It looks like a recordset which you really don't need for an update statement.

Transcend