26 Reply by joshuA (edited by joshuA 2021-12-03 23:07:13)

  • Registered: 2019-12-24
  • Posts: 169

Re: Advice: a cfField V.S. an SQLExecute on forms

Hi sparrow,
.
Your example has removed my mental block and for that I thank you!
.
I plan to post an updated sample once I get it working.  I just about kicked the idea on duplicate checking for this, but you have given me more ideas big_smile
.
:salute:
.
P.S.
I did have a question in your code...  What are the triple single quotes doing in this line?

WHERE id_employee = '''+frmmain.tablegrid1.Cells[0,i]+'''
"Energy and persistence conquer all things."
  • Registered: 2019-12-24
  • Posts: 169

Re: Advice: a cfField V.S. an SQLExecute on forms

I love MVD and all the active forum members.  I appreciate all of your help!
.
This is here for reference to anyone else that may benefit from following this (haphazardly named) thread.  I also included a screenshot to show the steps that demonstrate the last few posts.
.
However, I am sure that I will have additional questions to follow lol
.
Thanks again everyone.

Post's attachments

Attachment icon v6.1.zip 378.24 kb, 173 downloads since 2021-12-04 

"Energy and persistence conquer all things."

28 Reply by joe

  • joe
  • New member
  • Offline
  • Registered: 2023-06-19
  • Posts: 1

Re: Advice: a cfField V.S. an SQLExecute on forms

I have tried to use the sql duplicate script but I cannot relate it to my own form, if anyone can he.p to explain where I need to change and with what.