This is a multi-part message in MIME format.

------=_NextPart_000_0007_01C07EF4.806A3D20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Try " ' "  (single quote) instead of "#".

Regards,

Takuya





-----Original Message-----
From: Bart Vandenheede [mailto:bvandenheede@i...]
Sent: 13 January 2001 01:02
To: sql language
Subject: [sql_language] SQL Statement Access vs SQL



Hellow,

I have the following SQL statement  :

strSQL =3D "INSERT INTO tblUser (user_id,login, pasword,firstlogin,
lastlogin) values ('" & lngLastUserID & "','" & strEmail & "','" &
strPaswoord & "',#" & Date & "#,#" & Date & "#)"

it runs perfect against an Access Database but

it gives the following error agains an SQL 7 database :

[Microsoft][ODBC SQL Server Driver][SQL Server]The name '#12' is not
permitted in this context. Only constants, expressions, or variables
allowed here. Column names are not permitted.

i think there's something wrong with the dates ... is there an other
notation for dates for sql databases?

Thx in advance !

Bart Vandenheede
www.vandenheede.be


$subst('Email.Unsub')