>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
>
>
> Here's a "Firebird-support special" for you. I got it from Dmitry
> Sibriryakov. I don't know where he got it. :-))
>
> Define a smallint column as the last column in the table:
>
> alter table mytable
> add EOL_FIELD smallint default 2573;
> commit;

Pretty cool I would say. ;-)



Regards,
Thomas