Solved

DataSource With DML sql Statement

Posted on 1998-12-05
3
202 Views
Last Modified: 2010-04-04
instead of using the Datasource property AddNew,Delete,Update.can i supply the insert,update or delete sql statement to Datasource control ?
0
Comment
Question by:qwertyuiopasdfghjkl
  • 2
3 Comments
 
LVL 4

Expert Comment

by:dwwang
ID: 1349453
You can only apply SQL statement to TQuery component.
0
 

Author Comment

by:qwertyuiopasdfghjkl
ID: 1349454
yes....then can i apply DML to Tquery ?
0
 
LVL 4

Accepted Solution

by:
dwwang earned 30 total points
ID: 1349455
Sorry for the delay, you can apply any kind of SQL statements to a tquery, for example, a DML statement:

myQuery.SQL.Text:='insert into mytable values(fieldsval1,fieldval2,...)'
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Send secure, cloud-based, encrypted alerts and maintain HIPAA compliant messaging. Integrates priority & secure messaging into one application. Ensures IT, emergency respondents and healthcare professionals that their critical messages are never mis…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now