VARCHAR variable problem
From: Al Holloway <alh_at_tiger.avana.net>
Date: 1996/02/16
Message-ID: <4g0s6u$bnt_at_tiger.avana.net>#1/1
Date: 1996/02/16
Message-ID: <4g0s6u$bnt_at_tiger.avana.net>#1/1
Salutations to all,
char tdate[10];
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR countyName[16]; int cCode = code;
EXEC SQL END DECLARE SECTION;
EXEC SQL SELECT county_name INTO :countyName FROM system.county_mstr
WHERE county_id = :cCode;
getTodaysDate( tdate );
printf("\t\t\t\t\t\t\t\t%s\n",tdate);
printf("\n\n\n\t\t\tDISEASE SUMMARY\n");
printf("\n\nCOUNTY: ");
countyName.arr[countyName.len] = '\0';
printf("%s\n", countyName);
return;
}
Oracle7 Server 7.1.6, Pro*C 2.0.6 and Solars 2.4 is the environment I'm programming in.
All responses are appreciated.
Thanks,
Al Holloway
abh_at_ph.dhr.state.ga.us
alh_at_tiger.avana.net
Received on Fri Feb 16 1996 - 00:00:00 CET