[AccessD] Editing Records

Tim,

You can craft your upated query in raw SQL.  The basic syntax is

UPDATE <record source>
SET <field1> = <value1>, <field2> = <value2>, ...
WHERE <criteria>;

And then execute that statement once you've established a connection to
the BE database.

If you don't feel comfortable writing SQL directly, create a mock-up
table in your db and use the QBE grid to put it together.  Then copy and
paste the resulting SQL into your code.  Note there is a lot of
"readability" clean-up you can do with the SQL the QBE grid generates.

Seth

On Wed, 2003-03-05 at 09:32, Swisher, Timothy B. wrote:
> I think I need to use a recordset because I do not have the validation data
> available to the app in any other form.
>  
> More background...
> We get a file from one of our apps, I import that data into an Access db,
> that data needs to be validated against our SQL Server.  The data from the
> SQL Server is unbound, no table links.  I basically send the server a
> project number, if it returns a record, its valid, if not its an error.  We
> are checking for errors on project numbers, whether its active etc.  We also
> use the project number and other data to find information about the project
> and add that to the record, who it belongs, client, etc.  There is different
> criteria for each validation.  For each record, I could have anywhere from
> no changes to 13 changes.   
>  
> Thanks again.
>  
> Tim
>  

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University