Board index » delphi » Schema File - TTable - CRASH DELPHI

Schema File - TTable - CRASH DELPHI

Hi, I have set up a schema file to read from a text file for a batch update.
I think that the reason it crashes, is becuause there is not
a carriage return & line feed in the file.  It is basically a stream of data
with a record length of 220.  Data commonly comes from mainframes this way.

Is there a way to tell the schema the record length?  Or Do I have to create
a conversion procedure?

Thanks,
Mike

 

Re:Schema File - TTable - CRASH DELPHI


Quote
>Is there a way to tell the schema the record length?  Or Do I have to

create

The Schema file *does* contain the record length - eg, the following has
recordlength = 30:

[Table1]
Filetype=Delimited
Delimiter="
Separator=,
CharSet=ascii
Field1=Field1,Char,10,00,00
Field2=Field2,Char,10,00,10
Field3=Field3,Char,10,00,20

--
David Reed
Diamond Software Group
Oasis Rep Software, Inc
www.diamondsg.com
www.oasisrep.com

Re:Schema File - TTable - CRASH DELPHI


You will have to write your own import routine. The BDE ASCII driver only
works with text files (files in which each record ends with cr/lf.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to questions received via email)

Re:Schema File - TTable - CRASH DELPHI


Thanks!  Thats what I was afraid of.

Quote
Bill Todd <b...@nospam.dbginc.com> wrote in message

news:7oclpt$rn34@forums.borland.com...
Quote
> You will have to write your own import routine. The BDE ASCII driver only
> works with text files (files in which each record ends with cr/lf.

> Bill

> --

> Bill Todd - TeamB
> (TeamB cannot respond to questions received via email)

Other Threads