You might want to post this, with your specific questions, on the SQL Server forum here at UT. Mike Levy, who co-authored the Hentzenwerke book, hangs out there.

Jay


>Hello to everybody,
>
>I am migrating a traditional VFP application to SQL backend.
>
>Where can I find information about programming in VFP using SQL ?
>(I have the hentzerwarke book about it, but it have simple examples)
>
>I have many questions, for example,
>how can I validate a non duplicate code
>
>- that is, I usually use SEEK to searh if the code exist
>- How to generate an unique invoice number (if there are many users doing invoices)
>
>... and much more questions
>
>
>
>help please
>Amilcar Pino