Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
Lookup fields with EDBTable |
Mon, Apr 23 2007 8:36 PM | Permanent Link |
Richard Harding | Hi Tim,
NULL lookup fields are showing the value of of the previously accessed record. Customer (ID, LastName, FirstName, , , ) Order (ID, CustomerID, StatusID, , , , ) Status (ID, Description) Set the MasterSource property of the ORDER EDBTable to create a Master-Detail relationship with the CUSTOMER EDBTable. Create a Lookup field STATUSDESCRIPTION for the ORDER EDBTable which looks up the STATUS table. When browsing the CUSTOMER table, if you access a CUSTOMER without any ORDERS then fields ID, CustomerID, StatusID are set to NULL (as expected) . . . But the StatusDescription field shows the value of the previously accessed record. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au |
Wed, Apr 25 2007 10:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< NULL lookup fields are showing the value of of the previously accessed record. >> I'll check this out, but there's an issue with 1.02 and earlier with NULL bookmark values, so it may be the same thing. The bookmarks go all haywire and show the wrong rows if any NULLs are present in the bookmark values. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, May 6 2007 4:01 AM | Permanent Link |
Paul B | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
I'll check this out, but there's an issue with 1.02 and earlier with NULL bookmark values, so it may be the same thing. The bookmarks go all haywire and show the wrong rows if any NULLs are present in the bookmark values. -------------- Tim, I'm experiencing the same problem with lookup fields showing wrong values. Just to make it clear: are you planning a fix in 1.03? And if so, do you have an ETA for it? Best regards, Paul B |
Mon, May 7 2007 12:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Paul,
<< Just to make it clear: are you planning a fix in 1.03? And if so, do you have an ETA for it? >> Yes, of course. If there's an issue and we are aware of it, I will either: 1) Make sure that it is fixed for the next build, if I can reproduce the problem already (the case here) 2) Make sure that the customer sends me something to reproduce the problem, and I will postpone the build until I can get it and reproduce the problem. 1.03 should be available this week. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, May 28 2007 8:10 PM | Permanent Link |
Richard Harding | Hi Tim,
I have installed 1.03 but the problem reported previously regarding lookup fields still remains. This appears to be my last remaining problem in migrating from DBISAM to ElevateDB so thank you. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au ---------------------------------------------------------------------------------------------------- NULL lookup fields are showing the value of of the previously accessed record. Customer (ID, LastName, FirstName, , , ) Order (ID, CustomerID, StatusID, , , , ) Status (ID, Description) Set the MasterSource property of the ORDER EDBTable to create a Master-Detail relationship with the CUSTOMER EDBTable. Create a Lookup field STATUSDESCRIPTION for the ORDER EDBTable which looks up the STATUS table. When browsing the CUSTOMER table, if you access a CUSTOMER without any ORDERS then fields ID, CustomerID, StatusID are set to NULL (as expected) . . . But the StatusDescription field shows the value of the previously accessed record. |
Tue, May 29 2007 3:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< I have installed 1.03 but the problem reported previously regarding lookup fields still remains. >> I'll need a project from you in that case. I was only able to guess previously that the issue was with the bookmark values. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, May 30 2007 1:03 AM | Permanent Link |
Richard Harding | << I'll need a project from you in that case. I was only able to guess
previously that the issue was with the bookmark values. >> Tim, Attached is a zip file containing: * a zip file a Delphi 2006 project, * a zip file of the ElevateDB database * the SQL listing. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au Attachments: LookupNames.ZIP |
Wed, May 30 2007 2:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< Attached is a zip file containing: >> Thanks very much. It's now fixed and the fix will be in 1.03 B2. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |