Google Search Results

WebCOBRA.com Community Message Boards

Access Data Loader

jwolgamott Posts: 257 Since: 09/26/2005	What SQL Syntax does WQL use? 01/07/2007 12:29 PM
First, what is WQL? -- it's short for WebCOBRA Query Language, and it's how we get information out of the API. It's very similar to SQL (Structured Query Language), but it does not have all of the features. It's designed to be simple and easy to use. SELECT fieldname(s) FROM tablename WHERE fieldname CONDITION value Conditions: * = * like * < * <= * > * >= Want to see other constructs or need to do something? Let us know here! Systems should be free (to interact with others)

jwolgamott
Posts: 257
Since: 09/26/2005

What SQL Syntax does WQL use?
01/07/2007 12:29 PM

First, what is WQL? -- it's short for WebCOBRA Query Language, and it's how we get information out of the API. It's very similar to SQL (Structured Query Language), but it does not have all of the features. It's designed to be simple and easy to use.

SELECT fieldname(s) FROM tablename WHERE fieldname CONDITION value

Conditions:
* =
* like
* <
* <=
* >
* >=

Want to see other constructs or need to do something? Let us know here!

Systems should be free (to interact with others)

Return to Forum