Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: problem with text file generated- urgent
Thread ID: 143090 Message ID: 143103 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, August 24, 2007 9:28:50 PM         
   


> 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

Derek,
An SDF format is just a fixed width data format. VFP would create it wonderfully well.
The problem should be with your 3rd party importer's expectations. Reasons come to mind:

1) Column widths do not match, hence a shifted data causes some failure during conversion of datatype
2) (most likely) VFP exported date/datetime fields which doesn't conform to importer's expectation (ie: empty)

If possible I'd use another way of transferring data (XML,OleDb and such), SDF is just not declarative enough.

Cetin Basoz

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