Happy Codings - Programming Code Examples

Html Css Web Design Sample Codes

CPlusPlus Programming Sample Codes

JavaScript Programming Sample Codes

C Programming Sample Codes

CSharp Programming Sample Codes

Java Programming Sample Codes

Php Programming Sample Codes

Visual Basic Programming Sample Codes

Visual Basic Programming Code Examples

Visual Basic > Database SQL Stuff Code Examples

Cloning or copying an ADO recordset

Cloning or copying an ADO recordset

The code below shows how to copy/clone an existing ADO recordset. This functionality can be useful if you want to keep an copy of the data before the user makes any changes (note, you can also use the oRs.Fields(x).OriginalValue property for this).


'Purpose   :    Creates a copy an existing client side ADO recordset
'Inputs    :    oRs                 The recordset to copy
'Outputs   :    Returns a copy of the recordset on success, or nothing on failure.
'Notes     :

Function RsClone(oRs As ADODB.Recordset) As Recordset
    Dim oStream As ADODB.Stream, oRsClone As ADODB.Recordset
    
    On Error GoTo ErrFailed
    If oRs.CursorLocation = adUseClient Then
        Set oStream = New ADODB.Stream
        oRs.Save oStream, adPersistXML
        Set oRsClone = New ADODB.Recordset
        oRsClone.Open oStream
        Set oStream = Nothing
        Set RsClone = oRsClone
        Set oRsClone = Nothing
    Else
        Debug.Print "Must use client side recordsets..."
        Debug.Assert False
    End If

    Exit Function

ErrFailed:
    Debug.Print Err.Description
    Debug.Assert False
    Set RsClone = Nothing
End Function

C Power of a Number using Pow Function - C Programming Code to input two numbers from user and find their power using pow() function. How to find power of a number in c. How to use pow() function in C programming.

Find the First Capital Letter in String Using - C program code to find the first Capital letter that exists in string, using recursion. We have included ctype.h in order to make use of "int isupper(char);" function that's defined inside

C++ Implement Gift Wrapping Algorithm - Implement Gift Wrapping algorithm to find convex hull in "Two Dimensional Space". In computational geometry, the gift wrapping algorithm is an algorithm for computing the

Program to Accept the Height of a Person - Take the height of a person as input and store it in the variable height. If the variable height is lesser than 150 cm, then print the output as "Dwarf". If the variable height is lesser than...

Find Palindrome Number in C++ language - We already known that if reverse of a number is equal to the same number, it is Palindrome number. Remember it: certain variables and a loop use to get the reverse of a number which

C++ Program Three Dimensional 3D Array - 3D array contains three for loops. to initialize and "print three dimensional" array, you have to use three for loops. Third for loop forms 1D array, Second for loop forms 2D array and the

C Code Find Perfect Numbers from 1 to N - C program find Perfect numbers between 1 to n. Input Upper Limit to find Perfect numbers. Store it in a variable say end. Run a loop from 1 to end, increment 1 in each iteration. The...

Calculate Display the Grade of the Student - To calculate "grade of a student" on the basis of his total marks in C++ Programming, ask to the user to enter marks obtained in some subjects (5 subjects here). To calculate grade