Setting a field value with lotusscript

I can set the value of a text field to any string using "FieldSetText". How do i set the value of a numeric field?

I have a variable, type double, i want to set a field equal to this.

Dim aDouble As Double
aDouble = 1
Call uidoc.FieldSetText("MyField", aDouble)?





      
LVL 1
roosterupAsked:
Who is Participating?
 
andyDaleConnect With a Mentor Commented:
I am wandering why you regected the privious answer, it is the way to do it. You'll need to set the value throught the back-end, the front-end only has text methods. I would agree that the .save is overkill as a simple uidoc.refresh would bring your backend change into the UI without having to save the document:

Dim doc as NotesDocument
set doc = uidoc.document
doc.MyField = daInt
uidoc.refresh

if you don't like the abrieviated field assignment method try

call doc.replaceItemValue("myField",daInt)
0
 
amit_duttaCommented:
Hi roosterup,

All u need to do is:-

Dim doc as NotesDocument
set doc = uidoc.document
doc.MyField = aDouble
doc.Save(False,True)

This should serve ur purpose.
0
 
roosterupAuthor Commented:
Adjusted points from 10 to 30
0
 
roosterupAuthor Commented:
Dim aString As String
Dim aDouble As Double
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim res As New ODBCResultSet
Dim WS As New notesUIWorkspace
Dim uidoc As NotesUiDocument
Set uidoc = ws.currentdocument
status=Con.ConnectTo("","","")
Set qry.Connection = Con
Qry.SQL = "sql statement"
Set Res.Query = Qry
Res.Execute

aString=res.getvalue("I00AMM")
Call uidoc.FieldSetText("month"aString)

I have to set aString to a number so a data conversion takes place, then use fieldsettext to get the text into the field. how can i just set a field equal to an integer value?

res.getvalue("I00AMM") is an int, how do i set a number field to this value?
0
 
roosterupAuthor Commented:
This works, but i don't understand why some of the other fields I have assigned a text value using Call uidoc.FieldSetText will have thier values erased.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.