[vicsireland] Re: SQL and VBA - what fun
- From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Fri, 2 Feb 2007 12:13:22 +0100
Hi Tony!
Sure it's just an example I hammered out. As an SQL query on its own
it's OK. But try to use it for a recordset variable in VBA. I.E. Set rs1
= db1.OpenRecordset("SELECT etc ")
The error message says "missing operator in SQL query". It's probably
just something like using brackets in stead of braces, but I can't work
it out.
Cheers,
Robbie
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Murray
Sent: Donnerstag, 1. Februar 2007 14:13
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: SQL and VBA - what fun
Hey Robbie,
Looks pretty standard to me, and it parses ok in SQL Server 2000's query
analyser.
What error is being thrown?
On another point entirely, if those table names and field names are not
aliases... I'd suggest revisiting your naming conventions though!;)
Take it easy,
Tony
----- Original Message -----
From: "Sandberg, Robert" <robert.sandberg@xxxxxxx>
To: <vicsireland@xxxxxxxxxxxxx>
Sent: Thursday, February 01, 2007 1:43 PM
Subject: [vicsireland] SQL and VBA - what fun
Hi folks!
Below is a simple SQL query, which I want to trigger in a VBA module.
I'm only familiar with the syntax used in Office 97. Something must have
been changed because I can't get it to work in Office 2003. Can anyone
enlighten me?
INSERT INTO t3 ( f1, f2, f3 )
SELECT t1.f1, t1.f2, t1.f3
FROM t1 INNER JOIN t2 ON (t1.f3 = t2.f3) AND (t1.f2 = t2.f2) AND (t1.f1
=
t2.f1);
Cheers,
Robbie
******************************************************
This document is strictly confidential and is intended for use by the
addressee unless otherwise indicated.
This email has been scanned by an external email security system.
Allied Irish Banks
******************************************************
Other related posts: