Solved

Loading controls from an object and having trouble.

Posted on 2000-02-14
5
138 Views
Last Modified: 2010-04-04
Hello experts,

  I have a problem getting the data from an object to load into my controls. I will show you the two chunks of code that I am using to do this. The first part is the Load object routine that is done at right at execute time. This is also used any time a on click is used on one control.

procedure TGymMgr.LoadAerobicObj;
var
  oAerobic     : TAerobic;
  x : integer;
begin
  if Aerobic.Count > 0 then
     for x := Aerobic.Count -1 downto 0 do
       Aerobic.Delete(x);
  qryGym.Close;
  qryGym.SQL.Clear;
  qryGym.SQL.Add ( 'Select EMP, TDATE, ENTRY, ATYPE, ' );
  qryGym.SQL.Add ( 'MEDEXEMPT, TTIME, HEARTRATE, VO2MAX, BIKELOAD, ' );
  qryGym.SQL.Add ( 'SEATPOS, RATING, RMODIFY ' );
  qryGym.SQL.Add ( 'from GYM.AEROBIC ' );
  qryGym.Sql.Add ( WhereIs );
  qryGym.SQL.SaveToFile('H:\Gym.sql');
  qryGym.Open;
  qryGym.first;
  while not qryGym.eof do begin
     oAerobic := TAerobic.Create;
     oAerobic.Emp                := qryGym.FieldByName('EMP').AsString;
     oAerobic.Tdate             := qryGym.FieldByName('TDATE').AsString;
     oAerobic.Entry              := qryGym.FieldByName('ENTRY').AsString;
     oAerobic.Atype            := qryGym.FieldByName('ATYPE').AsString;
     oAerobic.Medexempt   := qryGym.FieldByName('MEDEXEMPT').AsString;
     oAerobic.Ttime             := qryGym.FieldByName('TTIME').AsString;
     oAerobic.Heartrate      := qryGym.FieldByName('HEARTRATE').AsString;
     oAerobic.Vo2max       := qryGym.FieldByName('VO2MAX').AsString;
     oAerobic.Bikeload       := qryGym.FieldByName('BIKELOAD').AsString;
     oAerobic.Seatpos       := qryGym.FieldByName('SEATPOS').AsString;
     oAerobic.Rating           := qryGym.FieldByName('RATING').AsString;
     oAerobic.Rmodify       := qryGym.FieldByName('RMODIFY').AsString;
     oAerobic.ObjStatus    := OK;
     oAerobic.ObjState   := ExistingObject;
     Aerobic.Add ( oAerobic );
     qryGym.Next;
  end;
  qryGym.Close;
end;


//  this procedure in located within my main form. It sends the WhereIs statement to
    the above procedure and then loads the data into the controls on the form.

procedure TfrmTest.LoadAerobic;
Var
   i : integer;
begin
   employeeNo := '325';      //  these are not in my program actually I put them there
   testDay:= '12/04/1999';  //  just so you can see what the data looks like
   Screen.Cursor := crHourGlass;
   GymMgr.whereIs  := 'Where  Emp = ''' + EmployeeNo + ''' '
                   +  'And TDate = to_date(''' + TestDay + ''', ''MM/DD/YYYY'' ) ';
   gymmgr.LoadAerobicObj;  // this is where my first procedure gets called
   GymMgr.whereIs  := '';
//--- Aerobic testing  Info
   edtAMed.Text         := oAero.medexempt;   //access violation at address ect...
   edtType.text           := oAero.atype;
   edtATime.text         := oAero.ttime;
   edtHeart.text          := oAero.heartrate;
   edtSeatPos.text      := oAero.seatpos;
   edtBike.text            := oAero.Bikeload;
   edtVo2Max.text      := oAero.vo2max;
   edtARate.text         := oAero.rating;  
   Screen.Cursor := crArrow;
end;

When I make break points and follow through... It will give me an access violation error. I think it maybe somthing to do with my list not being created but when I do an evaluate of GmyMgr.Aerobic.count I get 1 row, which is what I expect to have.

Well any ideas are weclome,
David
0
Comment
Question by:MrError
  • 2
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
aubs earned 100 total points
ID: 2519360
In your LoadAerobic procedure you appear to be trying to access an object called oAero, but I can't see where this object gets its data.

Have you missed some lines in the procedure like:

for x :=0 to GymMgr. Aerobic.Count -1  do
begin
   oAero:= TAerobic(GymMgr.Aerobic.items[i]);
end;
....?

Aubs
                           
0
 

Author Comment

by:MrError
ID: 2520334
Aubs,

  Huh that just may do it. Let me try a few more things with this and I will let you know if that was all I forgot.

Thank you,
David
0
 

Expert Comment

by:djadja
ID: 2521861
You may also have a memory leak ->
if Aerobic.Count > 0 then
     for x := Aerobic.Count -1 downto 0 do
       Aerobic.Delete(x);

I think should read:
if Aerobic.Count > 0 then
     for x := Aerobic.Count -1 downto 0 do begin
     TAerobic(Aerobic.Items[x]).Free; // <- free the aerobic object BEFORE deleting the pointer to it
     Aerobic.Delete(x);
end;

PS. The Aerobic.Count>0 is superfluous as the for x line would get executed if count was 0 as it would eval to -1 downto 0
0
 

Author Comment

by:MrError
ID: 2527108
aubs & djadja

  Well you both were right. Thank you for your excellent ideas.
Since aubs answered my main question I will give her the points but djadja I did have a memory leak so thank for resolving that.

David
0
 

Expert Comment

by:djadja
ID: 2527145
Thats quite alright.
Glad to be of service :)
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now