I have 3 questions.  I have translated a Q&A 4.0 into Sesame.  (1360 records; with appx 100 fields/record)

1.  In "Manage Fields" I attempted to change my phone field and cell phone field from text to number.  I received a Microsoft Visual C++ Runtime Library error "Assertion Failed"

2.  We had 1 form in Q&A with the all the fields on 8 or 9 pages.  So I'm making it different forms for different tasks.  The first form is our "Application".  I have the main form but I wanted to put a 3 tabbed subform on here their medical info/vehicle info/talents.  However the user guide said you have to have two subforms?

3.  In creating the new forms, I want to create "masks" like "(    )      -           "  for phone numbers.

Thanks in advance.

Judy

Yes I want to organize the form with existing elements with tabs?  How do I do that?

Quote:


Judy,

If you use this code snippet with on element Change execution it will format the phone number nicely. My field name was HomePhone so if you just replace that field name with yours it will work.

// Formats Telephone Number

var vHPhone as String
var vNewHPhone As String

vHPhone = @Num(HomePhone)
vNewHPhone = "(" + @Left(vHPhone, 3) + ") " + @Mid(vHPhone, 4, 3) + "-" + @Right(vHPhone, 4)
HomePhone = vNewHPhone 


I hope this helps.

If you want to get really slick, though probably a little annoying to your end users, you could use the "on immediate change" event and actively filter what they type.

Carl,

All good points. Well taken. 

The snippet was intended to be just a starting point for us beginners to get the basics down and use to school off each other. I am under the belief that a snippet is just that, a small snippet of code used to help someone move in the correct direction. The code was designed to handle a masking like task.

In my little fishbowl of a world the logic to just do the basic masking at this moment seems like an incredible step. I hope to improve my skills daily, but I am also sure that I will never run out of things to learn before I die. 

I guess the next step will be to add data integrity logic to check all the points you brought up.

Thanks for the insights and helping in setting the goal for my next task. 

I found that @msgbox works real nice instead of writeln.
I have 2 oddities when this code executes that I do not understand.

First. After the @msgbox is presented you have to hit enter or mouse click ok two or three times before it goes away and returns me to the Homephone element.

Second using the @color(HomePhone,7,4) I thought I would have HomePhone element Red background with  white text but the background does not turn red. Is this a monitor issue, an issue because the Home Phone is on a Tab or something I am doing incorrectly?

Thanks


// Formats Telephone Number

var vHPhone as String    
var vNewHPhone As String 
var vhphonecount
var vhpnentered

     Vhpnentered = @num(HomePhone)
           
     vhphonecount = @num(@len(vhpnentered))
     
If vhphonecount = "10"

{
     @color(HomePhone,0,7)
     vHPhone = @Num(HomePhone)
     vNewHPhone = "(" + @Left(vHPhone, 3) + ") " + @Mid(vHPhone, 4, 3) + "-" + @Right(vHPhone, 4)
     HomePhone = vNewHPhone 
}
else
{
     @color(HomePhone,7,4)
     @msgbox("The Telephone Number needs to be Exactly 10 Digits", "The numbers you entered " +
     @num(Homephone),"is : " + Vhphonecount + " Digits Please check Home Telephone and Re-enter")
     Goto HomePhone 
}   

   

Quote:


Sure could.

I am going to copy my dsr then remove everything but that one bit of code and see how it behaves. If all is fine I will then put each piece of code  back one at a time and see when my problem comes back.

I will keep you posted.

Thanks

Quote:


No, I wasn't. Please could one of you file a bug report on the subject.

http://www.lantica.com/Support/support_request_form.html