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,771

    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: 229
Size:  71.2 KB

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

    Name:  Screen Shot 2020-02-25 at 9.37.50 AM.jpg
Views: 231
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: 229
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 03: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,881
    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
    1,948
    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,771
    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,771
    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 19: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,881
    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,379
    Hi Fabio,

    Using WebViewWidgets: Web Editor View

    Regards,

    Yvonne

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

    Fabio

  9. #9
    Senior Member
    Join Date
    Feb 2012
    Posts
    1,214
    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