String to integer

• • Reply

  14 years ago

  by Surikata

  Surikata

  , Portugal

  Joined 14 years ago

  hey!

  I want to do something like this

  temp1=WorkRS1.Fields("Answer_01")

  Pass the field in "Answer_01" to temp1.

  But WorkRS1.fields("Answer_01") is in string variable.

  str = "WorkRS1.Fields(""Answer_" & i & """)"

  temp1 = str

  This instruction gives me a type missmatch!!!

  How can i resolve this?

  Thanks!!!

  Report abuse
• • Reply

  14 years ago

  by Kassem

  Kassem Baalbaki

  Riyadh, Saudi Arabia

  Joined 14 years ago

  Hi,

  Assuming you are refering by WorkRS1 to a recordset, the problem my friend is that you have assigned a string paprameter to the property .FIELDS where only numbers are allowed. So you need to use the relevent number of the field and not its name in order for this property to work, in this case it should look something like this:

  Dim i as integer

  Dim temp1 as string

  temp1=WorkRS1.Fields(i)

  If you provide me with more information about what are you doing I may be able to further help you.

   

  Hope this works for you.

  Report abuse
• • Reply

  14 years ago

  by rsgovar

  Govarthanan

  Chennai, India, India

  Joined 14 years ago

  Hi,
  From your coding i came to know that ur trying to store the field value to a variable.
  temp1=WorkRS1.Fields("FieldName")
  
  also u told that a string contains right side exp.
  
  
  
  
  
  str="WorkRS1.Fields("FieldName")"
  
  
  
  if u are trying to execute the string content as recordset. it wont work in VB. Actually why you need to run like this, no one programming lang support like this. bcoz recordset is an object and fields is an collection from recordset object you cannot execute the string like recordset.fields().....
  
  
  
  
  
  
  
  

  Report abuse