15 Jul 2015 13:41
Erro: 42000 [MySQL][ODBC 3.51 Driver][mysqld-5.6.10-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Acresci o PDF.' at line 1
INSERT INTO tarefas values ('N','N656','2010-07-15','2015-01-01',9,'Inacio','N','E','MP',15,0,0,' ','40610-35.2013','2015-07-14','09:39:23','Acresci o PDF.',' ','2000-01-01','2000-01-01')
cQuery:="CREATE TABLE tarefas ("+;
"USUARIO char(1),"+;
"NRTAREFA char(7),"+;
"HREXIBE datetime,"+;
"DTMAXIMA date,"+;
"PRIORIDADE int,"+;
"INCLUIDOR char(15),"+;
"SOLUC char(1),"+;
"EXIBE char(1),"+;
"VINCULO char(20),"+;
"TEMPOESTIM decimal(7,1),"+;
"TEMPOUSADO decimal(7,1),"+;
"TEMPOCOMPU decimal(7,1),"+;
"CAMPO char(1),"+;
"ASSUNTO char(30),"+;
"DATA date,"+;
"HORA char(8),"+;
"TAREFA char(60),"+;
"ATIND char(1),"+;
"DTCARGA date,"+;
"DTPREFER date)"
15 Jul 2015 20:33
16 Jul 2015 14:37
16 Jul 2015 14:59
cTxt := MemoRead( "teste.txt" )
FOR nCont = 1 TO Len( cTxt )
cLetra := Substr( cTxt, nCont, 1 )
IF .NOT. cLetra $ "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"
? nCont, cLetra, Asc( cLetra ), Substr( cTxt, nCont - 10, 20 )
ENDIF
NEXT
16 Jul 2015 15:35
16 Jul 2015 20:32