Re: [SL] Programatically Entering Sales Orders

[Mark B. <ma...@ga...>]

On Sun, Nov 12, 2006 at 08:13:13PM -0800, Dave Snell wrote:

> It just seems silly to shell out and call the API from the OS,
> when theoretically I could do it all from within the same perl
> script.

By hitting the db directly, you will end up duplicating some
subset of the application logic; for example, is customer ID
valid, is part number valid, is part number active, etc, etc.

As app logic and/or table structure changes, you may need to
update your script.  This could be painful and will be
error-prone.

If (by some small chance) you insert data that doesn't satisfy
the app's assumptions re: data integrity, who knows what kind of
wierd bugs you could create.

Makes it much harder for Dieter to give you good support as well.
If I was him I wouldn't support this at all.

Yeah, not using the API will make your scripts marginally faster
but it doesn't seem worth it.

m