>>>Are you using SQL Server?
>>>
>>>If yes, perhaps just create a stored procedure and return the ID (you can use OUTPUT clause of the INSERT command).
>>>
>>
>>
>>I am new to WinDev, and as I said I do not know how to use OUTPUT on the its queries and did not find examples either (the examples I saw were not for queries but for direct sql statements)
>
>Very simple example:
>
>
>CREATE TABLE dbo.TestInsert (InsertedPK int identity, Name varchar(100))
>GO
>
>INSERT INTO dbo.TestInsert OUTPUT Inserted.InsertedPK VALUES ('Kevin Goff')
>I think you guys are missing the point that I am using WinDev Queries, I know how to use it in FoxPro C# or manage studio :)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
