problem in date (my first project)

thank you

COUNT(id)    what this do ???
<> 0) then Cancel := True;  --   this to check that date picker not empty , right  ???

and how to save from DateTimePicker1 to table direct as date , do you have idea ???

Thanks Again

COUNT(id)    what this do ???
<> 0) then Cancel := True;  --   this to check that date picker not empty , right  ???

and how to save from DateTimePicker1 to table direct as date , do you have idea ???

1.  COUNT(id) FROM tempx WHERE Date='+ Form1.DateTimePicker1.sqlDateTime) <> 0)
This checks to see if the date you are entering already exists (<> 0) as you don't want to allow duplicates.  You could write count(id) or count(*) or use any mandatory field - it's just to use something that will always be present in the record.
2.  <> 0) then Cancel := True;
This cancels the 'save' action if a duplicate date exists (ie <> 0) - if it is 0 then the record is saved.  If you want to prevent an empty date from being saved, then specify it as mandatory in your data schema.
3.  SQLite does not have a native 'date' format - dates are stored as strings and converted by the program into any date format that you specify at run time.
Derek.

Here is the code

   begin
                       code1.Edit3.Text  := DateToStrcode1.DateTimePicker2.DateTime);
                           if ( SQLExecute('SELECT COUNT(id) FROM tempx WHERE Date1='+ code1.DateTimePicker2.sqlDateTime) <> 0) then
                           begin
              SQLExecute('INSERT INTO tempx (Date1) VALUES("'+FormatDateTime('yyyy-MM-DD', code1.DateTimePicker2.datetime)+'")');
                        newRow := absent_teacher.TableGrid1.RowCount;
                   code1.TableGrid1.InsertRow(newRow);
                 code1.TableGrid1.Cells[0, newRow] := code1.Edit3.Text ;
  end;

Hi Derek

Lara.0080, First we need to explain about the format.
Date and DateTime are stored in the SQLite database as "2024-03-12 12:25:09.000". If you want to compare only the date you need to extract the date from this format. In SQLite you can use the Date() function. If you do not select the date, then changing any number over time will not allow you to make a correct comparison.
In your case it will look something like this
WHERE Date (Date1)=Date ('+ code1.DateTimePicker2.sqlDateTime +' )
You need to become more familiar with SQLite.

Also note that Derek uses sqlDate in his examples, which allows you to store date + time with zeros in the database. This makes later comparisons easier. However, if you are storing real time, you will need to use the Date() function in SQLite.