M
mrdingsheng
Unregistered / Unconfirmed
GUEST, unregistred user!
我现在写了一条sql语句，但总是报错：在第一行报错：[Error] GetRecord.pas(146): '(' expected but identifier 'into' found，在第二行报错：[Error] GetRecord.pas(147): Incompatible types（NetID是整形的），同时也报错：[Error] GetRecord.pas(147): Undeclared identifier: 'NetID'，在的三行报错：[Error] GetRecord.pas(148): Missing operator or semicolon和[Error] GetRecord.pas(148): Operator not applicable to this operand type，请各位大侠帮忙解决，谢谢了
insert into AttendPunch
select 0 as NetID,
EmpID as EmpID,
EmpNO as EmpNo,
SUBSTRING(EvenList.AccessTm,1,4)+'-'+
SUBSTRING(EvenList.AccessTm,5,2)+'-'+
SUBSTRING(EvenList.AccessTm,7,2)+' '+
SUBSTRING(EvenList.AccessTm,9,2)+':'+
SUBSTRING(EvenList.AccessTm,11,2)+':'+
SUBSTRING(EvenList.AccessTm,13,2) as PunchTime,
Right(EvenList.CardCode,10) as PunchNo,
0 as Direction,
0 as Unused,
1 as DealWith,
0 as HasUsed
insert into AttendPunch
select 0 as NetID,
EmpID as EmpID,
EmpNO as EmpNo,
SUBSTRING(EvenList.AccessTm,1,4)+'-'+
SUBSTRING(EvenList.AccessTm,5,2)+'-'+
SUBSTRING(EvenList.AccessTm,7,2)+' '+
SUBSTRING(EvenList.AccessTm,9,2)+':'+
SUBSTRING(EvenList.AccessTm,11,2)+':'+
SUBSTRING(EvenList.AccessTm,13,2) as PunchTime,
Right(EvenList.CardCode,10) as PunchNo,
0 as Direction,
0 as Unused,
1 as DealWith,
0 as HasUsed