ACCESS中又一个和sql不同的地方：时间字段。Sql中时间以Date类型插入没有问题，但Access中就有问题了，会提示“标准表达式中数据类型不匹配”，把要插入的时间提前转换成String类型就不会报错了。尽管Access存在各各样的缺点，但它便于携带和不需要安装的优点还是体现了生存价值。如下代码： &n2014年8月20日
access 标准表达式中数据类型不匹配
ACCESS中又一个和sql不同的地方：时间字段。Sql中时间以Date类型插入没有问题，但Access中就有问题了，会提示“标准表达式中数据类型不匹配”，把要插入的时间提前转换成String类型就不会报错了。尽管Access存在各各样的缺点，但它便于携带和不需要安装的优点还是体现了生存价值。如下代码： &n阅读全文... | 分类:编程学习 | 评论:0 | 引用:0 | 浏览:
内容搜索
赞助商
文章归档
- 2019 November (1)
- 2019 September (4)
- 2018 September (1)
- 2018 April (1)
- 2018 March (1)
- 2018 February (1)
- 2017 October (1)
- 2017 September (2)
- 2017 August (1)
- 2017 May (1)
- 2016 June (2)
- 2016 February (1)
- 2016 January (3)
- 2015 December (5)
- 2015 November (6)
- 2015 October (4)
- 2015 September (1)
- 2015 June (3)
- 2015 May (1)
- 2015 April (1)
- 2015 February (3)
- 2015 January (1)
- 2014 December (2)
- 2014 September (1)
- 2014 August (4)
- 2014 July (11)
- 2014 March (1)
- 2014 January (3)
- 2013 December (1)
- 2013 November (1)
- 2013 October (2)
- 2013 September (4)
- 2013 June (4)
- 2013 May (2)
- 2013 April (1)
- 2013 March (3)
- 2013 February (3)
- 2013 January (4)
- 2012 December (5)
- 2012 November (9)
- 2012 October (3)
- 2012 September (7)
- 2012 August (4)
- 2012 July (1)
- 2012 June (1)
- 2012 May (1)
- 2012 April (2)
- 2012 March (3)
- 2012 February (1)
- 2012 January (3)
- 2011 December (1)
- 2011 November (4)
- 2011 October (2)
- 2011 September (3)
- 2011 August (2)
- 2011 July (4)
- 2011 June (6)
- 2011 May (2)
- 2011 April (4)
- 2011 March (4)
- 2011 February (4)
- 2011 January (5)
- 2010 December (3)
- 2010 November (4)
- 2010 October (7)
- 2010 September (8)
- 2010 August (5)
- 2010 July (2)
- 2010 June (3)
- 2010 May (3)
- 2010 April (4)
- 2010 March (4)
- 2010 February (8)
- 2010 January (11)
- 2009 December (17)
- 2009 November (24)
- 2009 October (25)
- 2009 September (22)
- 2009 August (21)
- 2009 July (20)
- 2009 June (43)
- 2009 May (47)
- 2009 April (12)