Submitted by lucky_phil on 2014/02/03 21:23
 I have a DB, that I derived from the Sample, and have been using for some time, and some functionality, like Default for a date field being =int(now()) simply does not work any more. I cannot find any way to find out why???
 
I have confirmed that this does work as per the documentation in a new file, so would appear to relate to something I have done in mine, but how does one find out what the problem is? No errors, no debugging. Sorry, when I say that, if I turn on Error logging, I do get:
 
"4/02/2014 1:18:33 pm 91 2 MDIForm_Load 4/02/2014 1:18:33 pm 91 Object variable or With block variable not set(l=0) MDIForm_Load" in the ErrorLog file, but VBA modules compile all OK. I cannot find problem.
 
Can someone please help?

 

Comments

Hi,
(Long time no see!)
 
Here int(now) works fine; however, note that the default value only appears when you double click on the cell (EDIT:  or press enter 2 times while focus is on the cell). It isn't calculated automatically when you create the item. I believe it's always been like that.
 
If what you want is a "now" date value to be added every time you create an item, you could add 
 
A:date=int(now)
 
In the item field's auto-assignment rules (equations section of the Field Properties dialog/window).
 
But maybe this isn't your problem... In which case it could be a problem with your DB or your installation.
 
 
-------------------------------------------------------
Windows 8
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

>I have confirmed that this does work as per the documentation in a new file
 
Did you try opening your DB with a new separate IQ "install", using the portable version in a new and separate folder (no user code of yours or other stuff from previous usage) ?
 
-------------------------------------------------------
Windows 8
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Hi Phil,
 
A screen shot of the field properties would help !