Justy,
Unfortunately, I don't have experience with VFP+SQL server. At my current work we use VFP native tables only. I'd suggest you to start a new thread for this question. Sorry, can not help you.
BTW, you can ask Cindy the same question, she is proficient in this field.
>Dear Nadya,
>
>Thank you for your help! It's work fine! Do you have to know how can I change the VFP database to SQL server? And How much work I need to change the program? Could you suggest some book about VFP w/ SQL consideration and practical work example? Thanks a lot!
>
>Wish you all the best ...
>
>Best Regards,
>
>Justy Chow
If it's not broken, fix it until it is.
My Blog