In ADO, this object is the most important and the one used most often to manipulate data from a database.
When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False.
Thanks, Dave Hatz First of all, don't use ttables, use tquery's. If your SQL statements meet the rules to return a live record set, you will be able to edit and update the records.
If it doesn't, set cachedupdates to true, drop a tupdatesql object into the app and use that to update the records (as well as insert and delete).
Connection") Set obj Record Set = Create Object("ADODB. Open _ "Provider=SQLOLEDB; Data Source=2k3-faxsrv01\fax;" & _ "Trusted_Connection=Yes; Initial Catalog=ASFaxing SQL;" & _ "User ID=sa; Password=Juniper;" obj Record Set. Record Count int High Number = 6 int Low Number = 1 For i = 1 to 1 Randomize int Number = Int((int High Number - int Low Number 1) * Rnd int Low Number) Next str Fax Server = "FAXSRV0" & CStr(int Number) Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
Open "SELECT * FROM [User] WHERE Home Remote ID = '0'", _ obj Connection, ad Open Static, ad Lock Optimistic obj Record Set. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
I am trying to locate information on how to apply SQL methods for my application. Examining a record deleted from a batch update recordset 9. Recordset.status doesnt change when record updated ?? 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. Run SQL mysql 2.-----------------------set myrecordset = mydb. Ok, I going to expose my ignorance of handling remote record Sets and/or Views in ADO.I'm in the planning stage of a project using Flash Remoting and ADO . The Flash client has no problem consuming an ADO record Set then after updating, passing it back to the object and reconstructing the record Set with the changes.