Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Delphi connection

delphi connection

  • Please log in to reply
4 replies to this topic

#1 zeroo

zeroo

    CC Lurker

  • Just Joined
  • Pip
  • 3 posts

Posted 15 May 2008 - 07:36 AM

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...
  • 0

#2 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 15 May 2008 - 08:28 AM

You'll need to learn SQL for data manipulation. W3Schools Online Web Tutorials has a good tutorial on it.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#3 zeroo

zeroo

    CC Lurker

  • Just Joined
  • Pip
  • 3 posts

Posted 15 May 2008 - 09:41 AM

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;
  • 0

#4 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 17 May 2008 - 02:10 PM

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.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#5 shruti

shruti

    CC Newcomer

  • Just Joined
  • PipPip
  • 16 posts

Posted 27 July 2008 - 08:58 AM

You may go with w3 class , it will provide you knowledge.
  • 0





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download