MySQL access thorugh VB6

[1gbram]

Hi all,
I'm trying to access a MySQL database through VB6, and iv used a script I found on google. It says to access colums using " ! " followed by the column name, for example for the column 'username' use:

variable = !username

I am trying to incorporate this in to a function, where the column might change, how would I access different columns depending on variables?

 

[JoeAtWork]

Use something like this:

variable = rs("UserName")

or

variable = rs(MyVariableWithTheFieldName)

Where rs is your recordset.

 

[Golom]

The bang (!) notation is used to identify a field in a recordset. For example

myValue = rs![Field5]

Selects the field named "Field5" in the current record in the recordset "rs".

You can use the notation that you presented in conjunction with a WITH statement

With rs
    myValue = ![Field5]
End With

and that does the same thing as the first example.

I always use square brackets around the field name. They are not required in all cases but they are required if the field name contains spaces or if the field name is a reserved word.