AÃ vai:
Insert:
cQuery:="INSERT INTO tarefas values ('"+dst+"','"+bsnvt+"','"+alltrim(str(year(dt)))+"-"+substr(dtoc(dt),4,2)+"-"+substr(dtoc(dt),1,2)+" "+hr+"','"+alltrim(str(year(dtmax)))+"-"+substr(dtoc(dtmax),4,2)+"-"+substr(dtoc(dtmax),1,2)+"',"+alltrim(str(pr))+",'"+nmus+"','N','E','"+alltrim(vinc)+"',"+alltrim(str(tpmax))+","+alltrim(str(tpmax))+",0.0,' ','"+ass+"','"+alltrim(str(year(date())))+"-"+substr(dtoc(date()),4,2)+"-"+substr(dtoc(date()),1,2)+"','"+time()+"','Tarefa: "+substr(tr,1,52)+"',' ','"+alltrim(str(year(dtcg)))+"-"+substr(dtoc(dtcg),4,2)+"-"+substr(dtoc(dtcg),1,2)+"','2000-01-01')"
exquery(cquery)
Update:
cQuery:="UPDATE tarefas SET hrexibe='"+alltrim(str(year(dt)))+"-"+substr(dtoc(dt),4,2)+"-"+substr(dtoc(dt),1,2)+" "+hr+"' WHERE nrtarefa='"+arq+"'"
exquery(cquery)
E a função exquery está assim:
function exquery(cQuery)
local vzcon :=0
local nConnection :=0
do while .t.
nConnection=conexsql()
if nConnection=0
vzcon++
if vzcon>10
if us="I"
?"Não conectou"
tone(261.7,33)
inkey(.5)
endif
mandmail1("","Não conectou para executar a query: "+cQuery,,2)
else
inkey(2)
endif
RDDSETDEFAULT( "DBFNTX" )
return .f.
else
exit
endif
enddo
do while .t.
RDDSETDEFAULT( "SQLMIX" )
If !RDDINFO(1003, cQuery)
vzcon++
if vzcon>8
RDDSETDEFAULT( "DBFNTX" )
if us="I"
cls
?"Não conseguiu gravar na tabela"
?cquery
?"Erro: "
?rddinfo(1005)
?rddinfo(1004)
tone(261.7,33)
endif
mandmail1("","Não gravou a query (nConnection: "+alltrim(str(nConnection))+"): "+cQuery+"; vzcon: "+alltrim(str(vzcon)),,2)
return .f.
endif
@ maxrow()-1,1 say "Tentando gravar na tabela; aguarde..."
inkey(2)
else
exit
EndIf
enddo
RDDSETDEFAULT( "SQLMIX" )
if !RDDINFO( 1002,,, nConnection)
if us="I"
?"Não desconectou no exquery"
tone(261.7,33)
inkey(20)
else
mandmail1("","Não desconectou")
endif
endif
RDDSETDEFAULT( "DBFNTX" )
return .t.