Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: Converting from VFP program to SQL/SSRS
Thread ID: 395860 Message ID: 395861 # Views: 60 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, January 20, 2014 8:15:58 PM         
   


> Well, I started off in SSIS and all I accomplished was transforming a Text File into a Text file, every field remaining the same.
>
> I have a large program which is basically a conversion of one format of data to another format. But, I also use outside TEXT files and bring them into cursors in order to reference these large sets of data.
>
> I create two cursors to hold data. I make INSERTS into one cursor, and run several SQL Statements. I do an APPEND FROM early on. I use CASE statements and IF conditions, and Loop with a SCAN/ENDSCAN. I use the COPY TO command twice. I need to think outside of the VFP normal data handling box and go strictly into T-SQL and see if it can be done without giving up on T-SQL and going back to VFP commands. Honestly, nothing beats the Fox for data handling.
>
> I know this may be asking a lot to help me get started, but maybe someone can get me started with the best way to append new data into a cursor in SQL Server? Or, is this even possible with T-SQL? Academically, I have taken two T-SQL classes but we never used TEXT input and never brought such into an empty cursor. We had already made data sets or we created new tables and dropped them once done with them.
>
>
> Cecil Champenois, Jr.


CMIIMisundertand but it sounds like: It should be just a simple operation of FILETROSTR() then followed by INSERT into appropriate field (type BLOB or MEDIUM TO LARGE TEXT not too sure myself about M$SQL). Reading back via SELECT field-->STRTOFILE()
That is for storing / reading only of course; for the conversion process various ocx/dlls are likely to be employed

Regards,
David

ENTIRE THREAD

Converting from VFP program to SQL/SSRS Posted by Cecil Champenois @ 1/20/2014 8:07:19 PM
RE: Converting from VFP program to SQL/SSRS Posted by David Mustakim @ 1/20/2014 8:15:58 PM
RE: Converting from VFP program to SQL/SSRS Posted by Cecil Champenois @ 1/20/2014 8:19:48 PM
RE: Converting from VFP program to SQL/SSRS Posted by David Mustakim @ 1/20/2014 8:29:14 PM
RE: Converting from VFP program to SQL/SSRS Posted by Cecil Champenois @ 1/20/2014 8:57:01 PM
RE: Converting from VFP program to SQL/SSRS Posted by David Mustakim @ 1/20/2014 9:12:46 PM
RE: Converting from VFP program to SQL/SSRS Posted by Gene Wirchenko @ 1/20/2014 11:33:36 PM
RE: Converting from VFP program to SQL/SSRS Posted by Cecil Champenois @ 1/21/2014 4:24:36 AM
RE: Converting from VFP program to SQL/SSRS Posted by Michel Levy @ 1/20/2014 9:08:25 PM