符号转换问题? 急 ﹗﹗﹗
Dim txtSQL as string ,custid as string,custname as string,address as string
custid =”001”
custname =”Jan’DM+TG”
address =”BeiJing”
TxtSQL=”insert into customer values (‘” &custid &”’,’’’ &custname &”’,’” &address &”’)”
当我在执行这条SQL语句时﹐为customet新增记录时﹐就报错了
如果将 custname =”Jan’DM+TG” 改成 custname =”JanDM+TG” 才可以。
如果解决符号 ’ 的问题呢?