Hello Erel,
since I have tested the new SQLite.dll, my wish is a new command for the DLL.
It's name should be ClearParameter or something like that.
The background for this wish is the different way for handling DATE- or TIME- values in SQLIte v3.6.3 and in the moment I have no other solution to show SQL-DateTime in a ListView(ControlsExDevice) or Combo-field by using a table, filled with values by the SetParameter command:
If I added a parameter and used it at the first time and set no value to it, because there was no value, SQLite accepted the resulted NULL value and did show a blank field.
If I used this parameter before, for a valid DateTime value, and the next Row had no entry in the same column, the Date from the previous row was shown in the field.
Using of "null" or "" for a column with a DateTime-Value results in an errror:
"No valid DateTime value."
If there is a way to set the Parameter to NULL or to clear it, would this be very nice, because it will solve another problem in the program.
:sign0085:
best regards
berndgoedecke
since I have tested the new SQLite.dll, my wish is a new command for the DLL.
It's name should be ClearParameter or something like that.
The background for this wish is the different way for handling DATE- or TIME- values in SQLIte v3.6.3 and in the moment I have no other solution to show SQL-DateTime in a ListView(ControlsExDevice) or Combo-field by using a table, filled with values by the SetParameter command:
If I added a parameter and used it at the first time and set no value to it, because there was no value, SQLite accepted the resulted NULL value and did show a blank field.
If I used this parameter before, for a valid DateTime value, and the next Row had no entry in the same column, the Date from the previous row was shown in the field.
Using of "null" or "" for a column with a DateTime-Value results in an errror:
"No valid DateTime value."
If there is a way to set the Parameter to NULL or to clear it, would this be very nice, because it will solve another problem in the program.
:sign0085:
best regards
berndgoedecke