Solved

MySQL fields

Posted on 2002-04-21
9
218 Views
Last Modified: 2010-04-04
How come I cannot retrieve more than 10 fields from MySQL table and those VARCHAR (or CHAR) fields cannot be displayed on a grid ?

Andrew
0
Comment
Question by:andrewyu
  • 4
  • 4
9 Comments
 

Expert Comment

by:Gulev
ID: 6971612
What kind of component you are using for connecting to MySQL Server??
0
 

Author Comment

by:andrewyu
ID: 6971808
I implement dbGrid with SQLClientDataset directly ?

Andrew
0
 

Expert Comment

by:Gulev
ID: 6971846
I belive you are using ODBC. Are you sure that you have lastest version Mysql ODBC driver.
0
 

Author Comment

by:andrewyu
ID: 6971864
No, I use dbExpress.

Andrew
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Expert Comment

by:Gulev
ID: 6971887
Dbexpress used to compatible old stable version of MySQL server. When you try to download you have to buy license from MySQL.com  . I prefer to use scibit's component for MySQL server.
0
 

Accepted Solution

by:
Gulev earned 5 total points
ID: 6972363
Dbexpress used to compatible old stable version of MySQL server. When you try to download you have to buy license from MySQL.com  . I prefer to use scibit's component for MySQL server.
0
 

Author Comment

by:andrewyu
ID: 6973389
I will use Grid rather than dbGrid.
Anyway, thank you very much for your advice !

Andrew
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6973846
You placed this question for 5 points, help was given, and based on your input, it was what you hoped to get in terms of guidance.

Easy questions begin at 50 points.

Please finalize this quesiton and award the expert who helped you here and close this.

Thank you,

Moondancer - EE Moderator
0
 

Author Comment

by:andrewyu
ID: 6974395
Thank you very much !

Andrew
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
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.

758 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

18 Experts available now in Live!

Get 1:1 Help Now