>I can't pass an SQL statement due to a syntax error when I use SQLEXEC(). I've connected (using VFP 6)
>to an Access 97 database with a table called 'Budget Contract'. I would love to rename the table, but it won't
>be possible. Here's the problem...
>
X =SQLEXEC(nh,'SELECT * FROM
[BUDGET CONTRACT]')
&& works fine as long as the double-quotes are
> && within the single quotes, but not vice versa
>
X = SQLEXEC(nh,'INSERT INTO
[BUDGET CONTRACT](EMP_NO) VALUES('9999')') && won't work
> && because it won't accept any quote or space
> && between the table name and EMP_NO field.
>
>Both VFP commands work well when I rename the table with an underscore in its name. Any help would be
>appreciated. I thank you in advance.
Use brackets. See changes in
bold above.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao