Solved

DataSource With DML sql Statement

Posted on 1998-12-05
3
201 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
Comment Utility
You can only apply SQL statement to TQuery component.
0
 

Author Comment

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

Accepted Solution

by:
dwwang earned 30 total points
Comment Utility
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 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

14 Experts available now in Live!

Get 1:1 Help Now