Results 1 to 9 of 9

Thread: Lianja 5.3 inline VT VARCHAR editing, long string editing and new Stringlist Editor

  1. #1
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,966

    Lianja 5.3 inline VT VARCHAR editing, long string editing and new Stringlist Editor

    I've been working on improving VT VARCHAR editing in grids and long strings in form sections which can be awkward to edit in a small field.

    Formitems and grid columns now have a few new attributes.

    "Cell Editor Type"
    and
    "Stringlist"

    For long strings you can edit them by selecting the "Cell editor type" as "Text".

    For varchar/memo fields in grids you can select:

    Text -- Edit in a slide in plain text editor dialog panel.
    Html -- Edit in a slide in HTML editor dialog panel.
    Stringlist -- Edit in a slide in Stringlist editor dialog panel.

    The "StringList" can be:

    A command separated list of static strings e.g Coffee,Tea,Beer,Water,Soda
    A {myproc()} macros that evaluates a dynamic expression that returns a comma separated list
    A SQL SELECT command that dynamically retrieves a single column that is used to create the comma separated list.

    A picture says a thousand words. See images below.

    Name:  Screen Shot 2020-02-26 at 11.50.52 AM.jpg
Views: 268
Size:  71.2 KB

    Name:  Screen Shot 2020-02-26 at 6.11.26 PM.jpg
Views: 266
Size:  59.9 KB

    Name:  Screen Shot 2020-02-25 at 9.37.50 AM.jpg
Views: 266
Size:  49.0 KB

    The Stringlist Editor can also be used standalone as a dialog.

    Note that the "Available list" can be a comma separated list, a {myproc()} macro or a SQL SELECT with macros.

    In desktop:

    Lianja.showMoverDialog(cTitle, cCaption, cAvailable, cSelected)

    e.g.

    Lianja.showMoverDialog("Select Items","Items Selected","Coffee,Tea,Beer,Soda,Water","Coffee,Tea ")

    Name:  Screen Shot 2020-02-27 at 4.13.36 PM.jpg
Views: 268
Size:  36.2 KB


    In Web/JavaScript it requires a targetID (e.g. page1.section1.field1) which is updated with the selected value on completion:

    Lianja.showMoverDialog(cTitle, cCaption, cAvailable, cSelected, cTargetID);
    Last edited by barrymavin; 2020-02-27 at 04:19.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  2. #2
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,884
    hi Barry, good improvement.
    One question,
    when I'm on Edit Record mode, the Edit Text Box is not auto opened.
    I'ts normal?

    Thanks
    Fabio

  3. #3
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,010
    Hi Barry,

    Very handy in a lot of existing VFP scenarios. The most likely use for us will be as a component in a showdialogpanel (with a text field to receive the result, although that may be at -20 out of sight). All very straight-forward.

    thanks,

    Hank

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,966
    Quote Originally Posted by HankFay View Post
    Hi Barry,

    Very handy in a lot of existing VFP scenarios. The most likely use for us will be as a component in a showdialogpanel (with a text field to receive the result, although that may be at -20 out of sight). All very straight-forward.

    thanks,

    Hank
    Thats what it does.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,966
    In the next beta build the textbox displays a dialog button which when clicked slides in the dialogpanel.
    Last edited by barrymavin; 2020-02-27 at 20:07.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  6. #6
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,884
    Hi,
    to open the DialogMover by code, i can use:
    lianja.showMoverDialog(...)

    is possible to open che HtmlText edito dialog by code?

    Thanks
    Fabio

  7. #7
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,460
    Hi Fabio,

    Using WebViewWidgets: Web Editor View

    Regards,

    Yvonne

  8. #8
    Senior Member
    Join Date
    Feb 2012
    Location
    Rome - Italy
    Posts
    1,884
    thank Yvonne

    Fabio

  9. #9
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,230
    Very Useful!

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us