Dinamiškai generuoti SQL ne sprendimas?
int cc = rs.getMetaData().getColumnCount();
for ( i = 1 ; i <= cc ; i++){
if ( contains( rs.getMetaData().getColumnName(i), "A" ) ) {
fields = fields + rs.getMetaData().getColumnName(i);
if (i < cc) { fields = fields + ","};
}
}
sql = 'select '+fields +'from lentute
"Eek" wrote in message news:jf3lj0$sm9$1@trimpas.omnitel.net...
Sveiki,
yra lentute: Data, A1, A2.... AX, B1, B2....BX, C1, C2...CX
reikia pasiselectinti duomenis tarkim is visu A stulpeliu, arba B arba
C. Stulpeliu skaicius is anksto nera zinomas.
select %A% from lentute; ??? Google kazkaip neradau jokio pavyzdzio...
Dekui!