[PLUG] SQL Syntax

[Charles Sliger]

Try something like this:
SELECT DISTINCT "IPA" FROM "Test_Table" ORDER BY "Number"

Charles L. Sliger,  Information Systems Engineer,  chaz at bctonline.com
"No matter where you go, there you are..."
 
> -----Original Message-----
> From: plug-bounces at lists.pdxlinux.org [mailto:plug-
> bounces at lists.pdxlinux.org] On Behalf Of John Jason Jordan
> Sent: Sunday, November 05, 2006 11:46 AM
> To: PLUG
> Subject: [PLUG] SQL Syntax
> 
> I just know there are people here who dream in SQL commands. My
> knowledge of SQL is negligible. I need to change an SQL command that
> reads a table in an OOo Base file and displays it in a control in a
> Writer form document. The current syntax is SELECT DISTINCT "IPA" FROM
> "Test_Table". I need it to sort the data based on the field "Number",
> which is also in "Test_Table". I tried appending SORT ON "Number" FROM
> "Test_Table" but OOo puked it up. I don't have time to take a course on
> SQL commands (I actually tried reading a book on it once and found it
> hopeless for me). The problem is that I need to deal with SQL commands
> only once in a blue moon; not enough to be worth my time to become an
> expert. Can someone tell me what is the secret to getting the SELECT
> command to sort the data when it displays it in the OOo form control?
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug