Delphi connection

zeroo · #1 (**permalink**) 05-15-2008, 10: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...

**WingedPanther** · #2 (**permalink**) 05-15-2008, 11:28 AM

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

zeroo · #3 (**permalink**) 05-15-2008, 12:41 PM

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;

**WingedPanther** · #4 (**permalink**) 05-17-2008, 05: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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
migration from of app delphi 2 to delphi 7	porno.shome	Delphi/Python	3	04-22-2008 10:57 AM
Delphi help	Nefrit	Delphi/Python	2	02-25-2008 02:15 PM
delphi : proxy query	handras	Delphi/Python	0	01-07-2008 09:20 AM
displaying mysql data into jtextfield.Pls help	iz.ziffa	Java Help	1	05-31-2007 10:58 AM
Delphi: 2 apps sharing the same DLL instance?	ArgusMike	Delphi/Python	0	04-12-2007 02:58 PM

John	........	87.50000
dargueta	........	75.00000
Xav	........	50.00000
MeTh0Dz	........	20.00000
gaylo565	........	18.00000
Johnnyboy	........	3.00000

CodeCall

Contest Stats

Sponsors

Ads

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)