Passing missing values to a function from Query

[PEB]

When i'm trying to pass missing values to a function called from a query like:

Expr1:my_function("fdf",,"fdf",,,,"fd")

I always obtain an error!

I'll try using:

Eval("my_function('fdf',,'df',,,,'fd')")

to see what happens!

Any other suggestions?

TIA

Vladi

[NeoPa]

What's the VBA of your function Vladi?
And can you post some SQL examples of trying to use it.

[ADezii]

When i'm trying to pass missing values to a function called from a query like:

Expr1:my_function("fdf",,"fdf",,,,"fd")

I always obtain an error!

I'll try using:

Eval("my_function('fdf',,'df',,,,'fd')")

to see what happens!

Any other suggestions?

TIA

Vladi

'Make sure that the number of Arguments passed to the Function matches the
'number of declared Parameters contained within the Function, both number
'and type. e.g. Passing 3 Arguments when 4 are declared within the Function,
'passing a Numeric value to a Date type. Make sure that the Function is
'declared Publically e.g. Public Function fMyFunction (Param1 As String,
'Param2 As Date, Param 3 As Boolean) As String

[MMcCarthy]

When i'm trying to pass missing values to a function called from a query like:

Expr1:my_function("fdf",,"fdf",,,,"fd")

I always obtain an error!

I'll try using:

Eval("my_function('fdf',,'df',,,,'fd')")

to see what happens!

Any other suggestions?

TIA

Vladi

Vladi

Unless the missing parameters are set as optional in the function it won't work.

Mary

[PEB]

Vladi

Unless the missing parameters are set as optional in the function it won't work.

Mary

Sure

I've tried a lot but no chance! Finnally i've done the function to accept both:

Null

and missing values and the problem is resolved!

Eval didn't work in this case!

If it worked can do a great job coz i'm using this function to send mails, and when the body is html u can guess what happens with " and ' :)

Simply in the function i've introduced the null to be acceptable value and it is Ok now!

Thanks for your suggestions!

[PEB]

'Make sure that the number of Arguments passed to the Function matches the
'number of declared Parameters contained within the Function, both number
'and type. e.g. Passing 3 Arguments when 4 are declared within the Function,
'passing a Numeric value to a Date type. Make sure that the Function is
'declared Publically e.g. Public Function fMyFunction (Param1 As String,
'Param2 As Date, Param 3 As Boolean) As String

The arguments are on the correct place but are optional! This is all of the problem obviously!

It's pitty that in the query you should use null for optional arguments, but sometimes it gives errors in some functions!

For my functions with optional parameters i'll include the nulls also like a source of missing parameter!

:)

I'll come back soon in the forum people!

[MMcCarthy]

:)

I'll come back soon in the forum people!

We miss you Vladi

Mary

[NeoPa]

The arguments are on the correct place but are optional! This is all of the problem obviously!

It's pitty that in the query you should use null for optional arguments, but sometimes it gives errors in some functions!

For my functions with optional parameters i'll include the nulls also like a source of missing parameter!

:)

I'll come back soon in the forum people!

Vladi,

Optional arguments does NOT mean using a Null!
If you pass a field to a function that is passing an argument - it is simply a Null argument.
In the code, the functions IsNull() & IsMissing() are two different things.
If you pass a Null to an optional string parameter, for instance, that will give an error.

HTH -Ade.