UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Edit Discussion
> Action Queries    
(Difference between revisions)
Revision as of 15:04, 21 April 2012
Argeedblu (Talk | contribs)
(→Make Table Queries)
← Previous diff		 Revision as of 15:06, 21 April 2012
Argeedblu (Talk | contribs)
(→Make Table Queries)
Next diff →
Line 25: Line 25:
<br/> <br/>
===Make Table Queries=== ===Make Table Queries===
-[SQL]SELECT table.field1, table.field2, table.field3 INTO newtable+[SQL]SELECT Tablename.Field1, Tablename.Field2, Tablename.Field3 INTO Newtable
-FROM table;[/SQL]+FROM Tablename;[/SQL]
==Calling Methods== ==Calling Methods==
[[RunSQL vs Execute]] [[RunSQL vs Execute]]

Revision as of 15:06, 21 April 2012

Action Queries
This page is a stub. Please help us by expanding or merging it with applicable content
This page is under consideration for merging with: Calling Action Queries, RunSQL vs Execute

Related Content:
    RunSQL vs Execute
    Calling Action Queries

Contents

Basic Examples



Delete Queries


SQL
DELETE * FROM tablename WHERE criteria

SQL
DELETE Field1, Field2 FROM tablename WHERE criteria

You can delete all the data from a given table by supplying all (*) fields and no criteria. This is usefull for temporary tables:

SQL
DELETE * FROM tablename

Append Queries


SQL
INSERT INTO Tablename (Field1, Field2) VALUES (Value1, Value2)

Update Queries


SQL
UPDATE Tablename SET Field1=Value1, Field2=Value2 WHERE criteria


Make Table Queries

SQL
SELECT Tablename.Field1, Tablename.Field2, Tablename.Field3 INTO Newtable
FROM Tablename;

Calling Methods

RunSQL vs Execute

Retrieved from "http://www.utteraccess.com/wiki/index.php/Action_Queries"
Edit Discussion
Thank you for your support!
Disclaimers