SQL Queries

  • Thread starter Thread starter Steve Grosz
  • Start date Start date
S

Steve Grosz

When creating SQL queries to get data from Access, or
whatever database from within FP2003, do you need to
create a variable to modify the query on the fly, or can
you just use the form field name in the query.

Thanks,

Steve
 
-----Original Message-----
When creating SQL queries to get data from Access, or
whatever database from within FP2003, do you need to
create a variable to modify the query on the fly, or can
you just use the form field name in the query.
Click to expand...

If you're using the Database Results Wizard, enter the
form field name surrounded by double colons. For example:

SELECT * FROM mytable WHERE empname LIKE '::txtname::%'

However, it's usually easier to click the More Options
button on page 3 of the wizard, click Criteria, and use
the GUI to specify the criteria you need.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Back
Top