pro*c question not running sql
From: sac <sachin.dhall_at_gmail.com>
Date: 23 Jan 2006 12:58:46 -0800
Message-ID: <1138049926.467012.230930_at_g43g2000cwa.googlegroups.com>
EXEC SQL INCLUDE SQLCA;
#include "stdio.h"
void main (void)
{
EXEC SQL BEGIN DECLARE SECTION;
char * uid ="SCOTT/TIGER";
int x=0;
EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT :uid;
printf("Connected as ....%s",uid);
[Quoted] [Quoted] EXEC SQL select sal into :x from emp where empno=7369; printf("..%d",x):
}
Date: 23 Jan 2006 12:58:46 -0800
Message-ID: <1138049926.467012.230930_at_g43g2000cwa.googlegroups.com>
EXEC SQL INCLUDE SQLCA;
#include "stdio.h"
void main (void)
{
EXEC SQL BEGIN DECLARE SECTION;
char * uid ="SCOTT/TIGER";
int x=0;
EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT :uid;
printf("Connected as ....%s",uid);
[Quoted] [Quoted] EXEC SQL select sal into :x from emp where empno=7369; printf("..%d",x):
}
it compiles fine and makes the exe...no errors...
it shows the output as "Connected as ....SCOTT/TIGER..0" it is i [Quoted] think not executing the select statement ,i have tried selecting many other things same problem.....could you help please... Received on Mon Jan 23 2006 - 21:58:46 CET