The error is not when I try to put it into a test box...it appears immediatlely when I try to access the data immediately after the set statements.
Any other suggestions.... I'll look at them all.
Thank you !!
dave jones
Last Activity: Apr 1 '11, 03:36 PM
Joined: Mar 28 '11
Location:
-
-
VB5 problem when selecting data from SQL
I am currently importing data from an SQL table into a local array in VB5. It goes along fine but then I get the following error:
Run-time error 3163 The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data
The code involved is:
[Set dclpkv = rN2.Fields(1)
Set dclfn = rN2.Fields(2)
Set dclnv = rN2.Fields(3)
Set dclisd... -
I also tried
[Set rN2 = dbs2.OpenRecord set("SELECT chn_lg_pk, chn_lg_table_na me, chn_lg_pk_value , chn_lg_field_na me, chn_lg_new_valu e, chn_lg_is_delet e, chn_lg_usr_fk, chn_lg_date_tim e , chn_lg_dmn_fk , chn_lg_bt_versi on From cw_change_log WHERE (chn_lg_new_val ue LIKE 'zzz1234')")]Leave a comment:
-
Also, this queery is copied from the enterprise manager where it works. I'm trying to automate a couple of things thru VBLeave a comment:
-
How do I do an extended SQL search with "where" from VB5
Currently I have [Set rN2 = dbs2.OpenRecord set("SELECT chn_lg_pk, chn_lg_table_na me, chn_lg_pk_value , chn_lg_field_na me, chn_lg_new_valu e, chn_lg_is_delet e, chn_lg_usr_fk, chn_lg_date_tim e , chn_lg_dmn_fk , chn_lg_bt_versi on From cw_change_log WHERE (UCASE(chn_lg_n ew_value) = 'zzz1234')")\]
where zzz1234 is the encoded id number. If I take the "where" clause off, I get results. If I use the "where" clause,...
No activity results to display
Leave a comment: