problem when using "Group by" statements with resultsets...

From: JP Estrada via JavaKB.com (forum_at_JavaKB.com)
Date: 03/18/05 

Date: Thu, 17 Mar 2005 23:00:48 GMT

hi guys...why do i get an "invalid cursor state" error when i execute a
query with a group by? the query works fine in MS Access but when i use it
with a resultset, it gives that error....thanks... 

-- 
Message posted via http://www.javakb.com

Relevant Pages

  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)
  • Re: UPDATE query in Access 2003 raising error
    ... Runtime error 3066 Query must have at least one destination field. ... The SQL works fine if I use it in the QBF Design mode. ... Set qdfTemp = db.CreateQueryDef ... Elsewhere in the code I use the same technique to execute an SQL ...
    (microsoft.public.access.formscoding)
  • Re: Primary Key Violation Error Message
    ... I should have read your query more carefully. ... > Dim ws As DAO.Workspace 'Current workspace (for transaction). ... > 'Step 2: Execute the append. ...
    (microsoft.public.access.formscoding)