Re: Need help in SQL,.. Please

This is what I have come up with regarding Quesion 4D

CODE #include <stdio.h>
#include <stdlib.h>
EXEC SQL INCLUDE sqlca;
Main()
{

    EXEC SQL BEGIN DELCARE SECTION;
    Struct couresType

            {
               String coure

    //To capture pre requiste
Int counter = 1;

    //To check the course for pre requiste Int number = 0;

    Char *username = "Manager";
    Char *password = "Manager";
    EXEC SQL END DECLARE SECTION; //Connect to database

    EXEC SQL CONNECT :username IDENTIFIED BY :password;     If (sqlca.sqlcode < 0) exit(-1);

//Establish SQL error handling, then declare cursor for selection

    EXEC SQL WHENEVER SQLERROR GOTO error;     EXEC SQL WHENEVER NOT FOUND GOTO done;

//Check for prerequisites of a COUSRE

    EXEC SQL DECLARE Check_Prerequisite CURSOR FOR SELECT [PREREQUISITE.PREREQUISITE-CID]
FROM COURSE, PREREQUISITE
WHERE COURSE.CID= :course AND COURSE.CID=PREREQUISITE.CID;

courseType course[10];

//Algorithm
counter = 1;
number = 0;
while (number<counter)
{
number++;
course[number];
EXEC SQL FETCH Check_Prerequisite INTO :number[counter] counter++;
while (@@FETCH_STATUS == 0)
{
  EXEC SQL FETCH Check_Prerequisite INTO :number[counter]   counter++;
}

if (@@FETCH_STATUS!=0)
{

   counter--;
}
}

//Display courses
Cout << "Pre requisite courses for " << course[1] << " are : " << endl;
For(i=2;i=<number;i++)
{

   Cout << course[i] << endl;
}

Error:

        Cout << "Error";
Done:

    EXEC SQL WHENEVER SQLERROR continue;     EXEC SQL CLOSE Check_Prerequisite;
    EXEC SQL COMMIT WORK RELEASE;
}

User is offlineProfile CardPM         

Report PostGo to the top of the page
Delete PostEdit Post+Quote Post Received on Mon May 22 2006 - 12:33:16 CDT