Verifying that a number conforms to field mask

J

Jacob

In a table, Sys_Variables, a system defines a field mask for a certain
field, in this case, an inventory tag. The field mask is in the format of
99999, which signifies that there are 5 characters allowed in the value. I
know how to select the record from the recordset, however, I'm not sure the
best way to check that the value entered has the correct number of
characters. Any help would be appreciated.

Jacob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,578
Members
45,052
Latest member
LucyCarper

Latest Threads

Top