I am looking for a db navigator to insert and update a Microsoft sql 2000 database using an ado query.
I have a dbnavigator on a form but eventually I want to use it on numerous forms in an application. I want the form to be locked until a user presses the edit/insert button on the navigator and then once this occurs the dbnavigator then only displays the post /cancel buttons. If the cancel button is pressed then no changes are made but if the post button is pressed then the database gets populated.
My table is called customers and has the following fields:
customer_link int 4 no null
customername nvarchar 50 no null
customerref nvarchar 50 no null
website nvarchar 50 allow null
I have tried to get the insert query to work but I have problems inserting a unique identifier into the field customer_link and I am struggling with the update query.