(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Using Sesame for a document database
(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) Using Sesame for a document database (Read 8384 times)
StreifLicht
Member
*
Offline



Posts: 17
Joined: Mar 15th, 2013
Re: Using Sesame for a document database
Reply #30 - Apr 1st, 2013 at 8:27pm
Print Post Print Post  
Bharak,
thank you for posting. This is what i would like to have.

Currently i encounter some small problems. Should i post it in this thread or should i open a new one? But maybe it's better to have it in one thread.

I test some basic commands, just to see how it works..

Bound to.... This is the field name right?
Can change the field name? Or should i delete the field and add a new one?

What happened?
I added an element (Text Box, Bind Element to "New Date Field")
Afterwards i saw that the label was wrong typed (Entr Date Box instead of Entry Date Box).
I changed the Label to "Entry Date Box"
But in the Property Editor Drop Down i see
only "Entr Date Box".
How can i change this to the correct name?

I mean to have the field names equal to the labels...
  
Bound_to.png ( 12 KB | 68 Downloads )
Bound_to.png
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #31 - Apr 1st, 2013 at 8:39pm
Print Post Print Post  
Manage Database ----> DatabaseName ----> Managefields --->Change Field Name --->fill the new Name --->  Add transaction to Batch ---> Run Batch

The above should change the field's name and it will be reflected in the property Viewer.
  
Back to top
 
IP Logged
 
StreifLicht
Member
*
Offline



Posts: 17
Joined: Mar 15th, 2013
Re: Using Sesame for a document database
Reply #32 - Apr 1st, 2013 at 9:00pm
Print Post Print Post  
That worked fine.
The property editor now shows the desired field names.

Only the Program editor shows not the updated fields.
(Still Entr Date Box instead of Entry_Date_Box)
  
Bound_to1.png ( 7 KB | 67 Downloads )
Bound_to1.png
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #33 - Apr 1st, 2013 at 9:41pm
Print Post Print Post  
There are 3 things, namely

Label
Element Name
Field Name

It is Element name is displayed in Program Editor

You can change the Element Name in Property Editor

Select Element by clicking it ---> Property Editor -> Other tab ---> Name --> <F5> will bring on current Name ----> Type over the new Name -->Press the arrow on the right side end to take the effect ----> view the change of Name in property viewer ----> the name change will be also reflected in the Program Editor.
  
Back to top
 
IP Logged
 
StreifLicht
Member
*
Offline



Posts: 17
Joined: Mar 15th, 2013
Re: Using Sesame for a document database
Reply #34 - Apr 1st, 2013 at 10:26pm
Print Post Print Post  
Smiley  Ok, thanks. Understand...
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #35 - Apr 1st, 2013 at 11:35pm
Print Post Print Post  
Just to clarify the basic:

Element Label and Name deals with Layout or Forms while fields is to database. One application can have multiple databases and one database can have multiple forms.

As far as I know all commands in layout deals with Element Names except @XResultset ( ) commands, that works directly on database and hence uses field name.
  
Back to top
 
IP Logged
 
StreifLicht
Member
*
Offline



Posts: 17
Joined: Mar 15th, 2013
Re: Using Sesame for a document database
Reply #36 - Apr 3rd, 2013 at 8:38pm
Print Post Print Post  
While testing a small program i get this error code which i do not know the reason.
  
PopupSelectPosition.png ( 5 KB | 72 Downloads )
PopupSelectPosition.png
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #37 - Apr 3rd, 2013 at 8:56pm
Print Post Print Post  
0 - Default position (100 pixels left of the right top edge of the main window).
1 - Absolute screen position of xpos and ypos.
2 - xpos and ypos relative to the top left corner of the main window.
3 - xpos and ypos relative to the top left corner of the form's window.
4 - xpos and ypos relative to the form's top left corner.

I usually use:

PopupSelectPosition(4, @Xpos(LEName), @Ypos(LEName))

This is relative to the button or the element where the code is placed. (You do not have to name the LEName)  Use the code as it is. LEName defaults to the LE the code is in.

This way the popup will be right by the subject element.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Using Sesame for a document database
Reply #38 - Apr 3rd, 2013 at 9:14pm
Print Post Print Post  
Bharat, I think StreifLicht is getting a syntax error, not a problem running the subroutine (that may come later).

StreifLicht, could you post a the snippet of code around that subroutine call. I don't see anything wrong with the subroutine name itself. If you are getting an error from earlier code, it can cause a cascade. Is this the first error, or is is several errors deep?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
StreifLicht
Member
*
Offline



Posts: 17
Joined: Mar 15th, 2013
Re: Using Sesame for a document database
Reply #39 - Apr 3rd, 2013 at 9:27pm
Print Post Print Post  
LEName is Layout Element Name right?
This works  Smiley Thank you again Bharat.
Currently i play around with some snippets
to learn the basics. Im not a programmer
so it will take some time...  Wink
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #40 - Apr 3rd, 2013 at 9:34pm
Print Post Print Post  
Quote:
LEName is Layout Element Name right?


You donot even have to write Layout Element Name. LEName means current layout element. It is like ThisElement. If you just put the line as it is, it will work fine. If you replace LEName with the Current Element Name - that should work too.
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #41 - Apr 4th, 2013 at 2:21pm
Print Post Print Post  
Quote:
Currently i play around with some snippets
to learn the basics. Im not a programmer
so it will take some time... 


Other than Lanticans, most of us here are amateurs. Thanks to Sesame for providing us with the platform and all the tools, so that we can design and program applications just like programmers do and give us ability to see how the logic is put to use through programming. Without unparalleled support by Lanticans, none of these would work! Thanks for all the support.  So, keep going with your own speed. We all have passed through that and we understand.
  
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Using Sesame for a document database
Reply #42 - Apr 7th, 2013 at 9:18pm
Print Post Print Post  
Bharat_Naik wrote on Apr 3rd, 2013 at 9:34pm:
LEName means current layout element. It is like ThisElement.


Huh! ???

Are you sure you don't have "LEName" set up as a variable? That does NOT work for me.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Using Sesame for a document database
Reply #43 - Apr 7th, 2013 at 10:43pm
Print Post Print Post  
Carl, you are right! LEName should be replaced by ThisElement, that will take the current element as reference point.
  
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