Computing.Net > Forums > Database > field not updating

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

field not updating

Reply to Message Icon

Name: hc54
Date: June 8, 2007 at 12:33:52 Pacific
OS: xp
CPU/Ram: 512
Product: ibm
Comment:

I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in analyzer and it worked fine there but is not working in the code. Here is the vb code:
sSQL = " UPDATE " & tablename
sSQL = sSQL & " SET field1 = ' ', "
sSQL = sSQL & " field2 = 'N'"
sSQL = sSQL & " WHERE RTRIM(field3) = " & variable1

Like I said, it works fine in query analyzer and I have arranged the order, tried setting it to null, gave it a actual value and nothing works.



Sponsored Link
Ads by Google

Response Number 1
Name: hc54
Date: June 8, 2007 at 13:03:27 Pacific
Reply:

never mind. I solved it.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: field not updating

Field auto-update in form www.computing.net/answers/dbase/field-autoupdate-in-form/370.html

Access 2002 www.computing.net/answers/dbase/access-2002/31.html

Access - automatically update date www.computing.net/answers/dbase/access-automatically-update-date-/443.html