db sh 17.Jun.11 12:37 AM a Web browser Applications Development7.0.3 FP1Windows XP
Hello all,
i am trying to generate a sequence number in document.but i want every time when user open a new form then counter value should be "0", and then when user saved the document then counter value should be increase by +1 from the hidden view column value, for example in first document Column value is "0",in second document value should be 2 , and so on but in new doc every document counter value will be shown as "0"
i am taking these steps :
1) one hidden field in the form "CountNumber" ,Number field,Editable,Default value"0".
2) one main field in the form where i can see the increment number "Number", this is number field and Computed ,Default value-"CountNumber"
3)Hidden view,One column name "Counter",Assign field value"CountNumber",Descending,Selection criteria "Main" form.
then i have written the code in querysave .
Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim doc As NotesDocument
Dim dblVar As Double
Dim varVar As Variant
Call source.Refresh
'---------------------------------------------------------
'Number Increment
'---------------------------------------------------------
If ( source.FieldGetText( "CountNumber" ) <> "0" ) Then
continue = True
Else
Set db = session.CurrentDatabase
Set view = db.GetView("hiddenview")
Return to top
number problem :( (db sh 17.Jun.11)
. . 
Print this page
