Insert Record Error
From: Sam (cybersam88_at_hotmail.com)
Date: 07/26/04
- Next message: Andrew Aronoff: "How to read "CompanyName" from a file"
- Previous message: Tobias Hirschi: "Re: Script uses lot of memory"
- Next in thread: Agoston Bejo: "Re: Insert Record Error"
- Reply: Agoston Bejo: "Re: Insert Record Error"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Jul 2004 16:45:45 +0800
Coding
--------
rsAdd = "INSERT INTO F0911C (GLDCT) VALUES"
rsAdd = rsAdd & " '0010'"
ConnSQL.Execute(rsAdd)
Set rsAdd = Nothing
Error Message
---------------
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '0010'.
/jde/F0911C.asp, line 98
Where is the error and please advise how to solve it?
- Next message: Andrew Aronoff: "How to read "CompanyName" from a file"
- Previous message: Tobias Hirschi: "Re: Script uses lot of memory"
- Next in thread: Agoston Bejo: "Re: Insert Record Error"
- Reply: Agoston Bejo: "Re: Insert Record Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
