ÅܼÆstring >255 ¦p¦ó¸Ñ¨M

user999

¦U¦ì¤j¤j±z­Ì¦n
¦bvba §Ú·Q±qÀx¦s®æ±a¤JÅܼưµ¦ý¶W¹L255­n¦p¦ó³B²zÁÂÁÂ
ex:
sqlcode = Replace(Worksheets("¦W³æ").Cells(counter, 6).Value, Chr(10), "")

faye59

¦^´_ 1# user999


    ¤£À´§AªºÅÞ¿è¡A
¦P¤@­Ó¦r¦ê­«ÂÐÂл\?
¯à´£¨Ñ§¹¾ã¬yµ{¤Î¥Øªº¶Ü?

c_c_lai

¦U¦ì¤j¤j±z­Ì¦n
¦bvba §Ú·Q±qÀx¦s®æ±a¤JÅܼưµ¦ý¶W¹L255­n¦p¦ó³B²zÁÂÁÂ
ex:
sqlcode = Replace(Workshee ...
user999 µoªí©ó 2019-1-31 09:09

§A±N sqlcode Åܼƨƥý«Å§i¦¨ String ´N¤£·|¦³°ÝÃD¤F¡C
String sqlcode ;

user999

¦^´_ 2# faye59

Replace(Worksheets("¦W³æ").Cells(counter, 6).Value, Chr(10), "")
replace ¬O­n§â¦³´«¦æ§ï¦¨ ªÅ®æ
¥Î¦³«Å§isqlcode ¬°string
¬O¤£¦æªº(255)

user999

¦^´_ 3# c_c_lai


    ¥Î¦³«Å§isqlcode ¬°string
¬O¤£¦æªº(255)

c_c_lai

¦^´_  c_c_lai


    ¥Î¦³«Å§isqlcode ¬°string
¬O¤£¦æªº(255)
user999 µoªí©ó 2019-2-13 08:07

¨º´N«Å§i¦¨
Variant sqlcode;
¦pªGÁÙ¤£¦æ¡A¨º´N§â¾ã¤äµ{¦¡¶K¤W§a¡I

­ã´£³¡ªL

¤£«Å§i¬°stringÀ³¤]¨S°ÝÃD,
¤W¶Ç¹ê¨Ò§a!