Ahmet,

Here is an example:

CREATE DOMAIN CIPFIRST AS CHAR(2);
CREATE DOMAIN CIPSECOND AS CHAR(2);
CREATE DOMAIN DESCRIPTION AS CHAR(80);
CREATE DOMAIN NEWLINE AS CHAR(1);

CREATE TABLE EXTCIPTITLES
EXTERNAL FILE '/D/Db/Iccb/ciptitles.data'
CIPFIRST CIPFIRST,
CIPSECOND CIPSECOND,
DESCRIPTION DESCRIPTION,
NEWLINE NEWLINE;

The ciptitles.data file only has the three columns of data, no extra column
for the new line, that is defined in the database for the CR.

Hope this helps,

Kevin E.

-----Original Message-----
From: ahmetel [mailto:ahmet.elgin@...]
Sent: Thursday, June 23, 2005 7:01 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: External File

--- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@o...> wrote:

> In "Using Firebird" I've seen something like:
> CREATE TABLE EXT_TBL EXTERNAL FILE filespec
> (columndef [,columndef,...],
> linedelimiter1 CHAR(1)[, linedelimiter2 CHAR(1)]);
> (give or take a little...)
> The linedelimiters are used for CR/LF or LF.
>
>
> --
> Aage J.

Thanks for your interest,
I tried the syntax but cant success. Can you give an example?
are linedelimiters used as column of table?

ahmet,




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links