|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Programming A discussion forum for programs and programming used in tech-related businesses. |
 |
|
|
LinkBack | Thread Tools |
03-30-2007, 12:02 PM
|
#1 (permalink) |
|
I helped the forums.
Join Date: Nov 2004
Posts: 7
OS: xp
|
Pass text using vb6 to sql server 2003
Hi, I am using an XP maching, VB6 passing code to SQL Server 2003 and dumping data in an Access 97 database. I am trying send text to compare to field data and I get Error 3021, No Current record. The line of code is in the Where clause, some of the examples I've tried are:
PVCall & PVCall = " and CPT_Code = 'H0005'" PVCall & PVCall = " and CPT_Code = " & "'" & H0005 & "'" PVCall & PVCall = " and CPT_Code = " & chr(39) & "H0005" & chr(39) PVCall & PVCall = " and CInt(Mid(CPT_Code,2,4)) = 0005" Any suggestions? Thanks, Karen |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
