防止重复 [英] Preventing Duplication

问题描述

你好vb大师好日子！我只是想在这里寻求帮助..我正在努力防止重复记录将保存在我的表格中......


这里我的代码：

hi vb master good day! i just wanted to ask for some help here.. i''am trying to prevent duplcation of records that will be save in my table...

here my code:

展开 | 选择 | Wrap | 行号

推荐答案

rsShowRec.Open" Select * from RECORDS，cnn，adOpenStatic，adLockOptimistic"

rsShowRec.Open "Select * from RECORDS , cnn, adOpenStatic, adLockOptimistic"

你的报价在错误的位置。你在SQL字符串中包含了所有参数（cnn等）。

You''ve got the quotes in the wrong place. You''re including all the parameters (cnn, etc) in the SQL string.

感谢你对mga线程进行娱乐，但我不知道如何安排它！你可以给我一些想法或暗示我的代码将如何运作我想要...

Thank you for entertaining mga thread, but i dont how to arrange it! can you give me ideas or hint on how my code will function as i want...

感谢您对mga线程进行娱乐，但是我不怎么安排它！你可以给我一些想法或暗示我的代码将如何运作，因为我想要...

Thank you for entertaining mga thread, but i dont how to arrange it! can you give me ideas or hint on how my code will function as i want...

我还没有详细查看代码，但我提到的那条线可能应该像这样纠正......

I haven''t looked at the code in much detail as yet, but the line that I mentioned probably should be corrected like this...

展开 | 选择 | Wrap | 行号

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