View Single Post
  #6 (permalink)  
Old May 5th, 2008, 08:17 PM
dparsons dparsons is offline
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

:shudders: Dynamic SQL >< Anywhooo.

Just glancing over this, there is a possible bug in the code provided in your where statement:
rsql = rsql & " WHERE Emp_ID='"& xemp_idx &"';"

In the first few lines you set the value of xemp_idx to that of an empty string and, from the code provided, you never give it a value so your code will evaluate to:

WHERE Emp_ID = '';

hth.
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========
Reply With Quote