此SQL代码有什么问题? (VBA MS Access) [英] What's wrong with this SQL code? (VBA MS Access)

问题描述

insertString = "INSERT INTO paymentRecord(paymentEventDate,paymentType,paymentRecordNotes,value,clientID,jobID) 
VALUES (recordDate,recordType,recordNotes,paymentValue,clientID,jobID);"
DoCmd.SetWarnings False
DoCmd.RunSQL insertString
DoCmd.SetWarnings True

此代码返回语法错误，我不知道为什么.所有插入值和列均正确.

This code returns a syntax error and I don't know why. All insert values and columns are correct.

该代码正在与MySQL数据库后端一起在MS Access前端中使用.

The code is being used in a MS Access front-end with a MySQL database back-end.

推荐答案

您必须串联这些值:

" .. VALUES (" & recordDate & "," & recordType & "," & recordNotes & "," & paymentValue & "," & clientID & "," & jobID)"

此外，还必须正确设置值的格式和定界，例如，使用我的函数

Also, the values must be formatted and delimited correctly, for example by using my function CSql.

更好，请使用参数.

这篇关于此SQL代码有什么问题? (VBA MS Access)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！