Reply to thread

Message: [QUOTE="ryan.mclean, post: 458125"] Ah, I was confused because the auto 'number' uses the newid() sql server function. This is expecting an int . . . I feel so dumb. So then if using a command object, how is the value retrieved? Should I be using a dataadapter? I tried: strTrackid = CType(.Parameters("@TrackId").Value, String) Which didn't work. I could try to put the command into dataadapter and create a datatable . . . not quite sure what to go from here. Maybe what I want is not possible and I'll just have to query after the insert. Or it could be that Iâ€™ve had too much coffee and Iâ€™m missing something obvious ïŠ Thanks again for your help. Ryan [/QUOTE]