HELP

gushangluoye

String si, SubStr, name;
   si = DateToStr (Date ());
   SubStr = si.SubString (5, StrToInt (si.Length ()-2)); / * Remove the month and day of the birth date * /
   data-> personquery-> Close ();
   data-> personquery-> SQL-> Clear ();
   data-> personquery-> SQL-> Add ("select * from perinf where birthday like '%" + SubStr + "%'");
   data-> personquery-> Open ();
   if (data-> personquery-> RecordCount! = 0)
{while (! data-> personquery-> Eof)
    {
     name = data-> personquery-> FieldValues ​​["name"];
     data-> personquery-> Next ();
     }
   ShowMessage ("Today is'" + name + "'' s birthday, go and send my best wishes!");
} Query results are not possible, there may be a problem with the SQL statement. Please advise, how to write

delraich

It may be that the number you get when you take out the birth month and day is "-1-5" in 2017-1-5.
Change it like this:
si=Date().FormatString("yyyymmdd");
The data taken out in this way is that the birth month and day are "0105".
StrToInt(si.Length()-2);'//StrToInt is not needed here, si.Length() is of type int.

光明之行者

It is really difficult to grasp the date and time!
It's better to know what format the date and time are in your database first, and then use FormatDateTime() to format the date of the day you get to obtain the month and day information.
As for the SQL statement, if your birthday field is in a short date format, it might be better to write LIKE'____-"+strMonth+"-"+strDay+"'

gushangluoye

Thank you very much for your attention, but I hope to write more details. I have tried both methods and the record is still 0. For example, if the first one is 0105, how to write sql statement. The format in my library is 2016-1-5. Thank you. Very anxious

光明之行者

Sorry, the following is the positive solution: (applicable to SQL Server, Access and other MS databases)
AnsiString SssMonth=FormatDateTime("M",Date()); //Get today's month
AnsiString SssDay=FormatDateTime("d",Date()); //Get today's day

AnsiString SQLStr="SELECT * FROM perinf WHERE (MONTH(birthday) = "+SssMonth+") AND (DAY(birthday) = "+SssDay+")";

...

data->personquery->SQL->Add(SQLStr);

...

You have already written the omitted parts

光明之行者

The birthday field in your database must be DateTime