To clarify my question: VFP front-end, SQLServer backend.
In my VFP application, I would like to be able to press the "New Record" button and that new record be filled with the default values. But I don't want it to be actually added to the table until I press "Save".
Of course I could just
APPEND BLANK
in VFP and programmatically fill the default values, but if I want to change a default, I have to recompile and besides I thought it would be best to use the SQLServer default values since I entered them there anyway!
So what I'm going to try is something like this:
BEGIN TRANSACTION
INSERT INTO table DEFAULT VALUES
SELECT fieldlist FROM table WHERE idfield = @@IDENTITY
ROLLBACK
>I'm not quite sure that I understand the question but using
>
>INSERT INTO table DEFAULT VALUES
>
>will create a new row in the table and all the columns will contain defaults, NULLs, timestamps, or IDENTITY values depending on how the column was defined.
>
>-Mike
Sylvain Demers