VFP 愛用者社區

[Ruey]

Dates and DateTime in a SQL-Select



Q: I recently changed the properties on some SQL views so that they would display dates instead of datetimes. Now this union made for a print job will not work:

select * from vwmd, vwmdgrp INTO cursor mdboog ;
where vwmd.mdnum=vwmdgrp.mdnum ;
UNION select mdnum, mdlast, mdfirst, mdaddr1, mdaddr2, mdcity, ;
{ / / :AM}, { / / :AM};
from vwmd where mdnum not IN;
(select mdnum from vwmdgrp)
saying "SELECT are not union compatible" i believe the blank datetime is to blame. how do i change the ,{ / / :AM},{ / / :AM}; to reflect the date component, or is that the problem?

A: Try one of these three:

{/} will give you a blank date


{/:} will give you blank date time


ttod() always converts datetime to date
William Sanders (from the VFUG ListServe)