Re: Pro*C Host arrays

ex :

varchar theDate[3][20];

strcpy (theDate[0].arr, "21/03/03");
theDate[0].len = strlen (theDate[0].arr); ...
nbRows = 1;

exec sql for :nbRows insert into TABLE (COL_DATE) values (to_date (:theDate, 'DD/MM/RR'));

...

"Brian Beld" <BB_at_nospam.com> a écrit dans le message de news: 2003321-163855-31456_at_foorum.com...
>
> Hello,
>
> In Oracle Pro*C/C++ docs, chapter 4, I have :
>
> struct
> {
> char emp_name[3][10];
> int emp_number[3];
> int dept_number[3];
> } emp_rec;
> ..
> strcpy(emp_rec.emp_name[0], "ANQUETIL");
> strcpy(emp_rec.emp_name[1], "MERCKX");
> strcpy(emp_rec.emp_name[2], "HINAULT");
> emp_rec.emp_number[0] = 1964; emp_rec.dept_number[0] = 5;
> emp_rec.emp_number[1] = 1974; emp_rec.dept_number[1] = 5;
> emp_rec.emp_number[2] = 1985; emp_rec.dept_number[2] = 5;
>
> EXEC SQL INSERT INTO emp (ename, empno, deptno)
> VALUES (:emp_rec);
>
> But how to insert a date field ?
> (how to do "TO_DATE(...)" like in a classic "INSERT INTO ... VALUES" ?)
>
> Thanks in advance.
> --
> Ce message a ete poste via la plateforme Web club-Internet.fr
> This message has been posted by the Web platform club-Internet.fr
>
> http://forums.club-internet.fr/
Received on Fri Mar 21 2003 - 11:37:01 CST