If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"insert/delete queries" <--- careless parlance ?
I have a question to you Access guys.
In the news group I frequently read terms like "insert query" "update query". When I learned SQL I was taught that the language falls into statements of three categories: (1) Data Description Language (DDL) commands CREATE TABLE, CREATE VIEW, ALTER TABLE, .... (2) Data Manipulation Language (DML) commands INSERT, DELETE, UPDATE (3) Queries SELECT This categorisation seems to make sense to me and in all the literature on database management systems it is obeyed. From that, it doesnt make sense to call an UPADTE or INSERT statement a "query" because it doesn't "query" the database, i.e. it does not deliver back records (except for the number of records altered). "insert/update query" looks extremely strange to me and I have never come across it until I started reading this news group. That's why my question is: Is that common sense/usage among Access programmers to call DML statements "queries" too ? Is it justified ? And why is it that way and who introduced it ? Thanks in advance for clarifying this for me, André Hartmann Oracle, MS SQL Server and MS Access programmer Berlin, Germany |
#2
|
|||
|
|||
"insert/delete queries" <--- careless parlance ?
Sounds as if you have too much time on your hands, most=20
people that post to the newsgroups aren't programmers at=20 all but people looking for help and sharing ideas. --- A non Programmer/ non MVP Person---- -----Original Message----- I have a question to you Access guys. In the news group I frequently read terms like "insert=20 query" "update query". When I learned SQL I was taught that the language=20 falls into statements of three categories: (1) Data Description Language (DDL) commands CREATE TABLE, CREATE VIEW, ALTER TABLE, .... (2) Data Manipulation Language (DML) commands INSERT, DELETE, UPDATE (3) Queries SELECT This categorisation seems to make sense to me and in=20 all the literature on database management systems it is obeyed. From that, it=20 doesnt make sense to call an UPADTE or INSERT statement a "query" because it=20 doesn't "query" the database, i.e. it does not deliver back records (except=20 for the number of records altered). "insert/update query" looks extremely=20 strange to me and I have never come across it until I started reading this=20 news group. That's why my question is: Is that common sense/usage=20 among Access programmers to call DML statements "queries" too ? Is it=20 justified ? And why is it that way and who introduced it ? Thanks in advance for clarifying this for me, Andr=E9 Hartmann Oracle, MS SQL Server and MS Access programmer Berlin, Germany . |
#3
|
|||
|
|||
"insert/delete queries" <--- careless parlance ?
"nobodyinparticular" schrieb im
Newsbeitrag ... Sounds as if you have too much time on your hands, most people that post to the newsgroups aren't programmers at all but people looking for help and sharing ideas. --- A non Programmer/ non MVP Person---- Well you did read it and even took the time to reply. So you can afford some (time) aswell, obviously. I believe that a straight, well defined terminology is the foundation of successful communication. And successful communication will speed up helping people on here, dont you agree ? If people use certain words for different purposes or use too many different words for the same thing they will end up confused and/or confusing and so much time will be spent on clarifying. This is an IT oriented news group and without starting a survey I would assume that the vast majority of the posters and readers have a strong programming background, considering the topics currently discussed here... AH |
#4
|
|||
|
|||
"insert/delete queries" <--- careless parlance ?
"André Hartmann" wrote in message
... I have a question to you Access guys. In the news group I frequently read terms like "insert query" "update query". When I learned SQL I was taught that the language falls into statements of three categories: (1) Data Description Language (DDL) commands CREATE TABLE, CREATE VIEW, ALTER TABLE, .... (2) Data Manipulation Language (DML) commands INSERT, DELETE, UPDATE (3) Queries SELECT This categorisation seems to make sense to me and in all the literature on database management systems it is obeyed. From that, it doesnt make sense to call an UPADTE or INSERT statement a "query" because it doesn't "query" the database, i.e. it does not deliver back records (except for the number of records altered). "insert/update query" looks extremely strange to me and I have never come across it until I started reading this news group. That's why my question is: Is that common sense/usage among Access programmers to call DML statements "queries" too ? Is it justified ? And why is it that way and who introduced it ? Thanks in advance for clarifying this for me, We use those terms because those are the terms that Access uses in its own documentation. Ask Microsoft about it. Excerpt from Access 97 Help File ************************************************** *********** What is an action query and when would you use one? An action query is a query that makes changes to many records in just one operation. There are four types of action queries: delete, update, append, and make-table. Delete query Deletes a group of records from one or more tables. ... Update query Makes global changes to a group of records in one or more tables. ... Append query Adds a group of records from one or more tables to the end of one or more tables. ... Make-table query Creates a new table from all or part of the data in one or more tables. ... -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Slow queries | Michael S. Montoya | Running & Setting Up Queries | 2 | July 23rd, 2004 04:37 AM |
Adding colored font to queries | wbfuga | Running & Setting Up Queries | 2 | July 15th, 2004 02:33 AM |
Imported Queries & Field Names - Attn S.Clark MVP | Bruce | Running & Setting Up Queries | 3 | June 14th, 2004 12:14 PM |
seeming quirk with creating new queries from a2000 db /WinXP access/WinXPOS | SisterSun | Running & Setting Up Queries | 3 | June 9th, 2004 04:01 PM |
Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |