Databases
StackOverflow2013
Usersdbo
USKarl-Henry Martinsson
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USKarl-Henry Martinsson
    primarykey
    data
    text
    <p>I am a developer based in Dallas, TX, but originally from Stockholm, Sweden.</p> <p>I have been working with Lotus (now IBM) <strong>Notes/Domino</strong> since 1996, full-time since the end of 1997. I have been honored by IBM by being selected as one the <strong>IBM Champions for Collaboration Solutions</strong> since 2014. I have presented at the MWLUG conference in 2015, 2016 and 2017 as well as IBM Connect 2016 and 2017.</p> <p>Since 2016 I have also been working with <strong>NetSuite</strong> and their ERP system. NetSuite uses <strong>SuiteScript</strong> (Javascript with API calls to access database functionality) for development both on the frontend and backend side.</p> <p>I have been working with HTML and web technologies since early 1994. I have mostly been working with <strong>jQuery and Bootstrap</strong> for the last 5-6 years, but I have been using other Javascript frameworks as well. </p> <p>My main work is currently done using <strong>Javascript</strong> (and <strong>SuiteScript</strong> in NetSuite) as well as <strong>Lotusscript</strong> (a dialect of VB used in IBM Notes/Domino). A couple of years ago I also did some work using C# and .NET, but I don't use it on a regular basis.</p> <p>My past work experience includes working at <strong>Microsoft AB</strong> in Sweden, and developing IVR (Interactive Voice Response) applications for Esselte Voice (later VoiceEQ) in Sweden. In addition I also worked as a journalist for five years covering the IT industry for <strong>International Data Group</strong> (IDG) back in 1993-1998.</p> <p>More recently I worked at <strong>Deep South Insurance</strong> as a <strong>Sr Application Developer</strong>, focusing mainly on Notes and Domino. I wrote the in-house claim system, as well as several other business critical applications.</p> <p>My company <strong>Demand Better Solutions</strong> is focused on creating modern looking, easy-to-use applications that will empower the users and make them more efficient. We <strong>modernize Notes and Domino applications</strong>, move them to web applications or migrate data to other platforms. </p> <p>I started programming in 1982/83, using <strong>BASIC</strong> on Z80-based computers. After about 2 years, I switched to <strong>Pascal</strong>, as my school got new Intel 80186-based computers running <strong>CP/M-86</strong>. In 1988 I started using <strong>C</strong>, first in DOS and then (about a year or two later) in Windows. When <strong>Visual Basic 1.0</strong> came out, I embraced it and added that to my toolbox. I also have past experience using <strong>Paradox</strong> (a database later acquired by Borland), <strong>Delphi</strong> and some <strong>Java</strong>.</p> <p>I have been blogging since 2008, you can find my blog at <a href="http://blog.texasswede.com" rel="nofollow noreferrer">http://blog.texasswede.com</a></p> <p>If you need assistance with a different projects (especially Notes, Domino and web applications) I am available. </p> <p>You can mail me at karl-henry@demandbettersolutions.com</p> <ul> <li><a href="http://www.texasswede.com" rel="nofollow noreferrer">Personal homepage</a></li> <li><a href="http://blog.texasswede.com" rel="nofollow noreferrer">Blog</a> </li> <li><a href="http://www.demandbettersolutions.com" rel="nofollow noreferrer">Demand Better Solutions, LLC</a></li> </ul>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PORuntime error: "Cannot find the library com.ibm.xsp.extlib.library" (browser)
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POHow to get space between icon and label on button?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. CONote that I replace linebreak with \n in the CSV, as linebreak is not valid there. Either do a replace in Excel or replace it with whatever delimiter you like.
      singulars
      1. PO
      1. USKarl-Henry Martinsson
    2. COYou also should not use the prefix txt_ for numeric fields... Most programmers would assume that those fields are in fact text fields. As a new Notes developer, you might benefit from reading this article: http://blog.texasswede.com/how-to-write-better-code-in-notesdomino/ Especially the first article. I am just curious, what is your previous development/programming experience? What languages/platforms?
      singulars
      1. POLotus Notes - multiple IF formula statements
      1. USKarl-Henry Martinsson
    3. CO"If I use @IsNumber, will user be able to enter the decimal separator dot(.) example: 200.23 etc" Was that a question or a statement? IsNumber will use the decimal settings used by the system. So if you use . (period) as decimal point, then if the user enter , (comma), it will not be a valid number.
      singulars
      1. PO
      1. USKarl-Henry Martinsson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload