duplicates n times a whole record

jsirico · #1 (**permalink**) 02-01-12, 12:08

Hi guys...
I need your help again
I' ve question for you is quite easy:
i'd like to create a filed in a table which will store the lenght of each values' filed:
here is my code

Code:

Sub Lung()
Dim rst As DAO.Recordset
Dim MyString As String ' Initialize variable.
Dim MyLen As String

Dim l As Long


Set rst = CurrentDb.OpenRecordset("Accounting", dbOpenDynaset)
    With rst
        Do Until .EOF
        .Edit
      
       !lun = Len([SCHEMA])
    
      
        
        .Update
         .MoveNext
Loop
.Close
End With

    Set rst = Nothing
End Sub

the problem here is that I don't know how to manage the identity

Code:

!lun = Len([SCHEMA])

in order to make this process wok properly.

healdem · #2 (**permalink**) 02-01-12, 13:19

why do this as a recordset operation
rather than iterating through a record set it would be far quicker to do this as an upodate statememt

update mytable set mycolumnlength = len(mycolumn)

change:-
mytable to the name to the table
mycolumnlength to the name of the column to stroe the length of the string
mycolumn to the name of the column you want to store the length

this will only work with string columns not boolean, numeric or datetime columns. in any event datetime columns are stored as numeric.

as to your second problem I haven't got a clue what you are trying to achieve. you really shoudl have two different threads one for each problem.

jsirico · #3 (**permalink**) 02-02-12, 04:21

ok. thank you.....

Internet Services

Web Development

Digital Marketing

Consumer Tech