#1  
Old 1st August 2014, 06:38 AM
John Myren
 
Posts: n/a
Default Error when configuring datasource in VS2012 - Index was out of range

Hi,

NX Server 4.0005

Visual Studio 2012, Configure SQLDataSource

Select Connection String -> Next
Specify a custom SQL Statement -> Next
Enter the following SQL Statement: SELECT Id, ParentId, "Name", "Text",
NavigateUrl FROM "MenuItems" ORDER BY ParentId, Sorting -> Next
Test Query

Error message: Index was out of range. Must be non-negative and less than
the size of the collection. Parameter name: index

The Query works just fine in EM.

If I use the following SQL Statement, everything works fine: SELECT * FROM
"MenuItems" ORDER BY ParentId, Sorting

Is this a bug?

John

--
Using Opera's mail client: http://www.opera.com/mail/


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Index was out of range John Myren nexusdb.public.support.adoprovider 4 28th July 2014 11:10 PM
EM 3.06 Range Check error Tred nexusdb.public.support 2 22nd December 2010 12:19 PM
Field Index out of range Martin Boegel nexusdb.public.support.sql 1 22nd April 2007 09:38 AM
Range check error Jan Declercq nexusdb.public.support 3 24th August 2006 10:34 AM
Out of range error Brian Cahill nexusdb.public.support.sql 4 14th November 2005 12:31 PM


All times are GMT +11. The time now is 09:56 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.