|
Delphi ADOQuery Database Example
|
|
01-05-2010, 03:02 AM
Post: #1
|
|||
|
|||
|
Delphi ADOQuery Database Example
I attached a step by step tutorial on how to get up and running. Read the tutorial to get a understanding what is going on. It is really easy to understand
 I recommend you do the step by step tutorial then review the source code.
|
|||
|
|
01-05-2010, 03:05 AM
Post: #2
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
Although i was using Delphi databases some time ago and i know something about that, i have never used ADO before.
THX for Delphi example, this will surely help. I made on database in Delphi 2 years ago and it was done without using database components. I made it from scratch with my logic of database. You have it here : http://www.pro9ramming.com/address-book-...t-141.html There's a fine line between genius and insanity. I have erased this line. Oscar Levant There's a fine line between an administrator and black hat hacker. I have erased this line. Dr DEBCOL |
|||
|
|
|
01-05-2010, 03:08 AM
(This post was last modified: 01-05-2010 03:17 AM by codecaine.)
Post: #3
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
ADOTable is even easier to use if you just want to view the database and add and delete or update from it. All the ADOQuery does is allow you to use sql statements against it which is very powerful!. You can go here to test SQL commands http://www.w3schools.com/SQl/default.asp and learn about SQL
If you add the ADOConnection you can link the ADOTable and ADOQuery to the same database. All you have to do is repplace the ADOQuery1.ConnectionString statement with ADOConnection1.ConnectionString and for ADOTable and ADOQuery connection property choose ADOConnection1 |
|||
|
|
|
01-05-2010, 05:58 AM
Post: #4
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
Well i know some SQL already, this forum runs on SQL database so i know PHP+SQL, and i was working in Delphi with that, but not too much.
I made only one table and that's it. There's a fine line between genius and insanity. I have erased this line. Oscar Levant There's a fine line between an administrator and black hat hacker. I have erased this line. Dr DEBCOL |
|||
|
|
|
01-05-2010, 07:03 AM
Post: #5
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
Yea most webpages have the sql behind the scenes though. I haven't seen any websites raw SQL. I made a network database using ADOTable
|
|||
|
|
|
05-26-2011, 08:16 PM
Post: #6
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
Dear Friend example which u had posted dosenot supports Delete Queries of SQL.
I had connected the database to an SQL Server Database instead of Ascess database. Connection is tested properly as u had given in ur documentation. but, It Gives an error as follows when i give a delete Query as followed Delete * From main1 where Date='4/5/2011' Error. ADODataset1: Commandset Dosenot returns any result set. Please Reply. |
|||
|
|
|
05-27-2011, 09:06 AM
(This post was last modified: 05-27-2011 09:43 AM by codecaine.)
Post: #7
|
|||
|
|||
|
RE: Delphi ADOQuery Database Example
That was a mistake on my part
(INSERT, DELETE & UPDATE) do not return any cursor therefore "Open" command must not be used in order to execute these statements. The "Execute" command is the correct option for those commands. A more safer way is to use the TSQLDataset to execute commands on the server side instead of the client executing SQL commands. I will make a example when I get some time. |
|||
|
|
|
05-31-2011, 07:01 PM
Post: #8
|
|||
|
|||
|
Delphi ADOQuery Server Database Example
It would be a great help if u could provide me the example of it...
Thanks |
|||
|
|
|
« Next Oldest | Next Newest »
|