Hi,
I have a Notes and SQL question and hope someone can help.
We are moving to a new platform and SQL server for some Notes apps but I still need to connect to SQL tables from Notes to pull in data for dialog lists in existing Notes apps.
Using ADODB, I am successfully connecting to the SQL table and adding column 1 of every row into an array.
Total SQL rows is currently 5175.
I am using Workspace.Prompt (OKCANCELLIST) to display my array and make a selection.
This all works fine and I am able to capture the selection.
However, if there are more than 2695 elements in my array, the prompt fails to display. And I am a bit baffled as to why.
Does anyone have any ideas as to what might be going wrong … ?
Any help and advice greatly received.
Is this perhaps a limitation for an array … ?
I’ve tried similar thing using a list and while the list populates ok, it doesn’t show anything in my dialog other than 1 entry of odd characters.
I declared my list as ‘Dim myList List As String’ as per the help.
Sample dialog code …
ws.Prompt ( PROMPT_OKCANCELLIST, “ABC”, “DEF”, “”, myList )
If I code it like this …
ws.Prompt ( PROMPT_OKCANCELLIST, “ABC”, “DEF”, “”, myList ( 1 ) )
… the dialog does indeed display the first entry in my list. But I want them all … !!
Many thanks
Andy