How to check if datefield is empty in AFTER RECOD UPDATED event ?

Have you tried

Thanks for your quick reply. I didtry it now. Unfortunately, also now the query still updates the other table with the 00-00-0000 value
"

$sql = "UPDATE orderinhoud, order

SET orderinhoud.orderbevestiging = '".$values['orderbevestiging']."'
WHERE (orderinhoud.orderbevestiging IS NULL OR orderinhoud.orderbevestiging = '') AND order.orderbevestiging!='0-0-0000'AND order.orderbevestiging IS NOT NULL AND order.orderbevestiging != 0 AND order.orderbevestiging <>'' AND order.orderbevestiging <>'0-0-0000' AND orderinhoud.orderid='".$values['id']."'";
db_exec($sql);

"

In the meantime I tried many different things. But always the same result:
$sql = "UPDATE orderinhoud, order

SET orderinhoud.orderbevestiging = '".$values['orderbevestiging']."'
WHERE (orderinhoud.orderbevestiging IS NULL OR orderinhoud.orderbevestiging = '')

AND '".$values['orderbevestiging']."' IS NOT NULL

AND order.orderbevestiging != 0

AND order.orderbevestiging !='0000-0-0'

AND order.orderbevestiging !='0000-00-00'

AND order.orderbevestiging !='0000-00-00 00:00:00'

AND order.orderbevestiging !='00-00-0000'

AND order.orderbevestiging !='0-0-0000'

AND order.orderbevestiging IS NOT NULL

AND order.orderbevestiging != 0

AND order.orderbevestiging <>''

AND order.orderbevestiging <>'0-0-0000'
AND orderinhoud.orderid='".$values['id']."'";
db_exec($sql);

/*
nothing works. I hope someone has an idea

Assumming you are working on another table and after updating it, you want to update another 2 tables: order and orderinhoud in the background.
Your query statement itself that you update 2 tables at one go is quite dangerious practice in my view and hard to troubleshoort when there is problem (like in this case).
For readability and ease of troubleshooting, you maybe need to break the update query into 2 parts, so in after update event of the form, try this:
$orderbevestiging = $values['orderbevestiging'];

$id = $values['id'];
// do your checking for empty or null field here, then update accordingly

if ($values['orderbevestiging'] == "" OR $values['orderbevestiging'] == NULL)

{

$sql = "UPDATE order SET orderbevestiging = '$orderbevestiging' WHERE orderid= $id ";

db_exec($sql);

}

else

{

$sql = "UPDATE order SET orderbevestiging = '$orderbevestiging' WHERE orderid= $id ";

db_exec($sql);

$sql = "UPDATE orderinhoud SET orderbevestiging = '$orderbevestiging' WHERE orderid= $id ";

db_exec($sql);

}
Hope it helps

ACP

Thanks a lot ACP!!
This did the trick. specially, taking the values out with the first 2 lines. Somehow that works for dates better then in the SQL query. I am not completely sure where the first statement is for:
$sql = "UPDATE order SET orderbevestiging = '$orderbevestiging' WHERE orderid= $id ";
in this case you update the table order with its own values, but that is already done in phprunner right? Or is there another reason.
Anyway, unless the above has a special reason, I have a working code now as follows:
$orderbevestiging = $values['orderbevestiging'];

$id = $values['id'];
// do your checking for empty or null field here, then update accordingly

if ($values['orderbevestiging'] != "" OR $values['orderbevestiging'] != NULL)

{

$sql = "UPDATE orderinhoud SET orderbevestiging = '$orderbevestiging' WHERE (orderinhoud.orderbevestiging IS NULL OR orderinhoud.orderbevestiging = '') AND orderid= $id ";

db_exec($sql);

}
Thanks a lot! Really appreciated! If you are a PHPrunner expert, and looking for some commercial work, let me know as I am looking for someone to help me out many times :-) :-)

Hi,
"I am not completely sure where the first statement is for:

$sql = "UPDATE order SET orderbevestiging = '$orderbevestiging' WHERE orderid= $id ";

in this case you update the table order with its own values, but that is already done in phprunner right? Or is there another reason."
ACP: This is due to misundertood your question. I mentioned: "Assumming you are working on another table and after updating it, you want to update another 2 tables: order and orderinhoud in the background." Because you did not state you are actually working on order table itself and your codes looked like you are working on a 3rd table that will update order and orderinhoud in the background.
For the code you paste, please look at my comment below:

Thanks a lot! Really appreciated! If you are a PHPrunner expert, and looking for some commercial work, let me know as I am looking for someone to help me out many times :-) :-)

[/quote]
ACP: No, not expert but creating app using phpr is fun for me sometimes <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=87747&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Glad it helped.
ACP.