Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE with Foxpro
Message
From
09/03/2005 09:31:36
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00993874
Message ID:
00993984
Views:
24
>>Hi everyone:
>>
>>does anyone know of a good book/webpage that would help me with taking an existing foxpro project and moving the data to MSDE (the free version)? Cetin recommended this to me a while ago and suggested using the cursoradapter in order to do this (in order to improve security), but this right now is a bit beyond my programming capabilities and I need a book/web page that could walk me through it (I've tried MSDE briefly and without a GUI it (for me) is difficult to work with).
>>
>>Therefore, maybe something on MSDE and something on moving foxpro data to MSDE would be great. The problem that I see upcoming is that all my forms and reports are based on getting the data natively from Foxpro tables. I of course would need to change this. Is that something that I can do easily (I have VFP8.0)? Most of my forms have commands that populate them with data from the tables ("locate" and then form_text_box = fieldname.value), and a lot of replace commands to either save or make changes to the tables in foxpro.
>>
>>Any suggestions would be greatly appreciated! Thanks.
>>
>>Paul
>
>Hi Paul,
>MSDE is cut SQL server. It is freeware, but it has a few limitations. You will not find anything special for it, but you can use all the books for how to make VFP/SQL Server app. May be most of them are old and do not present newest techniques for working with SQLServer -like using of Cursor Adaptor(CA), where you will be able to query either VFP DBFs or SQLServer or Oracle or ...
>If you like I can send you my wifes session notes about implementing of CA techniques in VFP8 or VFP9

Could I get those notes too?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform