General information
Title:
Variant Data Type vs. Integer
I'm accessing a MS SQL table and assigning its records to variables.
It goes something like this:
MyVar = 0
Var2 = Recordset1("Field1") 'Field1 is numeric
MyVar = MyVar + Var2
The browser reports: 'data type mismatch'
When I debug in Interdev, I notice that MyVar's type is integer and Var2's type is Variant. How do I get around this? The table contains mostly numeric data fields.
I would really appreciate it if anyone can help me on this since I'm new at Visual Interdev and MS SQL.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only