Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

@iserror and @dbcolumn, how to use both?

Status
Not open for further replies.

cavery

Technical User
Oct 29, 2002
129
0
0
US
Greetings,
How can I use @iserror with @dbcolumn?

Thanks for your help!


~Clark
 
Assign the result of @dbcolumn to a temp variable, and then use @iserror on the variable.

Like this :
Code:
tmpLookup:=@dbcolumn("":"";"":"";"keywords";1);
@if(@iserror(tmpLookup);"Table Empty";tmpLookup)

The example supposes that you are writing the code in a Computed field formula.

Hope this helps,

Pascal.
 
Thank you, I'll see how that works!

Clark

~Clark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top