>If my backend is Visual FoxPro, is there a way to get the primary key that was generated in the Insert command? In a particular situation, I need to issue child insertions at the same time a new record is created on the parent. The Visual FoxPro table works with an auto incremental field as the primary key. Could there be any similar use such as the scope identity to resolve that issue?

How about new VFP9 function GETAUTOINCVALUE([nDataSessionNumber | 0])
?