Im running a VB program that updates my SQLserver 7 DB via an odbc connection.
I had a "Memory allocation failure" error on an update that I though was very simple see below
ccount = 1
refid = 018595
update TBL1 set fileCount = '" & ccount & "' where refid = '" & refid & "'
As I understand an update it will only updates the "SET" column and will only modify that element yet I got the Memory allocation failure error ???
is this right what iv been told that an update does not pull out the complete record contents when a set column is defined, it only modifies the column named in the SET ??? yes ???
What could cause this error ??