I would like to ask that what can I do, if I want to run an update 

query, which contains some date fields (ergo in the query i put it 

between hashes (#), and if it wasn't given a value, then the I get a 

really nice error that it couldn't interprete the ## expression on 

query string.

 any ideas?

thanx a lot,

Peter

Hi,



I can suggest you one thing, You can do the

client-side Validation on datevariable for not empty

before passing it to the query, so that always you

will pass some value. or if its empty you can pass

some default value.



Regards

Vijay.G



--- Zsoldos_Péter <paz@c...> wrote:

> I would like to ask that what can I do, if I want to

> run an update 

> query, which contains some date fields (ergo in the

> query i put it 

> between hashes (#), and if it wasn't given a value,

> then the I get a 

> really nice error that it couldn't interprete the ##

> expression on 

> query string.

>  any ideas?

> thanx a lot,

> Peter

> 

Hi,

yeah, I know that would be the most obvious & easiest solution, but 

unfortunately I cannot use that alternative :(

I need to make my SQL statement bombproof that it would run with empty 

date fields....

so, still, anybody any idea?



 peter

> Hi,

> 

> I can suggest you one thing, You can do the

> client-side Validation on datevariable for not empty

> before passing it to the query, so that always you

> will pass some value. or if its empty you can pass

> some default value.

> 

> Regards

> Vijay.G