Author Topic: Mysql and clarion (Read 3606 times)

olu · « **on:** February 02, 2013, 03:14:12 AM »

Please can anyone help with this, I have moved one of my application to MySQL and most of it works fine but just stuck on how to check for zero value with clarion code e.g
Engagement:DateReportSent = ''-(this is a date)
Engagement:Period = 0 -(this is a long)
Thanks

olu · « **Reply #1 on:** February 06, 2013, 12:59:32 AM »

please anybody on this?

kevin plummer · « **Reply #2 on:** February 06, 2013, 04:08:31 AM »

try Engagement:DateReportSent = '' or Engagement:DateReportSent = 0

I think a blank date returns zero but should be easy enough to put in a debug point to see the value. It could even be null...

lanmicro · « **Reply #3 on:** February 06, 2013, 11:03:49 AM »

Hi,

In my MySQL data the dates are NULL so I use:

Engagement:DateReportSent is NULL

NetTalk Central

Author Topic: Mysql and clarion (Read 3606 times)

olu

Mysql and clarion

olu

Re: Mysql and clarion

kevin plummer

Re: Mysql and clarion

lanmicro

Re: Mysql and clarion