by [Sorry, I forgot to send this message to the newsgroup]
Hi,
It doesn't return any value at all. The recordset Open function (SELECT)
raises an exception that can be
detected using a try/except block. How can I get more info about the
problem?
It happens during normal execution: database connection is open and working
(before and after)
properly so it is not any of the problems you mention.
My app opens a connection to database during startup and close it when
terminates. It does many
operations on this connection correctly except in the case I've explained.
If, as resulting of the normal
use of the program, more records are inserted into the table problem
disappears.
An important clue: Server SQL CE 1.1 goes where 2.0 fails!
This SELECT works well in SQL Server 8.0 too.
Hope this helps.
Miguel.
Newsgroups: microsoft.public.sqlserver.ce
Sent: Thursday, February 27, 2003 5:42 PM
Subject: Re: SQL Server CE 2.0: Possible bug?
> Hi Miguel,
> That is not much help. If it fails during the open, you will get an
HResult.
> Look at the SQLCE Books on line for Error Handling.
> Couple of common Open problems.
> 1. Database does not exist or path issue.
> 2. Database in use.
> 3. Wrong provider.
> 4. Provider not installed.
> --
> Brad
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> > My app traps an exception (using try/except block) during Open
> > (ADOCE.Recordset.3.1 interface).
> > Unfortunately, ADOCE 3.1 is unable to return an error description where
> 3.0
> > could.
> > Using Isqlw20.exe wait cursor lasts for ever and no results are
generated
> > but it doesn't hang up.
> > Let me know if you need more details.
> > Thanks.
> > > Hi Miguel,
> > > Your query works for me however I do not have your table schema, but
> made
> > up
> > > my own.When you say an exception, does it give an error, does the
> > > application have an Access Violation and ISQLW20 crash?
> > > If it is an error, then read the whole error string and determine the
> > > problem or post here.
> > > --
> > > Brad
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > I got an exception while retrieving COUNT(*) in a SELECT with a
> subquery
> > > and
> > > > a GROUP BY clause from a
> > > > table having only one record.
> > > > Either using isqlw20.exe...
> > > > Here is the actual sentence:
> > > > SELECT COUNT(*) FROM RESUMEN_VISITA WHERE DATVISIT='20030225'
> > > > AND (CODCLIE IN (SELECT CODCLIE FROM CLIENTES_SUCURSALES
> > > > WHERE ((T4CAMPO7='0017' AND DIA_VISITA LIKE '1______'))))
> > > > GROUP BY CODCLIE
> > > > Any idea?