Linking End User Queries
RB 10.04 with Delphi 2006
Very occasionally when I try and link a second query on the Data tab I have
one or two problems:
1) the Link button does nothing if you click it. However, if you click the
Link button in the first query the link expert pops up as expect, although
no good as you don't want this query to be a Detail table
2) If the above occurs I can still drag and drop a link from Q2 to Q1but if
I double click it to invoke the link expert I get a "index out of bounds"
error and the expert doesn't appear. I can send a MadExcept report if you
want.
Is 1) actually legitmate under particular circumstances and 2) a side effect
of the link being established when it shouldn't be? If so then what
conditions would apply for 1 to happen? Or is it a more obscure bug? For
what its worth I dimly recall that I got around it once but changing the
order of the tables in Query2 but it didn't work for me today.
Paul
Very occasionally when I try and link a second query on the Data tab I have
one or two problems:
1) the Link button does nothing if you click it. However, if you click the
Link button in the first query the link expert pops up as expect, although
no good as you don't want this query to be a Detail table
2) If the above occurs I can still drag and drop a link from Q2 to Q1but if
I double click it to invoke the link expert I get a "index out of bounds"
error and the expert doesn't appear. I can send a MadExcept report if you
want.
Is 1) actually legitmate under particular circumstances and 2) a side effect
of the link being established when it shouldn't be? If so then what
conditions would apply for 1 to happen? Or is it a more obscure bug? For
what its worth I dimly recall that I got around it once but changing the
order of the tables in Query2 but it didn't work for me today.
Paul
This discussion has been closed.
Comments
though fear of doubling my poor etiquette
In my quick testing, I was unable to recreate this behavior using the
Customer and Orders tables of the DBDEMOS database. If possible, please
provide the exact steps I need to take to see this on my machine.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
times and I can't see any logic or pattern to it.. However, I do have one
report I can reproduce it on; would it help if I saved it in any particular
format? Below is the MadExcept output you get when double-clicking on the
link:
madExcept version : 2.7i
exception class : EStringListError
exception message : List index out of bounds (0).
Main ($1554):
0085cb0c SAPS_MS.exe daLinkDataViewDlg
TdaLinkDataViewDialog.AddSQLObjects
00859842 SAPS_MS.exe daQueryDataView
TdaQueryDataView.DisplayLinkDialog
0085976a SAPS_MS.exe daQueryDataView TdaQueryDataView.Link
00863143 SAPS_MS.exe daLinkManager
TdaLinkManager.PaintBoxDblClickEvent
0049fe1d SAPS_MS.exe Controls TControl.DblClick
0049ff80 SAPS_MS.exe Controls TControl.WMLButtonDblClk
0049f8fb SAPS_MS.exe Controls TControl.WndProc
0049f588 SAPS_MS.exe Controls TControl.Perform
004a2fde SAPS_MS.exe Controls GetControlAtPos
004a30a6 SAPS_MS.exe Controls TWinControl.ControlAtPos
0049f588 SAPS_MS.exe Controls TControl.Perform
004a32b1 SAPS_MS.exe Controls TWinControl.IsControlMouseMsg
004a3617 SAPS_MS.exe Controls TWinControl.WndProc
004a2ee8 SAPS_MS.exe Controls TWinControl.MainWndProc
0045f124 SAPS_MS.exe Classes StdWndProc
77d496c2 USER32.dll DispatchMessageA
004bd930 SAPS_MS.exe Forms TApplication.ProcessMessage
004bd96a SAPS_MS.exe Forms TApplication.HandleMessage
004b9edf SAPS_MS.exe Forms TCustomForm.ShowModal
007a64a7 SAPS_MS.exe ppEndUsr TppDesigner.ShowModal
007af2eb SAPS_MS.exe ppRptExp TppReportExplorer.Open
00a8dd1a SAPS_MS.exe nvRbExpForm 1541 TnvRbExplorerForm.Design
00a8dc3e SAPS_MS.exe nvRbExpForm 1509 TnvRbExplorerForm.OpenItem
00a8e468 SAPS_MS.exe nvRbExpForm 1918
TnvRbExplorerForm.ListDoubleClickEvent
007ac8d1 SAPS_MS.exe ppRptExp TppItemList.DoOnDoubleClick
007acab5 SAPS_MS.exe ppRptExp TppItemList.DblClickEvent
0049fe1d SAPS_MS.exe Controls TControl.DblClick
0049ff80 SAPS_MS.exe Controls TControl.WMLButtonDblClk
00509b1e SAPS_MS.exe ComCtrls TCustomListView.WndProc
004a2ee8 SAPS_MS.exe Controls TWinControl.MainWndProc
0045f124 SAPS_MS.exe Classes StdWndProc
77d496c2 USER32.dll DispatchMessageA
004bd930 SAPS_MS.exe Forms TApplication.ProcessMessage
004bd96a SAPS_MS.exe Forms TApplication.HandleMessage
004b9edf SAPS_MS.exe Forms TCustomForm.ShowModal
006fdc91 SAPS_MS.exe ppFormWrapper TppFormWrapper.ShowModal
007adbed SAPS_MS.exe ppRptExp TppReportExplorer.Execute
00a90a4b SAPS_MS.exe nvRB 562 TnvRbServer.LaunchReportExplorer
00bd7825 SAPS_MS.exe SAPS_MainU 327 TSAPS_Main.DoReporting
0049f8fb SAPS_MS.exe Controls TControl.WndProc
004a375d SAPS_MS.exe Controls TWinControl.WndProc
004b5fed SAPS_MS.exe Forms TCustomForm.WndProc
004a2ee8 SAPS_MS.exe Controls TWinControl.MainWndProc
0045f124 SAPS_MS.exe Classes StdWndProc
77d496c2 USER32.dll DispatchMessageA
004bd930 SAPS_MS.exe Forms TApplication.ProcessMessage
004bd96a SAPS_MS.exe Forms TApplication.HandleMessage
004bdb8a SAPS_MS.exe Forms TApplication.Run
00be73c6 SAPS_MS.exe SAPS_MS 53 initialization
Paul
Would it be possible for you to send me an example of this report that you
are able to recreate the issue with? If so, please send a small project in
.zip format to support@digital-metaphors.com and I'll take a look at it for
you.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
have Nexus, I should be able to put a project together with some data.
Yes I have NexusDB 2 installed on my machine for Delphi 7 and Delphi 2006.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com