Hi,
Does anyone know if it's okay to have more than one embedded SQL
statement in a C function? (that is, besides commit or rollback, i.e.
multiple inserts, or multiple selects)
Thanks.
Teresa
by Teresa Ma » Thu, 12 Nov 1998 04:00:00
Does anyone know if it's okay to have more than one embedded SQL
statement in a C function? (that is, besides commit or rollback, i.e.
multiple inserts, or multiple selects)
Thanks.
Teresa
by Alan D. Mill » Sat, 14 Nov 1998 04:00:00
Somthing like:
static void Myfunct(void)
{
EXEC SQL
SELECT 'X' INTO :Myhost var FROM dual;
EXEC SQL
SELECT 'Y' INTO :AnotherHostVar FROM dual;
return;
is ok to do in Pro*CQuote:}
--
Alan D. Mills
>Does anyone know if it's okay to have more than one embedded SQL
>statement in a C function? (that is, besides commit or rollback, i.e.
>multiple inserts, or multiple selects)
>Thanks.
>Teresa
1. how can I embed a dll function as part of my SQL statement
I have a table (access-97) one of the column/field is
encrypted (using a algorithem written in C (in dll ).
is there anyway I can call the decrypt function as part of
SQL statment
for example:
SELECT ID, sEncryptedFld ,sKey from Table1 where
c_FunctionDecrypt(sEncryptedFld,sKey) like 'A%'
Note: c_FunctionDecrypt is inside a DLL file
C:\Windows\system\cEncrypt.DLL
Thanks
Stellus
2. Sequence - Use calculated start value?
3. multiple connections vs multiple statements on one connection
5. Interesting problem??? multiple COUNT(*) in one SQL statement
6. Random...
7. Condense multiple SQL Statements into one
8. sql question--multiple joiins in one statement
9. insert to multiple records in one SQL statement
10. SQL: Count Multiple Tables in One Statement
11. executing multiple SQL statements in one call
12. Execute multiple sql in one statement