CREATE PROCEDURE

[Vladimir]

Hello,

When I try to execute the following statement in Query Designer:

CREATE PROCEDURE RWUInsert val1 integer, val2 integer as insert into
regwateruse (regid, year) values(val1, val2);

I get the following error:

"Syntax error in CREATE TABLE statement."

What is the problem?

Regards,
Vladimir.

 

[Lynn Trapp]

Is this a pass-through query to a client/server database or an Access query?

 

[Michel Walsh]

Hi,


In the immediate debug window, cut and paste the following:


CurrentProject.Connection.Execute"CREATE PROCEDURE RWUInsert (val1 integer,
val2 integer) as insert into regwateruse (regid, [year]) values(val1, val2)
"



Two observations:
- MOST Jet 4.0 extensions do not work in the query
designer, neither with DAO,
- Year is a reserved word, I have to use [year] to
indicate a field, in this context.



Hoping it may help,
Vanderghast, Access MVP