FP, Access & SQL

[novus]

I have FP2003 & Access 2003.

Using the database results wizard it appears I only have access to ANDs and
ORs. Can I use things like NOTs and exclusive ORs? Can I manipulate the code
produced by the wizard in code view?

If I have a query like:
(a=6 AND b=4) OR ((b=7 OR c=9) AND e=11)
can that be processed? If the brackets can be dispensed with if I know more
about heirachy of Boolean operators then just tell me to go away and find
out.

Can somebody point me at a summary of the pros and cons of using SQL with
Access and FP as against the 'inbuilt' FP/Access interface?

Finally, if SQL seems a more powerful option, can someone point me at a good
online tutorial in SQL?

Thank you,

novus

 

[Kevin Spencer]

The FrontPage Database Results components allow you to create a custom SQL
statement if you like. In case you don't know, SQL (Structured Query
Language) is an ISO Standardized language for creating queries to databases.
Many people seem to confuse the language with Microsoft's database server,
SQL Server. So, from your message, it's lkind of hard to tell which you are
referring to in different places. I'm not sure what your second question
("pros and cos of using SQL with Access and FP..."), or your third question
("...if SQL seems a more powerful option...") means.

The syntax of SQL varies slightly from one database product to another.
However, you could certainly construct a complex WHERE condition in a SQL
statement similar to what you posted.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[novus]

Thank you.

It appears it would be worthwhile for me to go and learn something about SQL

novus