-
Thanks, that's the route I ended up taking after looking it over again to make sure it would fit. I really appreciate all the support, and the raw SQL support, among many other updates, in this release.
-
I have a dynamic query with a hierarchical object model where we want to order records by the parent sort if it is a parent record, otherwise use a child sort. The query I have is this: Code: SELECT eme.[EMEntityID] , eme.[EMEntityCode] , eme.[EMEntityName] , eme.[Active] , ens.[EMEntityParentID] , eme.[ShowOrder] , p.[ShowOrder] AS 'ParentsShowOrder
-
I'm using the esDataSource for binding information to a GridView. I have a dynamic query which pulls from a base object and joins to additional tables, summing some of the information and calculating certain columns. Everything had been working fine until I began testing the sort on the grid. The columns I added sort correctly, but the columns which
-
That makes sense. I'm definitely in favor of the solution you're put together, instead of using a generic Object.
-
Trust me, I'm not trying to be difficult, but how did this work before this release? It wasn't a problem in the past, and I'd have thought you would have already had to handle this situation. Though I expect it's a change cause by implelenting the new DynamicQuery.
-
Thanks for looking into this and coming up with a quick solution. We'll definitely use the service update, even though we already have made the changes in the few places it's affected.
-
I'll go with using the .Value for now. It's so odd because it wasn't a problem in the past. Thanks for the quick reply.
-
I'm in the process of upgrading our current ES objects to the latest ES2009 Q3 (2009.2.0928.0). I figured out that I now need to include the DynamicQuery.dll which fixed most issue. Now in my implementation I get the following error: Error 6 Operator '=' is not defined for types 'EntitySpaces.DynamicQuery.esQueryItem' and 'Integer?'. This was working
-
I'm working on a query to compare a string to my varchar field in the database. I want to replace certain characters, such as a dash "-" (really remove the dash). My SQL looks something like this: Code: SELECT * FROM qual WHERE REPLACE (qual.QualNumber, '-' , '' ) = REPLACE (@Number, '-' , '' ) I can't figure out a way to do this with the dynamic query
-
Thanks for you help. In the end it was related to corrupt files in my machine, and the problem had just begun maifesting itself through EntitySpaces. After a quick rebuild everything is working perfectly. I appreciate you looking into the problem, and even searching google a bit and sending over the link.