I am using VB6 with a ADO rs object frontend and SQL2000 backend. I have been creating a database program to open ticket orders with a unique ID number. In SQL2000 I have created a field called TicketID. I have set it with both the identity seed and the uniqueidentifier tags, with no luck. When I 'ado.rs.addnew' in the rs, the ID number does not come up in the text field. I have tryed to do an update, updatebatch, and refresh, but that does not work. Do I need to do a INSERT SQL statement when I open an new rs? Or does anyone have any ideas to help in my problem?
Thnaks,
Clark