Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 10 of 13 total |
Scripting issue. |
Thu, May 10 2007 7:51 AM | Permanent Link |
"Ian Branch" | 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 -- |
Thu, May 10 2007 1:40 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, May 10 2007 5:34 PM | Permanent Link |
"Ian Branch" | 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 -- |
Fri, May 11 2007 2:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, May 11 2007 7:46 PM | Permanent Link |
"Ian Branch" | 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 -- |
Mon, May 14 2007 5:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, May 15 2007 5:27 AM | Permanent Link |
"Ian Branch" | 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 -- |
Tue, May 15 2007 5:43 AM | Permanent Link |
"Ian Branch" | 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) -- |
Tue, May 15 2007 5:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, May 15 2007 5:50 PM | Permanent Link |
"Ian Branch" | 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 -- |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |