dim CardSN as string
CardSN="0008"
ad.Open (ConnectionString)
ad.Execute "INSERT INTO Transaction(CardSN,PrevBal,TxnAmt,CurrBal,TopupAmt,DateTimeStamp) values( CardSN,'','10','','',now())"
ad.Close执行的时候报找不到CardSN这个列的错,请问是为什么??
CardSN="0008"
ad.Open (ConnectionString)
ad.Execute "INSERT INTO Transaction(CardSN,PrevBal,TxnAmt,CurrBal,TopupAmt,DateTimeStamp) values( CardSN,'','10','','',now())"
ad.Close执行的时候报找不到CardSN这个列的错,请问是为什么??
CardSN="0008"
ad.Open (ConnectionString)
ad.Execute "INSERT INTO Transaction(CardSN,PrevBal,TxnAmt,CurrBal,TopupAmt,DateTimeStamp) values(" & CardSN & ",'','10','',''," & now() & ")"
ad.Close
ad.Execute "INSERT INTO Transaction(CardSN,PrevBal,TxnAmt,CurrBal,TopupAmt,DateTimeStamp) values( '" & CardSN & "','','10','','',now())"