Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Circular links |
Sat, May 19 2007 9:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Why, with the following sql SELECT * FROM "MyMDB"."Transactions" AS "MyMDBTransactions" WHERE "MyMDBTransactions"."_fkAccounts" = 1 do I get 'Circular data links are not allowed' and then it executes anyway????? Roy Lambert |
Sat, May 19 2007 2:04 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I think its me. I removed the {$D-} I'd added to edbcomps and found procedure TEDBQuery.SetDataSource(Value: TDataSource); begin if IsLinkedTo(Value) then DatabaseError(SCircularDataLink); FDataLink.DataSource:=Value; end; My code is procedure TReportsForm.AdvGlowButton1Click(Sender: TObject); begin Reporter.DataSource := nil;<<<<<<<<<<<<<<<<<<<<<<<< Reporter.SQL.Text := nlhSQG1.SQLStr; Reporter.ExecSQL; Reporter.DataSource := dsReporter;<<<<<<<<<<<<<<<<<<<< Report.AutoFitColumns; end; If I comment the two marked lines everything's fine. I cocked up since I should have been doing it the other way and clearing/setting the dataset for the datasource. I'm still confused as to why it gives a warning and then just continues though. Roy Lambert |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |