>OConn = CREATEOBJECT("ADODB.Connection") >OConn.ConnectionString = "provider=vfpoledb.1;; > data source=c:\\mydata\;Exclusive=false;Nulls=false" >OConn.Open > >cSQL = "select id, name, IIF(EMPTY(date1), null, date1) AS date1 from mytable WHERE id = myid' ORDER BY id" &&does not work >cSQL = "select id, name, IIF(EMPTY(date1), {}, date1) AS date1 from mytable WHERE id = myid' ORDER BY id" &&Date1 = 12/30/1899 >oRS = OConn.Execute (cSQL) > >oRS.Close >OConn.Close >>
OConn = CREATEOBJECT("ADODB.Connection") OConn.ConnectionString = "provider=vfpoledb.1;data source=c:\\mydata\;Exclusive=false;Nulls=true" OConn.Open cSQL = "select id, name, IIF(EMPTY(date1), null, date1) AS date1 from mytable WHERE id = myid ORDER BY id" &&does not work oRS = OConn.Execute (cSQL) oRS.Close OConn.Close