At 02:43 AM 10/31/2002 +0000, clementdoss wrote:

>When I read Ann´s 122 seconds <g> I fell off my chair!!!
>Is it possible to read a file one row at a time and inset the info
>using QLI?




>If that´s is possible, I sure no one will beat this one!
>The only thing here is that I must keep the data in the same format
>they sent me...

One problem is that 20020228 is not a date format that Firebird
recognizes. 28.02.2002, sure, or February 28, 2002 or 2/28/02
or a bunch of other variants. I guess one could write a
simple ufd that would take an eight digit year first date...
But even then, you'd need to reference the UDF in the insert
statement. Louis Kleiman's trigger answer is probably better.
And, probably, we ought to add the ISO date to the list of
formats we accept.

As I said, ISQL will do the inserts without using a prepared
statement in about 8 minutes. If you care, you could write a
ESQL program that uses prepared statements, turns off auto-undo,
and reads your input file, doing the translation for YYYYMMDD
to a plausible date format. That would scream.



Regards,

Ann
www.ibphoenix.com
We have answers.