Primary Key Help

[skater007]

I need a primary key generated when a record is created on the handheld.  Unfortunately I cant seem to find a way to get it to work.  I wanted the key field to be populated by a script but textbox the script is to populate must be read only since its tied to the PK.  Is there any way to work around this?

Thanks

Andy

[Rob Nicol]

It's best to use an auto-increment primary key in the database.  In your mobile app, don't touch the pk and DragonRAD will assign a temporary key on the device until the row is inserted into the database. At the end of the INSERT SQL statement, add a select to obtain the last inserted ID:

MySQL:
INSERT INTO MYTABLE (col1, col2) VALUES (val1, val2); :EXEC:; SELECT LAST_INSERT_ID();

SQLServer:
INSERT INTO MYTABLE (col1, col2) VALUES (val1, val2); SELECT SCOPE_IDENTITY();

Note: col1, col2 are NOT the primary key.  The primary key is not specified in the insert statement. It is returned to the device by the SELECT portion of the statement, and the device will replace the temporary key with the value provided by the database during the insertion.

[skater007]

How would I set up the table then.
I have set up a table with an auto-increment key field in my sql database and set the key in the data table in DR to another field.  I still can't get the record to insert into my detail table.