by Gerald Taylo » Fri, 11 Feb 2000 04:00:00
by Ciaran ONeil » Sat, 12 Feb 2000 04:00:00
What does this mean? To embed SQL?Quote:> For some reason I can't figure this out yet. I need to be able to
scroll
> 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
be
> fine too. As long as I get it done before class in 8 hours (It's 9:40
AM
> PST now). Thanks! :-)
Sent via Deja.com http://www.deja.com/
Before you buy.
1. Help needed on embedded sql statement
Hi Everyone,
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
table employees.
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!
Hong Wang
2. Cannot find Btrieve odbc driver
3. I need help using DATE functions in an INSERT in embedded SQL with C
4. C library for SQL calls on DOS
5. Need help: Loading Data with C and embedded SQL statements
7. Embedded COBOL/SQL Conversion from DB2 to Sybase Info/Help Needed
8. SQL Server Views in Access 2000
10. need help with programmatic assignment of Popup menu using TTreeView component
11. Need Imediate Help for Coding Assignment
12. Need help understanding assignment behaviour.
13. Compound Key Assignment - Help Needed On Syntax.