Got it. Thank you. Eric did point it out as well.
In summary, do all my creates, then do all my prepares, then do all my
executes with the dummy @bind (? ?) fields.
Finally, I proceed to do my true executes and commits.
Regards,
[EMAIL PROTECTED]
NCCI
Boca Raton, Florida
561.893.2415
greetings / avec mes meilleures salutations / Cordialmente
mit freundlichen Grüßen / Med vänlig hälsning
John LeSueur
<[EMAIL PROTECTED] To:
sqlite-users@sqlite.org
om> cc:
Sent by: Subject: Re: [sqlite] Multiple
Tables on one Flat File
[EMAIL PROTECTED]
du
04/14/2005 01:43
PM
Please respond to
sqlite-users
[EMAIL PROTECTED] wrote:
>
>
>Eric:
>thank you for your reply.
>I ended up creating a %dbh hash with $table as the index along with one
>Operating System file for each table.
>I was hoping there was a way not to create so many Operating System files
>because of the extra Administration they require.
>can you think of any way around this?
>I read all my data from a log and I am creating multiple Tables based on
>the content of the data in the log.
>
>Regards,
>
>[EMAIL PROTECTED]
>NCCI
>Boca Raton, Florida
>561.893.2415
>greetings / avec mes meilleures salutations / Cordialmente
>mit freundlichen Grüßen / Med vänlig hälsning
>
>
If you look at Dr Hipp's mail, the problem is actually the order of your
operations. You need to drop all your prepared statements and reprepare
them after you do any CREATE, ALTER, DROP or VACUUM statements.
John
The information contained in this e-mail message is intended only for
the personal and confidential use of the recipient(s) named above. This
message may be an attorney-client communication and/or work product and
as such is privileged and confidential. If the reader of this message
is not the intended recipient or an agent responsible for delivering it
to the intended recipient, you are hereby notified that you have
received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you
have received this communication in error, please notify us immediately
by e-mail, and delete the original message.
