[ervier]

I need to create a login-page for a website. The user gets a unique user_id, but this user_id is not the unique id for the login-table, but for another table (profile-page). Because I don't want to start with the profile table when registering, I need to create an empty record into this table. Then I have a new user_id which I can use in the login-table.

(Yeah, and I know things could have been different with the user_id as the unique identifier for the login-table, but for several reasons that's not an option.)

My problem is how to create this empty table on the login-page. I know it has something to do with @@identity, but I don't have any examples available, and everybody who could help me here is on holiday
So my problem is what sql I have to enter into ultradev.

[Raman]

1) learn SQL for your RDBMS
2) learn the back-end language for your web application server that you're writing the app in
3) get help writing the app from an experienced developer

If you don't understand then you will when the site doesn't work right and you end up pulling your hair out trying to meet your client's deadline realizing you're in over your head.

People writing websites with generated code form ultradev are asking for trouble. There's a lot of problems with the ASP code that UD generates as well as the JavaScript code both UD and DW generate.

Later.