我将用vb+access写的软件转移到vb+sql7下,却发现access中支持的format和iif函数到sql下统统不支持了,有解决办法吗??
多谢!!
---------------------------------------------------------------
iif函数可以用CASE代替.
format用CONVERT或者CAST代替.
---------------------------------------------------------------
As so.
Function Format,iif is some function can be used in jet sql
exact speaking, they are some function in VBA.
But in sql u can change format into convert or cast and
change iif into case .. when .. then .. [else ..] end