Access violationn in msjet40.dll

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Marko Krizmanic Thu, 22 Sep 2005 09:52

#593

Author: Marko Krizmanic
Date: Thu, 22 Sep 2005 09:52

11 lines
1236 bytes

When I try to execute TADOQuery with SQL llike this:
SELECT COUNT(*) FROM TABLE

I got exception  Access violation at address xxxxxx in module 'msjet40.dll'

But if I put SQL in two lines like this:
SELECT COUNT(*)
FROM TABLE
Everything is OK ?

Does this have sense ??

Re: Access violationn in msjet40.dll

#595

Author: Nigel
Date: Thu, 29 Sep 2005 13:51

22 lines
1513 bytes

Try the following

SELECT COUNT(*) AS RECORDCOUNT FROM TABLE


"Marko Krizmanic" <marko.krizmanic@fer.hr> wrote in message 
news:43327ee3$1@newsgroups.borland.com...
> When I try to execute TADOQuery with SQL llike this:
> SELECT COUNT(*) FROM TABLE
>
> I got exception  Access violation at address xxxxxx in module 
> 'msjet40.dll'
>
> But if I put SQL in two lines like this:
> SELECT COUNT(*)
> FROM TABLE
> Everything is OK ?
>
> Does this have sense ??
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads