Page Index Toggle Pages: [1] 2  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) F000 Oh brother! (Read 4131 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
F000 Oh brother!
Mar 29th, 2006 at 9:05pm
Print Post Print Post  
Familiar situation?  Post-Q&A translation = LOTS of F000* elements.  It'd be a PITA to name all these buggers in Q&A's Set Field Names because most of them are going bye-bye when I re-program other elements in Sesame.  But until that re-programming happens (and, in fact, to allow that re-programmiong to happen) I need to muck with them.

So, advice?  Best/easiest/fastest way to identify and jump to, say, F0058 on a form with dozens of F000's? 

  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: F000 Oh brother!
Reply #1 - Mar 29th, 2006 at 9:30pm
Print Post Print Post  
Hello Scott,

An easy way to identify that element on your form is to run a Mass Update that changes the background color of that element to bright green, or some other color that sticks out on your form.

You could also write a Mass Update that goes through every element and changes it's label to be it's element name. Run it and then print out the form. This way you have a hard copy of the form that shows you where every element is and what it's name is.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #2 - Mar 29th, 2006 at 9:33pm
Print Post Print Post  
Ray,

That second idea sounds great.  But I'm not too familiar with Sesame's Mass Update procedure, and have no idea what command I would use to have element labels change to their names.  A bit more hand-holding, please?
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: F000 Oh brother!
Reply #3 - Mar 29th, 2006 at 9:58pm
Print Post Print Post  
Hello Scott,

Open Sesame
Open your DB file
Open Search/Update
Type "Max 1" without the quotes in an element
Hit F10
Enter the code below in the Mass Update program editor
Run the Mass Update
Hit F10 again to enter extend mode
Expand Record commands
Expand Printing commands
Choose Print Form

This will print out your form with the labels of every element set to the name of that element. The reason to enter extend mode is so that the form that is printed has no record data on it, as all you need is the names.

Code
Select All
Var vElements as String
Var vCnt as Int
Var vLoop as Int
Var vName as String

vElements = @StringArrayElementlist()
vLoop = 1
vCnt = @CountStringArray(vElements)

while vLoop <= vCnt
{
	vName = @AccessStringArray(vElements, vLoop)
	SetThisElement(vName)
	Label(ThisElement, vName)
	vLoop = vLoop + 1
}
UnSetThisElement() 



Mass Updating is covered in the Sesame 1.1 User Guide on pages 263-283.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #4 - Mar 30th, 2006 at 2:56pm
Print Post Print Post  
Woo hoo!  Thanks Ray!  Take a raise out of Petty Cash and tell them Captain Infinity said it was OK!

New things you have taught me (or started me towards learning):
* Max 1
* Extend Mode (I'm going to have to read up on this as I have no idea what it is, but it looks very useful)
* Printing commands hiding under Record commands.

I'll have to play around with the printout setting a bit, because this "form" was actually 10 pages of Q&A, so when it prints formatted for a single page it all becomes a blur of gray down the middle of the paper.  But just seeing the element names on the screen is very helpful.

Thanks again!

(By the way, before I read your detailed answer I was playing around with
Code
Select All
Label(ThisElement,@Label(ThisElement)) 

in the Global Code section of the Mass Updater.  It didn't do a darned thing but the program editor was happy with it.  Heh!
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: F000 Oh brother!
Reply #5 - Mar 30th, 2006 at 3:22pm
Print Post Print Post  
Hello Scott,

To get a multi-page printout in the current version, you will see an option under Printing Commands that says Print Form to HTML. Choose that option. Give it a file name. Your default browser will open and display that file. You can then print the form out from your web browser and it will be on as many pages as it takes.

The
Code
Select All
Label(ThisElement,@Label(ThisElement)) 


Did exactly what you told it to do. It set the Label of the current element to be the Label of the current element.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #6 - Mar 30th, 2006 at 3:37pm
Print Post Print Post  
Quote:
Print Form to HTML.


There we go!  Thanks again.

Quote:
The Code:
Label(ThisElement,@Label(ThisElement))

Did exactly what you told it to do. It set the Label of the current element to be the Label of the current element.


Well super, I succeeded at something completely pointless.  Just one more thing to add to the list.  YAY!
  

**
Captain Infinity
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #7 - Mar 30th, 2006 at 3:49pm
Print Post Print Post  
Firefox does not like the resulting HTML.  The browser printout is chopping off at one page.  When I do a Print Preview I can see fields and labels hanging in limbo under the single page.

Internet Explorer prints 4 pages with no problem.

This could be a concern in the future as Firefox is our company-wide default browser.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: F000 Oh brother!
Reply #8 - Mar 30th, 2006 at 4:03pm
Print Post Print Post  
Hello Scott,

In the future there is this little thing called Version 2.0 which allows you to print your form onto multiple pages in either direction, right from Sesame. So you could print your form on say 6 pages, two across and three down.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #9 - Mar 30th, 2006 at 4:15pm
Print Post Print Post  
So my boss is passing through the office as I read this and I says to him, I says, "These guys!  They keep teasing me with all the great stuff that's gonna be in Version 2 that I could really use right now.  Sheesh!"

And he, never one to deny me tools I need, says, "Why can't we get it?"

And I have to tell him that it's NOT OUT YET, it's still in Beta, they keep packing stuff into it and it'll never be ready!  Aarrggh!

Anyway, it sounds like it's going to be one hell of an upgrade.  You folks do great work.  But I'm going to have to stop thinking about 2.0 and concentrate on the tools I have now.  The HTML thing is not too much of a worry as I won't need it until further down the road, and I've already found an alternate solution.  Thanks for the help with the field names.

Now...is there an easy way to find all the elements that have "restrictions" brought over from Q&A?  I want to eliminate most, if not all of these.
  

**
Captain Infinity
Back to top
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: F000 Oh brother!
Reply #10 - Mar 30th, 2006 at 6:12pm
Print Post Print Post  
Hi Scott...

I use Firefox extensively with all of my accounts. 

Would be curious to see what is happening.  Any chance you can share the html file that is not printing properly? 

I would like to check that out here to see the results you mention.
  



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


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: F000 Oh brother!
Reply #11 - Mar 30th, 2006 at 6:16pm
Print Post Print Post  
I too use Firefox as well as Netscape and they both work just fine.
  
Back to top
 
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #12 - Mar 30th, 2006 at 6:27pm
Print Post Print Post  
See:
http://captaininfinity.us/workform.htm

I've fiddled with my page settings in numerous ways, and all I can get is a single page to print.  When I look at the form in preview, the fields and labels continue past the bottom of the imaged page, hanging in mid-air, for just a line or two.  Then the preview stops.

Let me know what you see, thanks.
  

**
Captain Infinity
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: F000 Oh brother!
Reply #13 - Mar 30th, 2006 at 6:51pm
Print Post Print Post  
Quote:
So my boss is passing through the office as I read this and I says to him, I says, "These guys!  They keep teasing me with all the great stuff that's gonna be in Version 2 that I could really use right now.  Sheesh!"

And he, never one to deny me tools I need, says, "Why can't we get it?"

And I have to tell him that it's NOT OUT YET, it's still in Beta, they keep packing stuff into it and it'll never be ready!  Aarrggh!


My intention was not to tease you by telling you about the Form printing in 2.0. My intention was to let you know that in the future there will be an easier and simpler way to get a multi-page printout of your form. Version 2.0 is still in the Development stage at this point in time and has not entered the Beta cycle. It will be finished and it will be released.

Quote:
Now...is there an easy way to find all the elements that have "restrictions" brought over from Q&A?  I want to eliminate most, if not all of these.


A way to get a list on the screen of all of the elements that have restrictions is to...
Open Sesame
Open Add Data Mode
Look in the Spec Window in the Lower Left hand corner
It should say "Check Restrictions for YourFormName"
Down below that will be a list of all the elements that have restrictions

In Sdesigner 2.0 you can select all elements that have restrictions. I also believe that in the 2.0 Q&A translator you will have the option to tell Sesame to not translate over the Restrictions.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: F000 Oh brother!
Reply #14 - Mar 30th, 2006 at 7:02pm
Print Post Print Post  
Quote:
My intention was not to tease you by telling you about the Form printing in 2.0.....It will be finished and it will be released.

I know, I was just teasing youWink

Quote:
A way to get a list on the screen of all of the elements that have restrictions is to...<snip>

Thanks Ray, that works well.

Quote:
In Sdesigner 2.0 you can...

Sigh.
  

**
Captain Infinity
Back to top
IP Logged
 
Page Index Toggle Pages: [1] 2 
Send Topic Send Topic Print Print