Ciao a tutti
come faccio a mandare a capo questa stringa sql ?
codice:dim objcmd as new oledbdataadapter ("Select * from reception_0 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_1 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_2 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_3 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_4 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_5 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_6 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" union Select * from reception_7 where tessera >="& datainizio2 &" and tessera <="& datafine2 &" order by tessera desc, datas desc ", objconn)