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
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.
Summary: The information in a record will be updated if it's changed. As for the additional field on the form, add another field to your table and add that field to your form. If you type information into tha...
Summary: I have a form with a formula in one field that divides one field by another to obtain the cost per case. the formula works in the form but does not update to the table. What am I doing wrong? ...
Summary: I am creating a form to track information for numerous construction jobs. The form has about 20 fields. One of the fields I have created is a "Last Update" field. I want this field to update to the...
