|
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 04/11/2006 10:06:57 AM
Posts: 13, Visits: 49 |
| | 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
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:23:48 AM
Posts: 4,366, Visits: 4,392 |
| | Rob, I am going to attempt to recreate this and I will get back with you. Thanks. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:23:48 AM
Posts: 4,366, Visits: 4,392 |
| | 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? |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 04/11/2006 10:06:57 AM
Posts: 13, Visits: 49 |
| | 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.
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:23:48 AM
Posts: 4,366, Visits: 4,392 |
| 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  |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:23:48 AM
Posts: 4,366, Visits: 4,392 |
| | 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. |
| |
|
|