Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: problem with text file generated- urgent
Thread ID: 143090 Message ID: 143129 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, August 25, 2007 6:21:19 AM         
   


> > I've generated a cursor which I
copy
as a textfile using the undernoted
> >
> >
> >
select trial

> >
copy to trial_text type sdf

> >
> >
> > I'm exporting the textfile into another application.
> >
> > However almost half way through the process for importing the textfile into the third party gives an error message,
> >
> > Could there be a bug or a catch using the the
copy to 
command.
> >
> >
> > Thanks
>
> Keep in mind that SDF have Header record, all field names are there in first row of the SDF file.
> If that is not an issue and the importing application stops in the middle of the import may be, just may be, the porblem is in other application, not in yours. Could you import the same file in Excel?


The third party software was being fed with text generated from another application using visual basic.

I was giving the exact data structure, and I built it in vfp, to do same.

Which format will include carriage return in the generation of the textfile.

Thanks


>
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

ENTIRE THREAD

problem with text file generated- urgent Posted by DEREK DODOO @ 8/24/2007 7:40:55 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 7:47:45 PM
RE: problem with text file generated Posted by DEREK DODOO @ 8/24/2007 7:59:28 PM
RE: problem with text file generated Posted by Barbara Peisch @ 8/24/2007 8:34:06 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 9:07:40 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/24/2007 9:02:09 PM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/25/2007 6:21:19 AM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/25/2007 8:06:46 AM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/27/2007 3:22:22 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/27/2007 3:59:29 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/27/2007 4:31:14 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/25/2007 8:52:10 AM
RE: problem with text file generated- urgent Posted by Cetin Basoz @ 8/24/2007 9:28:50 PM