Get long record value

4 posts / 0 new
Last post
leonardo9203
Offline
Joined: 04/17/2018 - 16:54
Get long record value

Hello
you know if there is any way to get a value from a field that is numeric, but it is very large and you have to bring it as long.
For Example exist types of Get Value

  • ActiveRecord.GetCharValue
  • ActiveRecord.GetNumValue

But ActiveRecord.GetLongValue don't exists
My Code:
MontosValor = RS.ActiveRecord.GetCharValue("MANUALESMONTO"))
Help, Thanks
 
 

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi leanardo9203,

I see your number is large and has decimals so make sure your variable is defined as a Double and use the ActiveRecord.GetNumValue.  I am assuming that the field is numeric if not let me know and we can try something else:

Dim MontosValor as Double

This should capture the number properly.  The number is too large for long.

leonardo9203
Offline
Joined: 04/17/2018 - 16:54

hello, It worked, thank you very much, changing the variable by double and as NUM
Dim MontosValor as Double

  • ActiveRecord.GetNumValue

Thank you

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Glad I could help.