Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

simple database question

Posted on 2006-11-21
1
Medium Priority
?
196 Views
Last Modified: 2010-04-04
hi guys,

I have an ADO application with an MsAccess and I want to add the table fields name to a listbox... Any ideas?

best regards
Manuel Lopez (lopem)
0
Comment
Question by:lopem
1 Comment
 
LVL 15

Accepted Solution

by:
mikelittlewood earned 280 total points
ID: 17988726
procedure TForm1.Button1Click(Sender: TObject);
var
  slTemp: TStringList;
begin
  slTemp := TStringList.Create;
  try
    ADOQuery1.Open;
    ADOQuery1.GetFieldNames( slTemp);

    ListBox1.Items.Assign( slTemp);
  finally
    FreeAndNil( slTemp)
  end;
end;
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses

810 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