Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Recordset

Status
Not open for further replies.
dhaveedh

dhaveedh

Programmer
Aug 13, 2003
112
GB
Hi,

I am running a query in VBA which is using ADO to connect to an oracle database.

While stepping through the code I get this error:

ORA00933:SQL Command Not Properly Ended

Does anyone know the solution to this aggro?

KISS - Keep It Simple Sugar!
 
Sort by date Sort by votes
Hi,
Can you check your code to make sure you have included the semicolon (;) at the end of your SQL statement?

HTH, [pc2]
Randy Smith, MCP
rsmith@cta.org
California Teachers Association
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Empty recordset stops 1
Replies
3
Views
446
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Adodo problem
Replies
7
Views
547
dhookom
dhookom
lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
493
Andrzejek
Andrzejek
xweyer
  • Locked
  • Question
Problem Using Variable as Field Name with DAO Recordset 1
Replies
5
Views
686
Andrzejek
Andrzejek
dasalight
  • Locked
  • Question
DAO Recordset Entries in Table Do Not Stay Saved
Replies
1
Views
231
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top