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