StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » SqlException Using BrowseDialog

SqlException Using BrowseDialog

Robert Linton — Wed, 22 Mar 2006 11:00:32 GMT

Please see attached.

I can successfully load my BO manually, however, I'm getting an SqlException when I attempt to search for a range of records, by date, using a BrowseDialog.

Any clues?

TIA,

Rob

RE: SqlException Using BrowseDialog

Trent L. Taylor — Wed, 22 Mar 2006 11:00:32 GMT

The issue ended up being the Maximum number of records returned was set to -1 and since SQL Server does not support a "TOP -1" an error was generated. The BrowseDialog has been changed to prevent this from happening in the future.

RE: SqlException Using BrowseDialog

Trent L. Taylor — Fri, 17 Mar 2006 16:44:52 GMT

Is there anyway you could send me the database (structure) so I could reproduce the problem? Just email me directly if you would like. You can just create an script through SQL Server Management Studio if you would like which will make it very easy for me to create the exact structure on my server for reproducing the error. Thanks :)

RE: SqlException Using BrowseDialog

Robert Linton — Fri, 17 Mar 2006 16:33:15 GMT

MSSQL 2005

field name is date_added, type = datetime

To setup the search fields, I used the search fields dialog via the SearchFields propery on my BrowserDialog object. See attached.

RE: SqlException Using BrowseDialog

Trent L. Taylor — Fri, 17 Mar 2006 16:19:55 GMT

Rob,

I cannot reproduce this error. It looks as though the value of the date is invalid when passed to the parser. What database are you connecting to and what is the date field that you are using in your search criteria? Also, one last thing, how did you setup the search fields?

RE: SqlException Using BrowseDialog

Trent L. Taylor — Fri, 17 Mar 2006 11:08:14 GMT

Rob,

I am going to attempt to recreate this and I will get back with you. Thanks.