how to handle date in ESQL/C
Posted in 1995
Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL
Hi, I'm new this group and also new to ESQL/C. I have problem with the date field in the following program. When i execute this, i get sqlcode of 1205 which says, invalid month in date. How do i declare 'r_now' and 'r_date_needed' variables so that the esql accepts them. The values for r_now is 6/14/95 and r_date_needed is 7/13/95. Please help, appreciate it. jaswant -------------------- #include <stdio.h> $include sqlca; main (argc,argv) int argc; char *argv[]; { $char *r_req_no; $char *r_state ; $date *r_now; $date *r_date_needed; $char *r_fullname ; $char *r_login ; $char *r_cc ; $char *r_assigned ; $char *r_abstract; $database "//pyramid/request"; if ( argc < 9 ) { printf("%s\\n", "Usage: addreq <list of various fields>"); exit (0); } r_req_no=argv[1]; r_state=argv[2]; r_now=argv[3]; r_date_needed=argv[4]; r_fullname=argv[5]; r_login=argv[6]; r_cc=argv[7]; r_assigned=argv[8]; r_abstract=argv[9]; printf("r_req_no=%s\\n", r_req_no); printf("r_state=%s\\n", r_state); printf("r_now=%s\\n", r_now); printf("r_fullname=%s\\n", r_fullname); printf("r_login=%s\\n", r_login); printf("r_assigned=%s\\n", r_assigned); $insert into request (state, fullname, login, cc, assigned, abstract ) values ("$r_state", "$r_fullname", "$r_login", "$r_cc", "$r_assigned", "$r_abstract"); printf("sqlcode=%d\\n", sqlca.sqlcode); } -- +-----------------------------------------------------------------------------+ Jaswant S. Bhardwaj Ext: 2651 Development Engineering Computing Services Group