>Local oConn as ADODB.Connection, lcString as String >*************************************************** >oConn = CreateObject("ADODB.Connection") >Text to lcString textmerge noshow pretext 1 >Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=password;Initial Catalog=scd4;Data Source=Server >EndText >*************************************************** >oConn.ConnectionString = lcString >oConn.Open() >oConn.Execute("Set dateformat dmy") && Formata a data da conexão pra DMY >*************************************************** >Clear >Set Step On >lcInstruc = "Select top 3 * from Distr where Dis_DT < '18/08/2004'" >rs = oConn.Execute(lcInstruc) && Funciona >?rs.Fields("Dis_DT").Value && Comprova que o Execute anterior, realmente, funcionou >*************************************************** >lcSql = "Select Ped_Cod from PedCert where Ped_Usu_Imp = 0" >loRS = oConn.Execute(lcSQL) && Executo outro Select qualquer - também funciona >?loRS.Fields(0).Value && Comprova que o Execute anterior, realmente, funcionou >*************************************************** >rs = oConn.Execute(lcInstruc) && Agora aquele primeiro Execute não funciona mais dando erro de formato de data >