October 12, 2008 02:16pm pdt

1. rfwoolf 38,275
2. SteveBay 24,075
3. developm... 23,477
4. ziolko 15,400
5. Geert_Gr... 11,141
6. kretzsch... 9,850
7. NickUpson 8,675
8. TheRealL... 7,100
8. ciuly 7,100
10. aikimark 5,996
11. dinilud 5,348
12. RickJ 5,000
13. angelIII 4,400
14. FactorB 3,975
15. Delphian 3,800
16. MerijnB 3,620
17. Johnjces 3,432
18. mikelittlew... 3,275
19. mankowitz 2,500
19. mark_wills 2,500
21. ThievingSix 2,280
22. wimmeyv... 2,000
22. JosephGl... 2,000
22. calinutz 2,000
22. jaime_oliv... 2,000
22. The_eagle 2,000
22. metvacetz 2,000
22. Goodangel 2,000
22. rllibby 2,000

1. kretzsch... 56,131
2. developm... 47,802
3. rfwoolf 45,000
4. ziolko 33,695
5. mnasman 26,360
6. SteveBay 25,075
7. dinilud 18,298
8. TheRealL... 18,252
9. angelIII 17,995
10. NickUpson 17,107
11. emoreau 16,735
12. Workshop... 14,869
13. mikelittlew... 14,636
14. calinutz 12,000
15. ciuly 11,300
16. Geert_Gr... 11,141
17. TimCottee 10,824
18. EddieShip... 10,820
19. Johnjces 10,418
20. mokule 10,000
21. leonstryker 9,735
22. aikimark 9,532
23. wimmeyv... 9,180
24. acperkins 7,890
25. bokist 7,650

11.27.2007 at 10:05PM PST, ID: 22986886

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

Delphi 7 :: TADOQuery OnAfterScroll Error with parameters

Asked by Marius0188 in Delphi Database, Delphi Programming, Delphi Components

Tags: delphi, tadoquery, parameter

Dear Experts,

I have 2 TDBGrid components.
The 1st one must display master table records and the second one displays detail table records
for the selected row in the master table.
qOrders = Master Query
qParts = Detail Query.

On qOrders' OnAfterScroll event I have the following code:
**** PS: See code snippet.

When my application starts up I receives and error:
"EDatabaseError with message 'qParts: Parameter 'POrderNumber' not found'...."
This parameter does exist and when I click the error message away the application starts up and
when scrolling through the master dbgrid the code is working 100%. It is only when the app starts up when I receive this error. After that, it is working as expected.

What can possible be wrong?

Please help.Start Free Trial

         
           
           
             procedure TPickingListFrame.qOrdersAfterScroll(DataSet: TDataSet);
begin
  inherited;
  If qOrders.IsEmpty then Exit;
 
  qParts.Close;
  qParts.SQL.Clear;
  qParts.SQL.Text := 'SELECT POrderNumber, ItemNumber, ItemDescription, Qty FROM tblCallOff WHERE '+
    '(POrderNumber = :POrderNumber) AND (Deleted = :Deleted) ORDER BY ItemNumber';
  qParts.Parameters.ParamByName('POrderNumber').Value := qOrders.FieldByName('POrderNumber').AsString;
  qParts.Parameters.ParamByName('Deleted').Value := 0;
  qParts.Open;
end;

           
         

Keywords: Delphi 7 :: TADOQuery OnAfterScr…

	Title
1	[Turbo Delphi] DBGrid display issue
2	Changing selected row in TDBGrid
3	Mouse wheel on dbgrid
4	How to limit or scope a large result set …
5	Delphi, TQuery and keeping a DBGrid …
6	TDBGrid

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Delphi 7 :: TADOQuery OnAfterScroll Error with parameters

Asked by Marius0188 in Delphi Database, Delphi Programming, Delphi Components

Tags: delphi, tadoquery, parameter

About this solution