What does this mean? To embed SQL?Quote:> For some reason I can't figure this out yet. I need to be able to
> through an access database and return a result based upon certain
> requirements (ie number of lab hours for a particular student in a
> particular lab room). Now, if I embed SQL, this should be quite easy.
> However, I can't figure out how to embed SQL yet. But if someone knows
> another way where I can do it without having me embed SQL, that would
> fine too. As long as I get it done before class in 8 hours (It's 9:40
> PST now). Thanks! :-)
Sent via Deja.com http://www.deja.com/
Before you buy.
I need some help on a problem that I encountered recently. On a VMS
machine I was running an application that had some embedded Ingres
SQL Select statements. The actual statements were as following:
SELECT COUNT(*) FROM EMPLOYEES;
SELECT COUNT(DISTINCT ENAME) FROM EMPLOYEES;
While the first statement returned data back to the application, the
second statement(with count(distinct ename)) returned an error message
indicating that no grant or grant equivalent statement was given to the
It actually did not matter which statement executed first. The error
message always went with the select statement with "count(distinct
ename)" clause. I used a debugger on VMS to check the preparation and
description processes for both select statements, and could not find out
any difference and they were ok. The odd thing was that both statements
ran ok in the interactive Ingres SQL environment.
Could some one on the net point to me where the problem could be? Any
help will be appreciated. Thanks in advance!