Solved

connection on mysql server using dbexpress from the borland c++ builder

Posted on 2002-07-19
1
1,049 Views
Last Modified: 2012-06-21
hi, i tried to get a tables data from a mysql server with dbexpress komponents. i used sql connect to connect to the server.all went fine.then i could get all tables and send the names to a listbox.not a problem so fare.but now my problem is, to get the fieldnames and values into a dbgrid. does anyone knows, whicn komponents i have to use? so that im able to get all the tables data in an dbgrid and be able to edit it there?
or does anyone knows a great site with some hints for my problem?
thx in advance
0
Comment
Question by:newbie0815
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
vo1d earned 500 total points
ID: 7177254
hi, try this:
insert to ur form:
TSQLConnection
TSQLClientDataSet
TDataSource
TDBGrid
----------
- TSQLClientDataSet->DBConnection needs to belinked to TSQLConnection
- TDataSource->DataSet needs to be linked to TSQLClientDataSet
- TDBGrid->DataSource needs to be linked to TDataSource
------
now in ur code,u only have todo:
SQLClientDataSet->CommandType = ctTable;
SQLClientDataSet->CommandText = <thetablename>;
SQLClientDataSet->Open();

thats all.
greets void

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Many modern programming languages support the concept of a property -- a class member that combines characteristics of both a data member and a method.  These are sometimes called "smart fields" because you can add logic that is applied automaticall…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

617 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