Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Create table component and fields dynamically but can't get Mastersource working |
Sun, Feb 5 2017 12:38 PM | Permanent Link |
Mike | The created fields are standalone available in a grid but linking two tables seems not to be possible.
The following message appears, Cannot access index field '__RowID' Hope anyone has suggestions what could cause this. |
Sun, Feb 5 2017 1:51 PM | Permanent Link |
Fernando Dias Team Elevate | Mike,
The database tables, do they have a Primary Key ? Also, what values are you assigning to TEDBTable.MasterFields and TEDBTable.IndexFieldNames after creating the components? Please check that out... -- Fernando Dias [Team Elevate] |
Sun, Feb 5 2017 2:13 PM | Permanent Link |
Mike | Hi Fernando,
Table1 is filled with orders and table2 has rows with order lines. Table1 ===== OrderID (is primary key) CustomerID etc. Table2 ===== OrderID LineNumber Because I can't create a primary key for for table table 2 I have created an normal index on fieldname OrderID. The following code is used for the master source link. Table2.IndexName := ''; Table2.MasterSource := DataSource1; Table2.MasterFields := 'OrderID'; |
Sun, Feb 5 2017 2:55 PM | Permanent Link |
Mike | Hi Fernando,
Writing it down helped An incorrect indexname was used. Thanks for your help! |
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 |