Re: Embedded SQL Question..... Please help......

cmgray74_at_gmail.com wrote:
> All,
> I am trying to write a simple function that will allow a user to enter
> a Update query similar to the one below on the command line.
>
> Update person set personName = 'P0' Where personID = :placeHolder;
>
> I have written the following code to try and complete this task but I
> am having difficulty as I am new to Embedded SQL in C++;
>
> void Query::UpdateOption()
> {
>
> EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE error:");
>
> EXEC SQL BEGIN DECLARE SECTION;
>
> varchar username[UNAME_LEN]; // VARCHAR is an ORACLE supplied
> struct
> varchar password[PWD_LEN]; // varchar can be in lower case
> also
> varchar sql_statement[1000]; //holds the sql stat being
> constructed..
>
> int inputNumber;
>
> EXEC SQL END DECLARE SECTION;
>
> memset((char*)sql_statement.arr,'\0',1000);
>
> cout<<"Please Enter the Update Query String"<<endl;
> cin.getline((char *)sql_statement.arr,1000,';');
> cout<<endl;
>
> cout<<"Enter User Name "; cin>>username.arr;
> cout<<"Enter Password: "; cin>>password.arr;
>
> username.len = strlen((char *) username.arr);
> password.len = strlen((char *) password.arr);
>
> cout<<"Before Connection "<<(char *)username.arr<<" "<<(char
> *)password.arr<<endl;
>
> // CONNECTS TO DATABASE
> EXEC SQL CONNECT :username IDENTIFIED BY :password;
>
> int theLength = strlen((char*) sql_statement.arr);
> cout<<(char *)sql_statement.arr<<endl;
>
> sql_statement.len = theLength;
> cout<< "...Query is " <<endl<<(char *) sql_statement.arr << endl;
> cout<<endl;
>
> cout<<"Please Enter Number ";
> cin>>inputNumber;
> cout<<endl;
>
> EXEC SQL PREPARE q FROM :sql_statement;
>
> EXEC SQL WHENEVER NOT FOUND DO break;
>
> EXEC SQL EXECUTE q using :inputNumber;
>
> //EXEC SQL COMMIT work release;
>
> }
>
> Thanks for any help,
> Chris

I do not see a commit .... Received on Wed Oct 11 2006 - 23:04:46 CDT