Jump to content

Delphi connection

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1
zeroo

zeroo

    Newbie

  • Members
  • Pip
  • 3 posts
It's an assignment from my teacher for this semester.I make database in mysql and with wizard in Delph i have upload it. It' made with ADO... Now how i can search that database in delphi and how to manipulate with...
All I have now is interface without sence...
Help me with the tutorial guys...

#2
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
You'll need to learn SQL for data manipulation. W3Schools Online Web Tutorials has a good tutorial on it.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
zeroo

zeroo

    Newbie

  • Members
  • Pip
  • 3 posts
Tnx...But i Know how to manipulate with mysql....but don't know how to put that concept in delphi...I need aplication in delphi where i can search my database...for example :
select * from client;
select * from article where price>4.00;

#4
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
You will need a TQuery object that is hooked to the ADO connection. You use TQuery.SQL.* to .Clear, .Add(), .Close, and .Open connections. You extract data using TQuery.ValueByName('FIELD_NAME').AsString, etc.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#5
shruti

shruti

    Newbie

  • Members
  • PipPip
  • 16 posts
You may go with w3 class , it will provide you knowledge.