C to SQL Connentivity

[DarkSorrow38]

I have written a C program to insert a row in SQL Server 2000 but it seems not to work.

#include<stdio.h>
#include<conio.h>

int main(void)
{
int number;
char fname[80], lname[80];
clrscr();
printf("Enter a number : ");
scanf("%d",&number);
printf("Enter your first name : ");
scanf("%s",fname);
printf("Enter your last name : ");
scanf("%s",lname);
execl sql include sqlca;
execl sql insert into Table1
values(number,",'",fname,"','",lname,"'");
getch();
return 0;
}

[Lost User]

Ishaan Karnik wrote:

I have written a C program to insert a row in SQL Server 2000 but it seems not to work.

Could you explain what it is that does not work?

[DarkSorrow38]

The error i recieve while compiling

Compiling ..\SOURCE\SQL.C
Error ..\SOURCE\SQL.C 15: Undefined symbol 'execl'
Error ..\SOURCE\SQL.C 15: Statement missing ;
Error ..\SOURCE\SQL.C 16: Statement missing ;

[Lost User]

Ishaan Karnik wrote:

Undefined symbol 'execl'

Well I guess there is no such command in the C language!

[DarkSorrow38]

I have taken the command from SQL The Complete Reference.

[Lost User]

It looks like unix command line codes instead of C, but maybe that's just me

[Lost User]

Harold (above) is correct, these are Unix commands, so unless you are compiling in a UNIX system they will not be recognised. What exactly does the SQL book say about this?

[David Crow]

Ishaan Karnik wrote:

execl sql include sqlca; execl sql insert into Table1 values(number,",'",fname,"','",lname,"'");

See here.

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons