Thank you for your support!  
UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Edit Discussion
> Action Queries    

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

[edit]

Basic Examples



[edit]

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

[edit]

Insert Into (Appending)


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

Update


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


[edit]

Calling Methods

RunSQL vs Execute

Retrieved from "http://www.utteraccess.com/wiki/index.php/Action_Queries"
Edit Discussion
This page was last modified 11:48, 23 January 2012.  This page has been accessed 1,500 times.  Disclaimers