Updating a sql recordset

I sometimes will use Add/Update when I want to do an insert using the Insert Into Table (fields....) Values (.....) command because of all the quote and comma permutations required to write the SQL string that can be parsed by Access....a PITA to write...if the data has single or double quotes it gets to be even more frustrating whileusing a recordset is easy to write and requires little or no debugging. Again, this newsgroup has provided an invaluable service with information coming from real people in an understandable format, not just from a reference book.

I know I can do this in C# but I have a business requirement to use SSIS for all ETL operations. I would like to run multiple sites at the same time, so when all files of all types are completed at that site then go on to the next site in the list.

Run SQL mysql 2.----------------------- set myrecordset = mydb. Execute db Fail On Error ' Takes a brief time to compile before running.

Open Recordset([tablename / sql]) myrecodset.fields("myfield") = [somevalue] myrecordset.update TIA Michelle Hi Using A2003 on XPI am wondering from the MVP's and others, what is the most efficient way (interms of time to process) of updating data in a table, using thedocmd. eg: (if you need it)1.--------------------------mysql = "Update [mytable] SET [Some Field] = [somevalue];"docmd.

Update 'Re-run the Query once the database has been updated .

Fields("Start_date") = str Post Date Time 'Update the database with the new topic details .

I am trying to execute multiple file actions (plus parsing those files into a set of staging tables) at separate locations in parallel.

I know I can do a single site at a time in a foreach loop but if I can run lets say 3-5 sites concurrently then I should be able to save execution time.

For one thing, before you can update a record using a recordset, you must find it.

If this is done with a Where clause in a SELECT statement, you are no making several calls through the database layer instead of just 1.

If you do it with Find First, you are searching through the rows in a recordset with no optimization at all.

After some difficulty upgrading it to SQL - it seems to work almost. Requery 'Read in the new topic's ID number lng Topic ID = CLng(rs Common("Topic_ID")) I really do not know - it is a Web Wiz forum & their support is pretty nill on updating from MSAccess to MSSQL.

I get this message when trying to post anything: ADODB. We downloaded the forum & I would think it would work?

Search for updating a sql recordset:

updating a sql recordset-27updating a sql recordset-44

My thought is to have a recordset of the sites, when any 1 of the 3 (or more) "control flows" is open, update the recordset to let it know that site being actioned, when that site is complete, update the recordset that the site is completed, and so on.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating a sql recordset”