ICPooreman
asked on
Delphi Beginner needs help with writing Query and managing results
I'm using something similar to the following code to enter an sql query and then place the results of a particular field somewhere on my form.
Query1.SQL.Clear;
Query1.SQL.Add ('Select * From tablename Where value = someData');
Query1.RequestLive := true;
Query1.Active := true;
Query1.Open; {open query + display data}
EditBox.Text := Query1.FieldByName('name') .AsString;
I just started with Delphi a couple days ago and I need some help. A lot needs to change with this and I have several questions.
1) Probably the easiest question is how do I check the number of records that is returned from my query?
2)Next, I need to check if the fieldname 'name' exists before I attempt to assign its value to my EditBox how do I do that? Also is there anyway to pull out all of the fieldnames in a table?
3) Finally, I tried putting the above in a try statement but even with that if I entered bad data into the query (e.g. a non-existent tablename, or tried to check values with incompatible types) the program would give me an error and crash (maybe I was doing it wrong). Is there anyway that I could have something less harsh happen if the program can't execute the query.
Query1.SQL.Clear;
Query1.SQL.Add ('Select * From tablename Where value = someData');
Query1.RequestLive := true;
Query1.Active := true;
Query1.Open; {open query + display data}
EditBox.Text := Query1.FieldByName('name')
I just started with Delphi a couple days ago and I need some help. A lot needs to change with this and I have several questions.
1) Probably the easiest question is how do I check the number of records that is returned from my query?
2)Next, I need to check if the fieldname 'name' exists before I attempt to assign its value to my EditBox how do I do that? Also is there anyway to pull out all of the fieldnames in a table?
3) Finally, I tried putting the above in a try statement but even with that if I entered bad data into the query (e.g. a non-existent tablename, or tried to check values with incompatible types) the program would give me an error and crash (maybe I was doing it wrong). Is there anyway that I could have something less harsh happen if the program can't execute the query.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.