Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How many is to much ???
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00652667
Message ID:
00652763
Views:
26
Hi Michael,

>I think you may be right about this, although my apps have not had table problems in quite some time.
>
>Where can those of us VFPers without SQL experience get the basics we need to get started? Native VFP tables have become so easy, it's important to be gentle....

SET MARKETING ON < g >

We (TakeNote Technologies) offer SQL Server training classes. There are two different aspects to learning SQL Server. The first is Administering a SQL Server (how to implement security, do backups, create and schedule jobs, etc.) the other is the Implementation or programming side. That consists of coding TransAct SQL, the language of SQL Server.

SET MARKETING OFF < G >

A great book to start with is Professional SQL Server 2000 Programming by Rob Viera (WROX Publishing).

>Also, where do YOU stand on the "Views vs. SQL Passthrough" controversy?

Uh oh, don't get me started here... I'll say this, hold on, something I have to do...

SET MARKETING ON < g >

We build ALL our VFP / SQL Server apps with DataClas/VFP. DataClas/VFP is a native VFP middle tier data object that connects, retrieves, and updates data in SQL Server.

SET MARKETING OFF < g >

I know I'm throwing gas on the fire here but Remote Views blow! I'm no fan of RV's. We use SPT for downloading cursors for combo boxes and the like, but all other data access goes through DataClas/VFP. The Eval Editon is available for download on the Red Matrix site (www.redmatrix.com)

Hope this helps...

Yeah, yeah, I know, now I'll get flamed for being a marketing slime ball!
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform