Can I use struct of varchars like varchars in PRO*C
From: USENET News System <news_at_inews.Intel.COM>
Date: 17 Nov 92 19:04:04 GMT
Message-ID: <BxvJMt.4JF_at_inews.Intel.COM>
} tab;
From: kortikar_at_mipos2.intel.com (Aniruddha Kortikar) Path: mipos2!kortikar
Date: 17 Nov 92 19:04:04 GMT
Message-ID: <BxvJMt.4JF_at_inews.Intel.COM>
declaration section ......
struct table_name {
varchar field1[10]; varchar field2[10];
} tab;
From: kortikar_at_mipos2.intel.com (Aniruddha Kortikar) Path: mipos2!kortikar
I fill the tab by reading from some file.
if (sscanf(file_descriptor,"%[^|]|%[^|]",tab.field1.arr,tab.field2.arr)) ..... set the length elements .. tab.field1.len=strlen(tab.field1.arr); ...
now how can I update the table tab2
insert into tab2 field (f1,f2) values (:tab.field1,:tab.field2) fails !!!
it says PCC-S-0026 : undeclared host var tab.field1 ....
offcourse I can pad tab.field.arr and then use it. but can I use struct instead?
Aniruddha Kortikar(kortikar_at_mipos2.intel.com)
E-mail : kortikar_at_mipos2.intel.com | A billion here, a billion there ... Phone(W): 408 765 5515 | pretty soon it adds upto real money.Received on Tue Nov 17 1992 - 20:04:04 CET
-------------------------------------------------------------------------------