A5_is_email_valid

[Bob Whitaker]

I have a logical field in a table (DBF) which is calculated using A5_IS_EMAIL_VALID(EMAIL-ADDRESS) this works perfectly on windows 10 but throws an error to the trace window when run on Windows 11 - any ideas please.
Bob

[Lenny Forziati]

The function is pretty simple and is not doing anything OS-specific or using any Windows APIs. What is the exact error?

[Bob Whitaker]

Hi Lenny - long time no speak.

Thats exactly what I thought but the facts are the field is a logical field and its content is calculated using the formula A5_IS_EMAIL_VALID(Email_Address)
All works fine on my Windows 10 machine but when i access the relevant table on windows 11 I get an error message telling me to look at the trace window and the entry in the error tab is

Warning [1]: Error(s) opening rules for field: EMAILVALID
Warning [2]: Error adding calculated rule to database engine.

If I remove the field rule all is ok

I have tried compacting the database.

Many thanks for your attention
Bob

[Ted Giles]

Hi Bob.
Have you tried recreating the field rule from scratch?

[Bob Whitaker]

Hi Ted - yes I have tried that including powering off and on again between removing it and recreating it.
Strangely if i try the function in the Interactive window it works as it should.
I have also tried applying it as a field rule on a different logical field in the table and then went on to try and use it in a different table.
I wondered if having the field named email_address was perhaps the problem so created a completely new table with different field names but the issue persists.
Just stumbled upon an anomaly that might point to a corrupt AA installation - when I click the About Alpha Anywhere button to check the version number nothing happens so I guess the next step is to try re-installing AA
Will keep you posted.
Bob

[Ted Giles]

I imagined you would have done that as you have few gey Alpha Hairs.
Have you tried running Alpha as ADMIN?
Shouldn't have to, but just a suggestion.

[Bob Whitaker]

Too right about the grey hairs. Tried admin no good. Now trying reinstall and cant get beyond this

[Bob Whitaker]

Need less to say disk is nowhere near full and I have full rights
Anybody want to buy a flying laptop - does not fly well I should add

[Bob Whitaker]

UPDATE !! I finally got to update the version of AA on my laptop using the Update installer rather than an old .exe I had lying around which seemed to upset Norton as most things do. Anyway the function now works again and I'm a happy if slightly baffled bunny. Thanks Ted and Lenny for your input.

[Ted Giles]

Glad you got it working Bob.
I just got back from shopping and tried it out and it worked fine.
You haven't got the install in the Prog Files folder have you? (I doubt it given your knowledge, but I sometimes forget my name when the Old Bill stop me!)

[Bob Whitaker]

Thanks Ted, as you surmised whilst I have forgotten all I have learned that mistake isn’t one of them. Curious to know how many times you get stopped by the Old Bill and more interestingly why ????

[Ted Giles]

It used to be for Impersonating a Salesman.
now it's Impersonating a Village Idiot.
+I was Mayor and did autographs (true)