Thanks, its now working

One more question please:

According to the documentation I must add a field at the end of 2Bytes that
will indicate the "EOL" Character

So if I populate my External table : exp_patient_demo

Insert into exp_patient_demo(patient_id, first_name, last_name, EOL_FIELD)
select id_patient_master, first_name, last_name, ???
from patient_master

How do I add the eol character through a SQL qry

Regards
Louis


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: 21 June 2005 12:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] External Tables

Hello Louis,

> I would appreciate it if someone can help me please. . .
>
> I am trying to create a external table, the text file is copied in the

same

> location as my database.
>
> This is the syntax I am using to create the table :
>
> CREATE TABLE CODES_EXTERNAL EXTERNAL FILE 'DIAGNOSIS.txt'
> (CODE CHAR(6), DESC CHAR(25), EOL_FIELD char(2));
>
> If I run the script, I get the following error:
>
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Access to external file "DIAGNOSIS.TXT" is denied by server administrator.
>
> The funny thing is, I am the server administrator and no security has been
> set up for this specific file.
> OS : WinXP Pro
> FB 1.52
>
> If I add the path to the textfile in the create table statement, the same
> error occures.
>
> I guess there is something else causing this.

Check the Firebird configuration file. External table access is disabled
by default.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links