Procedure Statement in Access SQL (2000)

Topic

New Reply

Hi,

I was trying this query:

TRUNCATE TABLE ;

in Access’ SQL view and it prompted me with something that approximately translates to:[indent]

---

Invalid SQL statement; ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELECT’ or ‘UPDATE’ statement expected.

---

[/indent]My question is not why it doesn’t accept TRUNCATE TABLE, but rather what is a PROCEDURE statement and what does it do?
And further, is Access SQL documented somewhere? I started studying it via web resources about a year ago and still find unveiled chunks every while — eg. I found that Access SQL accepts the IIF function about a month ago.

Thank you in advance

Reply | Quote

Replies

There is no statement called TRUNCATE in Access, are you trying to do this from Access to a SQL Server backend?

Reply | Quote

I realized the moment Access prompted me. That’s why I said it wasn’t my question .

Reply | Quote

Sorry, i missed that point, must be going blind or senile.

A procedure is code in VBA that can be behind a form, report or a module.

Reply | Quote

Hello Pat
[indent]

---

A procedure is code in VBA that can be behind a form, report or a module.

---

[/indent]In this case, I had a hunch it was something different. In the link Hans provided there’s a description of SQL Procedures (I haven’t read it in full detail yet).

Reply | Quote

I don’t know exactly how to get it in Access 2000, but you should be able to get to Microsoft Jet SQL Help from the contents of the built-in Access help.

Access SQL understands most VBA functions.

For a description of the PROCEDURE keyword, see Advanced Microsoft Jet SQL for Access 2000 (Microsoft Access 2000 Technical Articles).

Reply | Quote

Hi Hans,

Thanks for that! It seems a quite comprehensive resource. I’ll read it in more detail over the next days.

Reply | Quote

This link: http://sqlserver2000.databases.aspfaq.com/…sql-server.html%5B/url%5D might come in handy. I’ll leave it here for (my ( )) future reference.

Reply | Quote

Thanks, I’m sure it’ll be handy for others too.

Reply | Quote