Hi Bert

I assume that the filename column in your ascii data is already populated
and with different filenames?

However, I have found that backslah characters sometimes screw up the ascii
field divisions. Does the filename
include the path spec and do you enclose it in quotes?

If the filename is constant for the whole ascii file the method below is
probably the quickest solution

Groete,
Francois


-----Original Message-----
From: kursatsaribey [mailto:kursatt@...]
Sent: Sunday, 20 January 2002 02:53
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IB_Import

--- In IBObjects@y..., Bert Neef <bert@n...> wrote:
> Him
>
> >if you send your ascii file structure, we can help you, I think
there is a
> >problem with format of your column
> Well everything that's in my ascii file is imported correctly but
the
> target table has one column that isn't present in the input ascii
file, and
> that column should be filled with the ascii file name.

I do not know there is a possibility to do what you want to do with
IB_Import, after you import your data into gdb, using IB_script you
can update your table and set all values of your field (which you
want to fill with the ascii file name) with the name of your ascii
file name.
UPDATE TABLE MYTABLE SET MYFIELD="asciifilename"
I think this solves your problem with my limited information about IB
objects and interbase.
best wishes
kursat



___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]