Hi,
I have a situation where a record is inserted in one table and then immediately after that a record is inserted in another table where one of the fields will get a value of PK from the 1st insert. And I want to include in the second INSERT this value. But I want to be sure that VFP always stays (in terms of record pointer) on the newly inserted record (until, of course, something else occurs - like updating the table or whatever). Therefore, can I rely on VFP to stay on this newly inserted record?
Here is a pseudo example of what I am doing:
INSERT INTO TABLE1 (FLD1, FLD2) value ("Val1", "Val2")
INSERT INTO TABLE2 (FLD1, FLD2, TBL1PK) values ("SomeVal1","SomeVal2",TABLE1.PK_VALUE)
Please let me know what you think.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham