Re: Updating Database Table From Text File

Sqlloader can do what you want.

Courtney Wright wrote:

> I'm using Designer Forms 4.5.
> I'm accessing a text file using the Text_IO Built-ins. The text file
> contains information that needs to be plugged into an Oracle database table.
> To update the Oracle table, I'm using SQL; Update...Set...Where etc. Is
> this the most efficient way to go about this? Without the Update SQL line
> included, the procedure takes a few seconds to run (8-12). Adding the line
> of SQL adds minutes on to the time it take for the procedure to run. (The
> SQL line is in a loop and is run 20 or so times) Here's my code:
>
> Note: Loop does not run 1000 times. It goes through 20-30 times.
>
>
>
> Is the another, more efficient way of updating records from a text file? Or
> can this code be modified to only called the 'Update' SQL line once?
> Courtney

--

Always glad to be of service,

Gary :-)

========================================================
"There is nothing more difficult to take in hand, more perilous to
  conduct or more uncertain in its success, than to take the lead
  in the introduction of a new order of  things."

 --- Niccollo Machiavelli, The Prince, 1513