插入语法 [英] insert into syntax

问题描述

我在将webform中的数据写入两个链接表时遇到问题。我很安静，确保我的插入语法不正确。请看看你是否有时间，如果不是我理解：

I have problems writing data from my webform to two linked tables. I am quiet sure that my insert into syntax is not correct. Please take a look if you have a moment, if not I understand:

展开 | 选择 | Wrap | 行号

推荐答案

你好，


您在运行代码时是否收到错误？


B博士

Hi there,

Are you recieving an error when you run your code?

Dr B

您好dbertanjoli，


试一试。就像DrBunchman问过的那样，请在回复或发布新问题以及代码时发布任何错误。它可以帮助我们帮助你。


希望它有所帮助〜

Hello dbertanjoli,

Give this a try. And like DrBunchman had asked please post any errors that you get when replying or posting new questions along with your code. It helps us in helping you.

Hope it helps~

展开 | 选择 | 换行 | 行号

您好，

非常感谢您的回复。我粘贴上面的代码，这是我得到的消息:(两个表由idName链接）


用于ODBC驱动程序的Microsoft OLE DB提供程序错误''80040e14''


[Microsoft] [ODBC Microsoft Access驱动程序]您无法添加或更改记录，因为表用户中需要相关记录。


/2000040101/form_ac.asp，第34行

我将非常感谢您的回复。


Debbie

Hello,
Thank you very much for your reply. I pasted the code above and this is a message I am getting: (two tables are linked by idName)

Microsoft OLE DB Provider for ODBC Drivers error ''80040e14''

[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table ''users''.

/2000040101/form_ac.asp, line 34

I would greatly appreciate your reply.

Debbie

这篇关于插入语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！