Topic: Which character is sent when clearing a field?

I am playing around with your fantastic application and I would like to understand which character the application send to the database to clear a field?

If I edit a field which was 'null' usind the function "Edit" in a formand save it, everything is Ok. Example: set Firstname to 'Test1'

If I delete this new information then Save (delete Firstname 'Test1'), I cannot retrieve this row using the following sql Query:

select * from <table> where <column> is null or <column> =' '

Which Query should I use?

Re: Which character is sent when clearing a field?

I'm afraid I do not quite understand your question.
Please, send me your test project to support@drive-software.com


Thanks.

Dmitry.

Re: Which character is sent when clearing a field?

Sorry if I was not clear enough.

I have a table with imported data, some of the columns are null as data is missing.


if I run select * from table where Firstname is null or Firstname =' '

I get this result:

Firstname | Lastname | UserID | Department | Extn
                 | dataxyz    | xxxx      |xxxx             | 1234


sometimes Column Firstname is null so I edit this column by inserting something let's say "Thierry".

Once this data saved, I can retrieve the information with Firstname = "Thierry"

Now, if I delete the data in Firstname ( delete "Thierry") but leave the other column, the row is still there but I cannot find it if I use the SQL query:

select * from table where Firstname is null or Firstname =' '


result is :
Firstname | Lastname | UserID | Department | Extn


instead of :

Firstname | Lastname | UserID | Department | Extn
                 | dataxyz    | xxxx      |xxxx             | 1234

Why? smile

Re: Which character is sent when clearing a field?

Never mind, I am really sorry, I found the error im my Sql query, I am too tired at the moment.... sorry!