Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How can I commit the Updates with Oracle 8.0.6 and Delphi 5.0 Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
Updates with Oracle 07-Nov-02
Category
DB-General
Language
Delphi 5.x
Views
109
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Pieter Valentijn 


How can I commit the Updates with Oracle 8.0.6 and Delphi 5.0 ? I don't want to use 
a DBNavigator, but buttons. 

Answer:

I would add a new TQuery component to your Databasa module. Call it CommitQuery. 
Edit the SQL property of CommitQuery by writing 'commit'; in the editor. And change 
the database alias so that the query will be posted in the right database. Create 
the ButtonOnClick procedure and add the line CommitQuery.Execute; 

Or you can do something like this 
1   
2   Database1.startTransaction;
3   try
4     Somequery.edit;
5     // Do someting wityh the query.
6     Somequery.post;
7     Database1.Commmit;
8   except
9     Database1.Rollback
10  end;



			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC