While working in designer & testing as I go, I have come across some quirks/bugs or I may be I'm just missing something, but here goes,

1. In Propertry Editor / Format . Applying format to a text element there is no option of "Initialize Caps"

2.  Property Editor / Text . There is no option to Justify Text to Center of text box element.

3. In an Data Field Element bound to number field. When adding records Sesame drops leading zeros entered in field.
eg: 04100 will end up 4100 after leaving data field. We need that 04 for the 2 digit year in a invoice # field.

4. Property Editor / Other . Apply "Initial Value" to text field element.
In the data base, add records, the "Initial Value" is in the data field on entering a new record, complete record, F10 to save, exit to "Search/Update" and retrieve record. The data field is empty of the initial value that was applied, it is not saving initial values to the record.

5. In Designer. When I click on File / Open Application. The pop up box shows all db and dsr files, shouldn't it show only the dsr files, thats what I thought I read in one of the manuals.

Thanks for the reply, you have clarified a number of things. Pitty these small format items were not brought over from Q&A, although minor they make entry simplified and gives class to a printed form, well maybe in the upgrade huh!

Quote:


When you place a combo box on your form, then in the selection list you have 3 letter words to a 5 word sentence, it will look more professional on your printed form if the text is centered instead of a 3 letter word justified left in a box space that is large enough to show a 5 word sentence.

Quote:

If I change my "Invoice #" field to a text field can I use the @number programing  statement, I was under the belief this needed to be a number field. 

Quote:


I have an invoice form with static text "Sold to" on the left side. Under that going down the page I have the following Text Boxes "Name, Address, City, State" to the right of state on the same line I have "Zip" and to the right of that "+4".
The "State" box is a text element has the following under the Property Viewer
Label: State
Name: State0
Bound To: !State0
Bound To Type: Text
Initial Value: Ks
Read Only: False
Visible: True

It is this Initial Value of Ks to the State field I'm having trouble with. It comes up on add record but does not save with record.

#5. makes sense now. Bear with me here, I screamed so hard at work to wait for Sesame, I'm now under the gun to produce and be up and running for the 1st of Jan.
So am a little tense with some frustration while going through the learning curve, but try and explain that to the boss 

Quote:


Becky

The following code snippet takes a text field, capitilizes the first letter, and makes the rest lowercase.
just modify it a bit for the fields you need to use it with and you will achieve the same results as Initialize Caps.

Var vName as String
Var vFirst as Char

vName = Name //Name is a Text Field
if @len(vname) > 0 then
{
vFirst = @left(vname,1)
vname = ToLower(vname)
vname = @ReplFir(vname, vFirst, ToUpper(vFirst))
Name = vName
}

Quote:


- Yes you are!  To apply just the Design changes, you should have Reconciled. Save as New Application does just that.

Quote:


- This is the way Sesame works. You can go to the last record in any result set and advance to a new blank record and add records that way.  Blank records though are not saved. If they are we need more information on just what you are doing.

You'll be delighted to know, Becky, that we don't charge extra for Stereo replies ! 

Erika and I will really have to get ourselves in sync.

(But isn't it reassuring that we give the same answers!)

Quote:



Becky, I wanted to comment - and maybe clarify something Alec said.  Please read his statement above.   Note that he says "...go the the last record in ANY RESULT SET and advance to a new blank record..."  The capitalization is my emphasis.  If you test this on any of the Sample databases, (try Callback) you will see this same action.  You can actually ADD records to an application while in EITHER the ADD mode or SEARCH/UPDATE!  Something that Q&A didn't allow can be done in Sesame.  When you press F10 to the end of the records and press F10 again, Sesame provides a blank record for use (if you wish).  When you press F9 to go back to a previously saved record, Sesame realizes that you have entered no data into a blank record, so does not save that blank record, hence the record count drops back to what it was when you were on the last record that was populated with actual data.

I hope this helps to clarify your issue about a "blank" record being saved in your database.

T.J.

Here is a piece of code that capitilizes the first letter of every word in a field as opposed to my other piece of code that Bob Scott posted earlier which only capitilizes the first letter of the first word.

It was written for the On Exit Event of the field Company in the database Customers.db, but can easily be modified to any text field by just changing the field name in two places.

var vName as String
var vFirst as Char
var vCnt as int
var vSnipet as String

vCnt = 0
vName = Company //Company is a Text Field  
if @Len(vName) > 0 then
{
     vFirst = @Left(vName,1)
     vName = ToLower(vName)
     vName = @ReplFir(vName, vFirst, ToUpper(vFirst))
     While vCnt < @Len(vName)
     {
           if @Mid(vName,vCnt,1) = " " then
           {
                 vSnipet = vSnipet + @Left(vName, vCnt)
                 VName = @Del(vName, 0, vCnt)
                 vCnt = 0
                 vFirst = @Left(vName,1)
                 vName = @ReplFir(vName, vFirst, ToUpper(vFirst))
           }
           vCnt = vCnt + 1
     }
     vSnipet = vSnipet + vName
     Company = vSnipet
}

Hope this helps.