View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004404 | JEDI VCL | 00 JVCL Components | public | 2008-07-16 09:41 | 2008-10-10 05:03 |
| Reporter | astock | Assigned To | |||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Summary | 0004404: JvDBLookupTreeViewCombo unknown error on dropdown | ||||
| Description | Hi I'm trying to use a JvDBLookupTreeViewCombo but every time I click on it so I can select from the drop down, it produces an very helpful “An unknown error has occurred†message from the EOleException Class and takes me to the following code within JvDBLookupTreeView. FDataList.SetValue(FListLink.DataSet.Lookup(FKeyFieldName, FKeyValue, FMasterField)); I’m guessing this error is something to do with FKeyValue as when it breaks this is Null. I would say that I’ve missed setting a property or something but I can’t see what it could be, I’ve set the ListSource, ListField, KeyField and DetailsField properties and I can’t see anything like KeyValue or where this should be set. Can someone let me know what I’ve missed or whether this is bug. Thanks | ||||
| Tags | No tags attached. | ||||
|
|
Please provide the zipped sources of a sample application showing this. |
|
2008-07-18 02:18
|
Test.zip (250,078 bytes) |
|
|
Zip File as requested |
|
|
Well, I'm sorry, but the demo is unusable, it does not do anything nor does it provide any explanation. Please provide a usable application. |
|
|
In the project I working on, I want to use a JvDBLookupTreeViewCombo to allow the user to make a selection, this selection will then influence other areas of the page. The error occurs when the JvDBLookupTreeViewCombo is opened in the configuration given within the demo. I tested the demo before I sent it you and it produces the error shown within the doc1.doc file included in the zip file. In the background of this word file is the location it takes me to when the error is produced. The only thing I’ve changed in the demo from my test to the one I sent to you is remove the database connection string so you can add an appropriate one for yourself, I’ve left in the SQL to give you an idea of what I’m trying to do. This error might always be caused by me not the configuration of the control correctly, if so can you please inform me of what I've done wrong but I’ve configured this in the same way as a TJvDBTreeView I’ve used elsewhere, the TJvDBTreeView works fine. |
|
|
Thing is, I'm not a DB expert. This is why I would much prefer if the demo application would be self contained, using a TJvCSVDataset for example. |
|
2008-07-25 03:23
|
Test1.zip (263,357 bytes) |
|
|
I've just uploaded a new zip file for you that uses a TJvCSVDataset but for some reason the error does not occur when the datasource is connected to the TJvCSVDataset but does still occur when connected to the standard TADOQuery. The only thought I've got on this is that the database knows about NULL values and passes these through to the program, but the CSV file can not handle NULL values itself and they are converted to zero length strings which are passed through to the program and the JvDBLookupTreeViewCombo can handle zero length strings but not NULL. I'm afraid I don't know if this makes sense within Delphi or not as I'm still learning the language. |
|
|
Someone else will have to look at this |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2008-07-16 09:41 | astock | New Issue | |
| 2008-07-17 01:58 | obones | Note Added: 0014393 | |
| 2008-07-17 01:58 | obones | Status | new => feedback |
| 2008-07-18 02:18 | astock | File Added: Test.zip | |
| 2008-07-18 02:19 | astock | Note Added: 0014399 | |
| 2008-07-21 00:28 | obones | Status | feedback => acknowledged |
| 2008-07-23 06:39 | obones | Note Added: 0014415 | |
| 2008-07-23 06:39 | obones | Status | acknowledged => feedback |
| 2008-07-23 14:55 | astock | Note Added: 0014450 | |
| 2008-07-23 23:50 | obones | Note Added: 0014452 | |
| 2008-07-25 03:23 | astock | File Added: Test1.zip | |
| 2008-07-25 03:38 | astock | Note Added: 0014459 | |
| 2008-10-10 05:03 | obones | Note Added: 0014807 | |
| 2008-10-10 05:03 | obones | Status | feedback => acknowledged |
