Dear All
I hv a multi value field in my form, which get s the dates of a perticular emplyees travelling dates
flddate
1 22/04/2008
2 24/04/2008
3 25/04/2008
I get this “flddate” to a view column it comes like this
22/04/2008,24/04/2008,25/04/2008 this is the way i need
the problem is i run a report it contains this field
location dates Amount
xx - 20
when i press update report multivalu fields get the relavant data (location,Amount) but the dates not get updated
this error msg comes “Notes error-Arraya of Arrays are not supported”
how can i get the dates to this field
Please help if this is not clear i will send the cording
Thankx in advance
Niluki
Subject: Multi value field does not get loaded
Is a Lotusscript function? If so… please post the code.
I think the error message is giving you a good indicator of what is wrong.
Subject: RE: Multi value field does not get loaded
thankx for the responce yes its a lotus script
I hv put a line of astrics to show the pls where i get the error
Sub Click(Source As Button)
Dim workspace As New NotesUIWorkspace
Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim column As NotesViewColumn
Dim doc1 As NotesDocument
Dim doc2 As NotesDocument
Dim uidoc As NotesUIDocument
Dim doc As NotesDocument
Dim tot As Integer
Dim i As Integer
Set uidoc=workspace.currentdocument
Set doc = uidoc.document
Set db = session.CurrentDatabase
Set view = db.GetView("vwAppbearer" )
Tempbearer=doc.RptBearer
Set doc2 = view.GetfirstDocument
i=0
Do While Not(doc2 Is Nothing)
Bearer = doc2.ColumnValues(0)
Do While doc.RptBearer(0)= Bearer
Redim Preserve indexarr(i) As Integer
Redim Preserve datearr(i) As String
Redim Preserve typearr(i) As String
Redim Preserve dateranarr(i) As Variant
Redim Preserve Amtarr(i) As Integer
Redim Preserve remarr(i) As String
dat=doc2.ColumnValues(1)
Dest=doc2.ColumnValues(2)
period=doc2.ColumnValues(3)
amt=doc2.ColumnValues(4)
'period1=Cstr(period)
datearr(n) = dat
typearr(n)= Dest
dateranarr(n)=period
Amtarr(n) = amt
remarr(n)="Pd"
n=n+1
i=i+1
doc.Rptdate = datearr
doc.Rpttype= typearr
****************** doc.Rptdaterang= dateranarr
doc.RptAmount = Amtarr
doc.Rptremarks= remarr
Set doc2 = view.GetNextDocument(doc2)
If (doc2 Is Nothing)Then
Bearer= " "
Else
Bearer= doc2.ColumnValues(0)
End If
Loop
If Not(doc2 Is Nothing)Then
Set doc2 = view.GetNextDocument(doc2)
End If
Loop
doc.SaveOptions =1
uidoc.save
Call uidoc.refresh
Subject: RE: Multi value field does not get loaded
any clue pls
Subject: RE: Multi value field does not get loaded
While debugging your code, see what’s in the variable period after
period=doc2.ColumnValues(3)
If it is an array, then dateranarr would be an array of arrays, which you cannot write back to a field. What do you expect to be written to doc.Rptdaterang?
Subject: RE: Multi value field does not get loaded
yr right it contains an array, i want to hv a date range to the doc.daterange field. eg:-
person name date he/she has travelled place amt
22/04/2008,23/04/2008
how can i get that array to this feild