Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Insert a DB record and receive the Record ID

Avatar

18-02-2009

Hi !



I'm trying to populate a DB (two tables) based

on the classic master/detail approach.



These steps represent what I would like to achieve :

1) add the master record and get the corresponding primary key

2) add multiple records in another table using the Master Prim.key



That seems to be so simple,

but I have no idea how to get the Master PrimaryKey.



Thanks.

GB.

Replies

Avatar

Avatar
Validate 1
Level 5
yodadobe
Level 5

Likes

12 likes

Total Posts

298 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 5
yodadobe
Level 5

Likes

12 likes

Total Posts

298 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yodadobe
Level 5

18-02-2009

You can't get a result back from the standard database call. If there is another unique field, you could query again based on that. I needed something with one child record. I did the whole thing in a PL/SQL block passing all the parameters to one call.



To get a value back from a call, look at this thread: http://www.adobeforums.com/webx/.59b7d6b1/3