View Single Post
  #6 (permalink)  
Old September 23rd, 2011, 08:09 AM
dpm1057 dpm1057 is offline
Registered User
Points: 19, Level: 1
Points: 19, Level: 1 Points: 19, Level: 1 Points: 19, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Sep 2011
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default WHERE clauses are a correct

Hi Geoffrey,

Thanks for trying to help with this, but I am starting to think that the issue is with one of the other pieces of code. This morning I took a copy of the working code from the example database. The example had 2 IF statements, on that looked at a text based combo box and the other that looked for a price. I deleted the price statements. Then I edited the text process by copying the object names from the forms property window and pasting them over the corresponding names from the sample code.

I even toyed with using the brackets around my table and field names. I still get the Error 2580, but then is shows me a valid WHERE clause with the message.

I am starting to wonder if it is my field names and how the ParseSQL and RepalceWhereClause procedures work. Both my field names have under scores in them. INVISION_CUSTOMER_NAME or Target_Go_Live. Could those underscores be throwing the process off?