Solved

Mask for TQRDBText

Posted on 2004-10-05
9
1,111 Views
Last Modified: 2012-05-05
Hi, can someone help me on this

I use Paradox tables ----> field value: 0123456789

When I use QR --> TQRDBText --> output should be: 0123.456.789

I tried to use the mask property, but still on the printout (or preview) I get 0123456789

What am I doing wrong ?

thx
marioway
0
Comment
Question by:marioway
9 Comments
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 12226677
make this field Calculated and use Format function to do it like this in OnCalcFields event ...
0
 
LVL 11

Expert Comment

by:calinutz
ID: 12226682
You probabely use a wrong mask. What type of mask did you place in the mask property? And what exactly does your number  0123.456.789 represent? Is it a phone number or what?
0
 

Author Comment

by:marioway
ID: 12227652
Hi, the number is a Belgian VAT number (in the database I put it in a field: alfanum  length 11 )
I Used the mask: '____.___.___' without the quotes.

marioway
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 12229146
It does not work with Decimal separator, but
I did a successful examples using Mask property of the TQRDBText:

0###_0##_0##
0###`0##`0##
0###~0##~0##

I probably will work with many different separators
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 12

Expert Comment

by:esoftbg
ID: 12229294
Possible separator:
·
Alt + 0183
0
 

Author Comment

by:marioway
ID: 12235853
Hello, It still does not work.

marioway
0
 
LVL 12

Accepted Solution

by:
esoftbg earned 50 total points
ID: 12236854
download a workink example from:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21156392.zip
0
 

Author Comment

by:marioway
ID: 12237262
Hi, thank you very much esoftbg. It works fine this way.

Marioway
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 12237857
marioway, you are welcome !
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now