>>Hi!
>>
>>Why you avoiding use of auto-increment fields on SQL Server?
>>
>>In VFP auto-increment field organizing required some effort (for example, read FAQ article at
www.tek-tips.com site in VFP forum), so incorporating this feature into the next version of VFP is a great idea becase there were a lot of troubles and maintenance problems.
>
>Hi Vlad,
>
>Is there a way to retrieve a new ID using autoincrement field? I just made a search here in UT, but didn't find a thread, explaining how to do it, only few with the similar unanswered question. As I vaguelly recall, there is no way like in SQL Server @@IDENTITY and that's unfortunate. I remember, we had this question at our Boston User Group meeting and we didn't come up with a solution at that time...
>
>Your ideas?
>
>Thanks in advance.
APPE BLANK
iNeyKey = ALIAS.PKNAME
BOb