Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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 Smile I recommend you do the step by step tutorial then review the source code.


Attached File(s)
.zip  Delphi database example.zip (Size: 405.45 KB / Downloads: 153)
Find all posts by this user
Quote this message in a reply
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
Visit this user's website Find all posts by this user
Quote this message in a reply
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
Find all posts by this user
Quote this message in a reply
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
Visit this user's website Find all posts by this user
Quote this message in a reply
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 Tongue
Find all posts by this user
Quote this message in a reply
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.
Find all posts by this user
Quote this message in a 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.
Find all posts by this user
Quote this message in a reply
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
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


 Quick Theme: