Hi Guys,

   D7Pro, Latest DBISAM.

When I run the following code/query in a DBISAMQuery....where
"lbTarget.Items[vTCnt]" contains 'accounts.sql', sans the quotes.


       SQL.Clear;
       Sql.Add('empty table ' + LeftStr(lbTarget.Items[vTCnt],
Length(lbTarget.Items[vTCnt]) - 4) + ';');
       Sql.Add('Start Transaction;');
       Sql.LoadFromFile(eTargetDir.Text + '\' + lbTarget.Items[vTCnt]);
       Sql.Add('Commit;');
       ExecSQL;   

I get a duplicate index error which to me indicates the empty table command is
not happening.

Any thoughts as to what I have missed?

Regards & TIA,

Ian
--

Ian,

<< When I run the following code/query in a DBISAMQuery....where
"lbTarget.Items[vTCnt]" contains 'accounts.sql', sans the quotes.

       SQL.Clear;
       Sql.Add('empty table ' + LeftStr(lbTarget.Items[vTCnt],
Length(lbTarget.Items[vTCnt]) - 4) + ';');
       Sql.Add('Start Transaction;');
       Sql.LoadFromFile(eTargetDir.Text + '\' + lbTarget.Items[vTCnt]);
       Sql.Add('Commit;');
       ExecSQL;

I get a duplicate index error which to me indicates the empty table command
is not happening. >>

Have you verified that this is the case by simply not running the second
part and examining the table after the empty ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

>
> Have you verified that this is the case by simply not running the second part
> and examining the table after the empty ?

Hi Tim,

   Sure did and sure enough it is empty.  And to answer the next question, no,
there is no duplicate entries in the data being imported.

   Umm.  A thought, should I delete the index?  But that would be defeatingthe
purpose to a degree.

Regards,

Ian

--

Ian,

<< Sure did and sure enough it is empty.  And to answer the next question,
no, there is no duplicate entries in the data being imported. >>

Are you sure about that ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Ian,
>
> << Sure did and sure enough it is empty.  And to answer the next question,
> no, there is no duplicate entries in the data being imported. >>
>
> Are you sure about that ?

Hi Tim,

   Yup.  Data and example project sent by direct email.

Regards,

Ian


--

Ian,

<< Yup.  Data and example project sent by direct email. >>

Thanks.  I didn't receive anything yet, although I'm not sure if you've sent
it yet.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Ian,
>
> << Yup.  Data and example project sent by direct email. >>
>
> Thanks.  I didn't receive anything yet, although I'm not sure if you've sent
> it yet.

Hmmm.  Not sure what's happening.  I checked the sent items and that is OK.
The email address is OK too.  I have resent again to see how it goes.

Regards,

ian


--

Ian Branch wrote:

> Tim Young [Elevate Software] wrote:
>
> > Ian,
> >
> > << Yup.  Data and example project sent by direct email. >>
> >
> > Thanks.  I didn't receive anything yet, although I'm not sure if you've sent
> > it yet.
>
> Hmmm.  Not sure what's happening.  I checked the sent items and that is OK.
> The email address is OK too.  I have resent again to see how it goes.
>
> Regards,
>
> ian

Received the following...


The original message was received at Tue, 15 May 2007 19:31:06 +1000

 ----- The following addresses had permanent fatal errors -----
<timyoung@elevatesoft.com>

 ----- Transcript of session follows -----
.... while talking to backup-mx.choiceone.net
>>> >>> RCPT To:<timyoung@elevatesoft.com>
<<< 553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)

--

Ian,

<< Received the following... >>

Does that occur now ?   Also, does it only occur when you send an attachment
?  It could have been a temporary DNS burp, or that the sending mail server
tried to send to the mail server at our T1 provider in addition to/instead
of the primary mail server

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Ian,
>
> << Received the following... >>
>
> Does that occur now ?   Also, does it only occur when you send an attachment
> ?  It could have been a temporary DNS burp, or that the sending mail server
> tried to send to the mail server at our T1 provider in addition to/instead of
> the primary mail server

Hi Tim,

   Have you received anything?

Regards,

Ian

--