Possible bug with dynamic arrays in v8.5.3
Has anyone else experienced this issue?….. I need to append rows to a MS sql table. This works fine for a fixed size array, for example: Dim newfielddata(10) as String ****** set values, etc……. Set field = fields.Append(“CYL_SN”, LCTYPE_TEXT) field.Value = newfielddata but the array values are not passed (nor any error message) when i [...]
Answer Question
| November 13, 2012 3:16 PM
Lotus Domino Designer, LotusScript
Has anyone else experienced this issue?….. I need to append rows to a MS sql table. This works fine for a fixed size array, for example: Dim newfielddata(10) as String ****** set values, etc……. Set field = fields.Append(“CYL_SN”, LCTYPE_TEXT) field.Value = newfielddata but the array values are not passed (nor any error message) when i [...]
Answer Question
| November 13, 2012 3:16 PM
Lotus Domino Designer, LotusScript
Error Message when running Lotus Script Agent
I am running an agent that creates a daily document. In the view for the document, I am receiving the following error message: ERROR: Incorrect data type for operator or @function: Number expected. My document has a date field and a numeric field. When I look at the view, the date field is fine, but [...]
Answer Question
| October 12, 2012 5:11 PM
LotusScript
I am running an agent that creates a daily document. In the view for the document, I am receiving the following error message: ERROR: Incorrect data type for operator or @function: Number expected. My document has a date field and a numeric field. When I look at the view, the date field is fine, but [...]
Answer Question
| October 12, 2012 5:11 PM
LotusScript
Error Message when running Lotus Script Agent
I am running an agent that creates a daily document. In the view for the document, I am receiving the following error message: ERROR: Incorrect data type for operator or @function: Number expected. My document has a date field and a numeric field. When I look at the view, the date field is fine, but [...]
Answer Question
| October 12, 2012 2:32 PM
LotusScript
I am running an agent that creates a daily document. In the view for the document, I am receiving the following error message: ERROR: Incorrect data type for operator or @function: Number expected. My document has a date field and a numeric field. When I look at the view, the date field is fine, but [...]
Answer Question
| October 12, 2012 2:32 PM
LotusScript
How can I detach an xxx.exe file in a Windows 7 environment with UAC?
I want to distribute a compiled AutoIT script via a Notes database to PCs running Windows 7 and UAC. [1] Are there “safe” folders into which an executable can be detached so that it can be executed later via a Shell statement? [2] Is there any way to prevent the user from having to deal [...]
Answer Question
| August 10, 2012 10:10 PM
Detach, LotusScript, UAC, Windows 7
I want to distribute a compiled AutoIT script via a Notes database to PCs running Windows 7 and UAC. [1] Are there “safe” folders into which an executable can be detached so that it can be executed later via a Shell statement? [2] Is there any way to prevent the user from having to deal [...]
Answer Question
| August 10, 2012 10:10 PM
Detach, LotusScript, UAC, Windows 7
calling shell function in schedule agent
i have lotus notes agent code which is working fine when we run manually but its not working in scheduled agent my code below: Sub Initialize On Error Resume Next pathName$ = “E:SFTP” ‘Pathname should contain the flatfile location fileName$ = Dir$(pathName$, 0) If fileName$ = “” Then Messagebox “**There are no files to upload**” [...]
Answer Question
| April 25, 2012 10:17 AM
Lotus Notes, LotusScript
i have lotus notes agent code which is working fine when we run manually but its not working in scheduled agent my code below: Sub Initialize On Error Resume Next pathName$ = “E:SFTP” ‘Pathname should contain the flatfile location fileName$ = Dir$(pathName$, 0) If fileName$ = “” Then Messagebox “**There are no files to upload**” [...]
Answer Question
| April 25, 2012 10:17 AM
Lotus Notes, LotusScript
Lotus notes @mailsend as lotusscript
I have a form with the following fields:- Form Name: leasetracemail ltto (text) ltcc (text) ltfbcc (text) ltsubject (text) ltbody (rich text) trailer(text) the rich text field can contain attachments and I am tryinmg to use the @mailsend as follows: @MailSend(ltto;ltcc;ltbcc;ltsubject;”";ltbody:trailer); However @mailsend does not work with rich text fileds for attachments. I beleive that [...]
Answer Question
| March 13, 2012 10:05 PM
Lotus Domino, Lotus Notes, LotusScript
I have a form with the following fields:- Form Name: leasetracemail ltto (text) ltcc (text) ltfbcc (text) ltsubject (text) ltbody (rich text) trailer(text) the rich text field can contain attachments and I am tryinmg to use the @mailsend as follows: @MailSend(ltto;ltcc;ltbcc;ltsubject;”";ltbody:trailer); However @mailsend does not work with rich text fileds for attachments. I beleive that [...]
Answer Question
| March 13, 2012 10:05 PM
Lotus Domino, Lotus Notes, LotusScript
lotus domino
friends in lotus notes every time after maintanance were are getting the application problem i.e application which we are using is not running properly after some instance i found the solution that is deleting the index xxx.ft and creating the index after that if we start application it working…
Answer Question
| February 28, 2012 11:27 PM
Lotus Domino 6.5.3, LotusScript
friends in lotus notes every time after maintanance were are getting the application problem i.e application which we are using is not running properly after some instance i found the solution that is deleting the index xxx.ft and creating the index after that if we start application it working…
Answer Question
| February 28, 2012 11:27 PM
Lotus Domino 6.5.3, LotusScript
Removing a document link
I have a notes application in which users can open request tickets to have work performed. They also have the ability to create subrequests or the original ticket. When this is done, a document link is created in the original ticket that links to the subrequest. The problem is that for some reason, some of [...]
Answer Question
| February 28, 2012 8:55 PM
LotusScript, NotesRichTextLink, Remove Link
I have a notes application in which users can open request tickets to have work performed. They also have the ability to create subrequests or the original ticket. When this is done, a document link is created in the original ticket that links to the subrequest. The problem is that for some reason, some of [...]
Answer Question
| February 28, 2012 8:55 PM
LotusScript, NotesRichTextLink, Remove Link
LotusScript to determine Notes client running mode
I have a requirement for some lotusscript which will identify if Notes 8.x is running in Standard or Basic mode.
Answer Question
| April 5, 2012 2:38 PM
LotusScript
I have a requirement for some lotusscript which will identify if Notes 8.x is running in Standard or Basic mode.
Answer Question
| April 5, 2012 2:38 PM
LotusScript
Copy/Clone a selected document to a new document including richtext field, e.g.
How to copy/clone a selected document to a new document including richtext field, “Body”, which has a DocLink and then put the new document in frount end edit mode
Answer Question
| October 31, 2011 4:08 PM
LotusScript
How to copy/clone a selected document to a new document including richtext field, “Body”, which has a DocLink and then put the new document in frount end edit mode
Answer Question
| October 31, 2011 4:08 PM
LotusScript
Updating Field Default Values With An Agent v7.5
I have a form with total fields that derive their value from a @Sum(DBLookup) default value formula. The totals update whenever the form is opened. However, I want to update the totals WITHOUT opening the form. I tried the following code in an agent with no success. Can this be done? Set viewC = db.GetView”(StudentProfs)”) [...]
Answer Question
| March 31, 2012 7:43 PM
Lotus Domino, Lotus Domino development, LotusScript
I have a form with total fields that derive their value from a @Sum(DBLookup) default value formula. The totals update whenever the form is opened. However, I want to update the totals WITHOUT opening the form. I tried the following code in an agent with no success. Can this be done? Set viewC = db.GetView”(StudentProfs)”) [...]
Answer Question
| March 31, 2012 7:43 PM
Lotus Domino, Lotus Domino development, LotusScript
Detecting MS excel is open in Citrix via Lotus Script
I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel [...]
Answer Question
| March 31, 2012 3:22 PM
Citrix, Excel.Application, Lotus Notes 6.x, Lotus Notes Database, LotusScript
I have an application that generates graphs using excel from data stored in a Lotus Notes Database. Once the graphs are created in excel,they are copied and pasted into a Rich Text Field in Lotus notes which is then displayed to the user so that the user never sees excel at all. However. If excel [...]
Answer Question
| March 31, 2012 3:22 PM
Citrix, Excel.Application, Lotus Notes 6.x, Lotus Notes Database, LotusScript
QueryOpen event in Lotus Notes
If I am creating a response document that inherits values from an existing document. Do the computed When Composed fields expose their values in this event so that I can access them via lotuscript in the QueryOpen Event. What I’m planning to do is to ensure that only one editable document of a particular form type [...]
Answer Question
| March 31, 2012 3:44 PM
Lotus Notes, Lotus Notes 6.x, LotusScript, QueryOpen
If I am creating a response document that inherits values from an existing document. Do the computed When Composed fields expose their values in this event so that I can access them via lotuscript in the QueryOpen Event. What I’m planning to do is to ensure that only one editable document of a particular form type [...]
Answer Question
| March 31, 2012 3:44 PM
Lotus Notes, Lotus Notes 6.x, LotusScript, QueryOpen
Adding Signature to memo via LotusScript
I am trying to create a memo via LotusScript, insert some common language with a doc link and extra lines, apply the Signature from CalendarProfile. I have also attempted to use stationary with no luck. Any thoughts would be appreciated. Then I open the doc up in UI so the client can add more text [...]
Answer Question
| March 31, 2012 2:34 PM
Lotus Notes 8.5.2, Lotus Script, LotusScript
I am trying to create a memo via LotusScript, insert some common language with a doc link and extra lines, apply the Signature from CalendarProfile. I have also attempted to use stationary with no luck. Any thoughts would be appreciated. Then I open the doc up in UI so the client can add more text [...]
Answer Question
| March 31, 2012 2:34 PM
Lotus Notes 8.5.2, Lotus Script, LotusScript
Buttons in Lotus Notes – Help Please
Hi, Im trying to make buttons more useful in a questionnaire to 2000 people there’s 3 options i want it to be restricted to the user pressing a button once and the email closes, However the 3rd button which is …msg required justification.i would like to open a comment box or a reply email for [...]
Answer Question
| March 31, 2012 1:39 PM
Lotus Notes, Lotus Notes 8.5, Lotus Notes administration, LotusScript
Hi, Im trying to make buttons more useful in a questionnaire to 2000 people there’s 3 options i want it to be restricted to the user pressing a button once and the email closes, However the 3rd button which is …msg required justification.i would like to open a comment box or a reply email for [...]
Answer Question
| March 31, 2012 1:39 PM
Lotus Notes, Lotus Notes 8.5, Lotus Notes administration, LotusScript
How to parse text from a file and paste results into stationery in Notes 6.5
Hello, I’m new to Lotusscript and have a question that probably won’t be too difficult for a seasoned script writer. Every day I have to get the first three lines from a log file and paste them into a stationery form and email it out. The log file is a basic text file and the [...]
Answer Question
| March 31, 2012 4:12 AM
Lotus Notes, Lotus Notes Script, LotusScript, Parsing
Hello, I’m new to Lotusscript and have a question that probably won’t be too difficult for a seasoned script writer. Every day I have to get the first three lines from a log file and paste them into a stationery form and email it out. The log file is a basic text file and the [...]
Answer Question
| March 31, 2012 4:12 AM
Lotus Notes, Lotus Notes Script, LotusScript, Parsing
Lotus Forwarding Agent
Hi there I am trying to get a LotusScript agent to forward an email and although it runs without any error messages, the email doesn’t arrive at the designated address, and there is nothing in the sent-mail box. Sub Initialize() Dim s As New NotesSession Dim db As NotesDatabase Dim view As NotesView Dim doc [...]
Answer Question
| March 31, 2012 3:52 PM
Lotus Notes, Lotus Notes 8.5.1, Lotus Notes Script, LotusScript
Hi there I am trying to get a LotusScript agent to forward an email and although it runs without any error messages, the email doesn’t arrive at the designated address, and there is nothing in the sent-mail box. Sub Initialize() Dim s As New NotesSession Dim db As NotesDatabase Dim view As NotesView Dim doc [...]
Answer Question
| March 31, 2012 3:52 PM
Lotus Notes, Lotus Notes 8.5.1, Lotus Notes Script, LotusScript
Pulling additional data fields along with the primary field in a DBColumn lookup.
I’m a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question. I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. [...]
Answer Question
| February 24, 2011 5:25 PM
Domino Designer, Lotus Domino, Lotus Notes, Lotus Notes Formulas, LotusScript
I’m a newbie to Domino and Lotus Designer, and am loving the seemingly inexhaustable flexibility and power that Domino has to offer. But I was wondering if someone could help me with what is probably a very simple question. I have created two Notes databases on the same server. Addresses.nsf contains static customer contact information. [...]
Answer Question
| February 24, 2011 5:25 PM
Domino Designer, Lotus Domino, Lotus Notes, Lotus Notes Formulas, LotusScript
Handle documents using Lotus Script.
How to get handle of first 10 documents in view (Suppose if there are around 1000 or more documents) using Lotus Script? Thanks, Sunny
Answer Question
| June 6, 2011 4:32 PM
Lotus Notes, Lotus Notes View, Lotus Script, LotusScript
How to get handle of first 10 documents in view (Suppose if there are around 1000 or more documents) using Lotus Script? Thanks, Sunny
Answer Question
| June 6, 2011 4:32 PM
Lotus Notes, Lotus Notes View, Lotus Script, LotusScript
Need to do Conditional Redirects in Lotus Domino
I need to detect the host_name of users hitting my public site as the page loads, then redirect certain host_names to different URLs as appropriate. The redirects will be in my application, not on the server itself. I speak LotusScript fluently and a little Javascript. Thanks! Mike
Answer Question
| February 22, 2011 2:15 PM
Conditional values, Java, LotusScript, LotusScript conditional statements, Redirects
I need to detect the host_name of users hitting my public site as the page loads, then redirect certain host_names to different URLs as appropriate. The redirects will be in my application, not on the server itself. I speak LotusScript fluently and a little Javascript. Thanks! Mike
Answer Question
| February 22, 2011 2:15 PM
Conditional values, Java, LotusScript, LotusScript conditional statements, Redirects
