(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Learning the ropes
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2] 3  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) Learning the ropes (Read 8176 times)
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #15 - Jan 7th, 2004 at 2:56pm
Print Post Print Post  
Still learning the ropes.  Got to where I want to format a field as money and another as a date field.  Does the trial version allow for this function?  I'm in the design/redesign mode, format tab, clicked on the field I want to format and highlighted money format but it says "not set".  What am I missing here?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #16 - Jan 7th, 2004 at 3:04pm
Print Post Print Post  
Quote:
Still learning the ropes.  Got to where I want to format a field as money and another as a date field.  Does the trial version allow for this function?  I'm in the design/redesign mode, format tab, clicked on the field I want to format and highlighted money format but it says "not set".  What am I missing here?


You are looking at the Property Viewer. This displays current settings. The control panel above it is the Property Editor, where you can actually change settings. The instructions for doing this begin on page 86 of the User Guide.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #17 - Jan 7th, 2004 at 4:01pm
Print Post Print Post  
I've followed the instructions from page 86 thru 90. I get a message when I click on close design tab  that says the current design has been changed but not commited to the database. I know I'm missing a step some where. Sorry for being such a dunce.

I went back and made sure I double clicked save layout design.  Then I went to the db in trial version and tested the elements to see if the format had been applied.  It had not.  The money field is just numbers and so is the date field.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #18 - Jan 7th, 2004 at 4:12pm
Print Post Print Post  
Whenever you make changes, you need to save them. The Save Layout Design command is in the Commands panel near the top of the Control Panels area. Click once in the Commands panel to set the focus, then click Save Layout Design.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #19 - Jan 7th, 2004 at 4:42pm
Print Post Print Post  
Quote:
I want to format a field as money and another as a date field.


Kathie,

Another easy way to change a field type if you already created it  is in Sdesigner under manage a database manage fields.

Open your dsr in Sdesigner
Click Manage A database
Under the database your working on
Click Manage fields
In the box that opens click on the Action field
Click on change field type
Under field name select field
Click add to batch
When you have selected all fields you want to change
Click
Run batch.

Like Magic its done. Its that easy

Hope this might be of some help.  Smiley
  
Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #20 - Jan 7th, 2004 at 5:05pm
Print Post Print Post  

Okay, I'm really getting frustrated here.  I did as you suggested with the "manage a database" etc.  and the format is not working.  My dsr file has two elements which need to be formatted for my reports to work.  One is Sale Price as a money field the other Sale date (in January 7, 2004 format)  I clicked on add transaction to batch after assigning the formats and then run batch.  I then went back to the db in trial version and tried adding data to the db.  The money field is still text numbers and the date is too.  What the heck am I doing worng??
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #21 - Jan 7th, 2004 at 5:21pm
Print Post Print Post  

I'm getting a little confused too.

Which of the following are you trying to do?
1. Change a Text field to be a Money field.
2. Change the way an element bound to a Money field displays the field value?
3. Both.

Are your changes working in Preview mode?

After making your changes, did you Reconcile to apply the changes to the db?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #22 - Jan 7th, 2004 at 5:42pm
Print Post Print Post  
In Q&A to set a field as a date or money field I used design menu, customize menu, format value and then typed MC for the money field and D for the date and then set the way the date should appear in the db.  In Sesame I'm trying to set the money field so it appears as $123,456 and the date as January 7, 2004 format.   So to answer your question I guess I'm trying to do both.  Preview mode??  Not sure what that is.  I'm a realtor with a prospect database of 4700 records.  I do reports of current sales from my Q&A db.  I'm hoping to convert the db to Sesame mostly because of the printing restrictions of Q&A.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #23 - Jan 7th, 2004 at 5:45pm
Print Post Print Post  
Open your dsr in Designer.
From the Design Menu tree, choose Application / Preview Application

This opens your design in Preview mode.  It will behave exactly like Sesame with a few minor exceptions.

Is your data correctly formatted in Preview mode?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #24 - Jan 7th, 2004 at 5:59pm
Print Post Print Post  
In preview mode/add data the money and the date are correctly formatted.  Now I'm REALLY confused. <G>

Oops the date entered as 1/7/04 returns January 7, 1704
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #25 - Jan 7th, 2004 at 6:45pm
Print Post Print Post  
Quote:
In preview mode/add data the money and the date are correctly formatted.  Now I'm REALLY confused. <G>

Oops the date entered as 1/7/04 returns January 7, 1704


Okay, then you need to Reconcile the changes to the db. The db doesn't know that you changed things in the dsr until you Reconcile. See page 131 of the User Guide.

BTW, 1/7/04 does not return Jan 7, 1704 but 1704 does. I think you may have been caught by the bug that makes the / on the numeric keypad not work.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #26 - Jan 7th, 2004 at 7:00pm
Print Post Print Post  
Thank you for all your help.  BTW is that an internet bug or Sesame bug??
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #27 - Jan 7th, 2004 at 7:36pm
Print Post Print Post  
Sesame bug!   Smiley
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Learning the ropes
Reply #28 - Jan 8th, 2004 at 12:39am
Print Post Print Post  
Quote:
If you expand and contract folders, it will sometimes  strip off the drive letter, leading to this message.  The second time, you make the exact same choices,

Thanks Erika, I will watch closely to see is that is happening.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #29 - Jan 8th, 2004 at 9:46pm
Print Post Print Post  
In creating reports I've read all the info and followed it correctly I think.  Created a report and saved it etc.  What I didn't notice at the beginning was a pop up that asked if I wanted to replace the current file name.dsr?  with a yes or no button choice.  I hit yes and now have discoverd that it wiped out my form, db, the works. I've recreated my form and db and again went to Application  utilities/redesign current application and am sitll getting that same pop up.  Where did I goof?
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1 [2] 3 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge