Detail View Error: "Could not get count of records in query. Success "

[leetv]

Anyone know why i get this error when trying to open a detail from a grid...

Could not get count of records in query.
Success


Thanks
Lee

[christappan]

Re: Detail View Error: "Could not get count of records in query. Success "

I got the same error message the other day when I had built a grid on my development machine that included fields not yet in my app server machine SQL tables. Don't know if that'll help or not...

[cjsingh]

Re: Detail View Error: "Could not get count of records in query. Success "

Most likely you have an invalid field in the fields list of the grid or the detail or the search portion.

Check if you see a red message at the bottom of the fields list in grid/search/detail - 'Show Errors'.

I faced this and found that I have invalid fields in the fields list after I changed a field in my database (mySQL), maybe the name of the field.

[gilbertro]

Re: Detail View Error: "Could not get count of records in query. Success "

This often happens whenever I change my SQL definition by adding or removing other tables to the grid. Doing this can make field names become ambiguous and therefore has to 're re-qualified'. You can try removing the fields and adding them back. The proper qualifications will be assigned/updated.

[michael.wells@momentumweb]

Re: Detail View Error: "Could not get count of records in query. Success "

I had this issue when I swithed from a MySQL Table name to a MySQL View as my grid's data source. If you have a grid with a Detail View, make sure that your 'Table Alias' properites are defined properly for updatable fields.

Click: Detail View / Fields / Update Settings / Table Alias

Also, if you have any Table Aliases defined for Lookup fields, you may need to check those as well.

[leetv]

Re: Detail View Error: "Could not get count of records in query. Success "

Thanks for the info. I still sometimes get this. mostly i noticed that a field name is no longer present, or a tables is not named correctly (i.e. alias) as you've stated above.

thanks

lee

[leetv]

Re: Detail View Error: "Could not get count of records in query. Success "

This error has returned...
if i preview by clicking the desired browser from withing A5 then it shows just fine... once i publish and send to the web i get the error... Could not get count of records in query.
I've cleared the cache... check everything that you all posted.
any ideas?
Lee

[leetv]

Re: Detail View Error: "Could not get count of records in query. Success "

also, the query executes just fine when copied and pasted to MySQL (Navicat), and within the query builder...
I took out all the fields and put them back
nada!
ugh..
help!

[leetv]

Re: Detail View Error: "Could not get count of records in query. Success "

Never mind.. i fixed it... I completely did a huge ZIG when i should have ZAGGED!!! (along the lines of 'wrong grid')... thankfully no one wasted their time in posting..

[webzee]

Re: Detail View Error: "Could not get count of records in query. Success "

Please tell us your story of success.
I've been experiencing the same problem with odbc connection.
The databse is the same, on client and on server. Name of odbc connection is the same. Aliases are correct. Still have there "could not get"

[cFlat7]

Re: Detail View Error: "Could not get count of records in query. Success "

We just had this error and finally tracked down the issue:

-In the grid query we had a link to view that calculated a count and sum in a related table (for display in the grid).

-A new record would be added but when Alpha tried to redisplay the grid, the dreaded "Could not get count of records in query." appeared. We assume the message appeared because Alpha couldn't see it when trying to redisplay the newly created record,.

-Changing the join to the view to be a left-outer-join solved the problem.