Editing results from a ADODataset and another question!

Posted on 2003-03-07
Medium Priority
Last Modified: 2008-02-01
Part of a program im making has a diary where the data is drawn from an access table and searched by date using the ADODataset commandtext thing. This works fine and displays the results. but now i want to be able to edit these results and delete them (basically editing and deleting bookings) but im using the DBnavigator.btnclick(nbedit) thing so when i click on the cell it allows me to edit like a normal DBGrid. However because the data is a result of a search, it wont work and displays the error "Insufficient base table information for updating or refeshing." does any one have any ideas????

Also in another form, im calling the print function to print out the form which works fine but i want to set the print orientation to landscape at runtime to make life easier for the user. someone mentioned POLandscape but i dont know how to write this into my code.

Many thanks
Question by:babbels4princess
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

Imbeginner earned 300 total points
ID: 8088467
at first some thing about TADODATASET in DELPHI help:

Use the TADODataSet component's CommandText property to retrieve the dataset, specifying either a table name or an SQL  statement (SELECT only). TADODataSet is not capable of issuing Data Manipulation Language (DML) SQL statements that do not  return result sets (like DELETE, INSERT, and UPDATE). For this use a component like TADOCommand or TADOQuery.

yes you cant manipulate the dataset that return by TADOdataset.
if you want to manipulate data with dbnavigatoe use of TAdotable.
pay attention that you cant manipulate the result of select statement with dbnavigator.


Expert Comment

ID: 9316897
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Expert Comment

ID: 10045180
No comment has been added lately and this question is therefore classified abandoned.

If asker wishes to close the question, then refer to

Otherwise, I will leave a recommendation in the Cleanup topic area that this question is:

Answered by: Imbeginner

Please leave any comments here within the next seven days. It is assumed that any participant not responding to this request is no longer interested in its final disposition.


EE Cleanup Volunteer

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question