Maybe this will help you on your way:
Dim Conn As Connection
Set Conn = DataEnvironment.YourConnection
Conn.Execute ("INSERT INTO tablename VARIABLES (" & txtRownumber & ", '" & txtName & "')")
You can use this code behind a save button to insert the data in the...
You can also query the database first before you save the input to the database. Search for a record with the given CustemerID and use Recordcount to find out if the record exists. If recordcount is 1, you can raise an error. Otherwise you can launch an insert query to save the input.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.