Selecting – Empty – within Bulk Edit on integer fields causes SQL error

QuestionsSelecting – Empty – within Bulk Edit on integer fields causes SQL error
Richard Samson asked 4 years ago

I have a select (drop down) field configured where users select a name and the respective employee id is written to the mySQL database field.  The database field is set an integer data type.

During normal record editing if I set that field blank the database entry write a Null.

However, if I select ” – Empty – ” during bulk editing it’ll try and set those fields to “” instead of Null, resulting in a incorrect integer SQL error.

Is there a way to ensure the ” – Empty – ” option writes Null values instead of “” for this column?  I’ve tried the isnull column parameter but that doesn’t appear to make a difference.

Thanks.

 

 

2 Answers
Abu Ghufran Staff answered 4 years ago

Hi,

I’ve emailed you latest build. It should make ‘isnull’ property work as expected.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Richard Samson answered 4 years ago

I’ve just tested with the updated version and it now works superbly.  Many thanks for your excellent support.

Your Answer

2 + 7 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?