This is a puzzeler. Wierd things are happening.
Two table, one set database. Report is based on the set. Now the wierd stuff.
I entered this expression into the Report's Detail Properties filter:
between(Income->Date,Var->Askd_Enter_Begin_Date,Var->Askd_Enter_End_Date)
Click the expression button and:
Sometimes get the message, Invalid Field Value.
Sometimes the prompt for the end date pops up before the prompt for the begin date.
Sometimes can click OK the end date prompt pops up before the begin date prompt.
Sometimes the above expression is typed in letter by letter with the above results. Sometimes it's type in and it works with no hangups.
Sometimes the above expression is copied in from another report, sometimes it works and sometimes any one of the above happens.
Most the time, it shows only records for the year 1998 rather than '91 - '00.
Once I got it to show all records but that stopped.
I've packed the tables, ran scan disk (no errors), even tried kissing the computer. It didn't like that either. Hmm, maybe I forgot a breath mint! I did brush my teeth. What more does it want??
If you've followed my previous post, you're somewhat familar with the situation. Stan (Bless his heart)finally got the files I zipped to him, straighted out. I tried what he did (all but the update operation as I couldn't figure out how to apply the Remspecial, I'm tired).
I could copy his zipped files but I would like to know what's causing the problem. I'm afraid if I don't, it could crop up again and when this little gem is deployed, I don't need it going 51-50 (crazy).
Does Alpha have a program that anaylizes databases, finds bad expressions or whatever? Or is there a software program that will do this?
Thanks for any and all suggestions.
kenn
Two table, one set database. Report is based on the set. Now the wierd stuff.
I entered this expression into the Report's Detail Properties filter:
between(Income->Date,Var->Askd_Enter_Begin_Date,Var->Askd_Enter_End_Date)
Click the expression button and:
Sometimes get the message, Invalid Field Value.
Sometimes the prompt for the end date pops up before the prompt for the begin date.
Sometimes can click OK the end date prompt pops up before the begin date prompt.
Sometimes the above expression is typed in letter by letter with the above results. Sometimes it's type in and it works with no hangups.
Sometimes the above expression is copied in from another report, sometimes it works and sometimes any one of the above happens.
Most the time, it shows only records for the year 1998 rather than '91 - '00.
Once I got it to show all records but that stopped.
I've packed the tables, ran scan disk (no errors), even tried kissing the computer. It didn't like that either. Hmm, maybe I forgot a breath mint! I did brush my teeth. What more does it want??
If you've followed my previous post, you're somewhat familar with the situation. Stan (Bless his heart)finally got the files I zipped to him, straighted out. I tried what he did (all but the update operation as I couldn't figure out how to apply the Remspecial, I'm tired).
I could copy his zipped files but I would like to know what's causing the problem. I'm afraid if I don't, it could crop up again and when this little gem is deployed, I don't need it going 51-50 (crazy).
Does Alpha have a program that anaylizes databases, finds bad expressions or whatever? Or is there a software program that will do this?
Thanks for any and all suggestions.
kenn
Comment