comparing and deciding record
hi peopl i need some advise on how to go about doin this.
I've got a recordset and in the recordset is a field call FreeFieldA
step 1: recordset to contain all FreeFieldA which are empty
step 2: using the ClientNumber (which is unique) and Traveller Name (also unique) to search past record of a traveller with FreeFieldA not empty
step 3: verify that that is the correct string to be inserted by comparing it with multiple records of the same ClientNumber and TravellerName.
step4: if it reaches a certain percentage (say 70%) then copy that string in FreeFieldA and paste it into the the record with the empty FreeFieldA
eh u guys understand what im saying?
[719 byte] By [
Toracle] at [2007-11-19 17:02:10]
# 1 Re: comparing and deciding record
What is the problem? You just need to use a loop moving to the next record in the recordset and applying the logic that you already know of. Also, why not simply fire select queries against the database to achieve all this rather than bringing the records on the client side and looping over them? Had it been VB.Net then you could have had exploited the ADO.NET DataSets/DataTables to accomplish the task in a more easier and efficient way bringing the data on the clientside. Regards.
# 2 Re: comparing and deciding record
What is the problem? You just need to use a loop moving to the next record in the recordset and applying the logic that you already know of. Also, why not simply fire select queries against the database to achieve all this rather than bringing the records on the client side and looping over them? Had it been VB.Net then you could have had exploited the ADO.NET DataSets/DataTables to accomplish the task in a more easier and efficient way bringing the data on the clientside. Regards.
sorry im new to vb and dont understand a word u saying
# 3 Re: comparing and deciding record
Go through the following:
RecordSet object (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrec.asp)Recordset Object Properties, Methods, and Events (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrecpme.asp)MoveFirst, MoveLast, MoveNext, and MovePrevious Methods (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthmovefirst.asp)Look at the various examples.. and try to clarify if this doesn't serve your purpose. Regards.
