Results 1 to 5 of 5

Thread: Finding a thread on instantiating a cursor for a section "on the fly"

  1. #1
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,945

    Finding a thread on instantiating a cursor for a section "on the fly"

    Hi Barry, Josip, and all,

    There was a thread recently, on another topic, and in it someone (I thought it was Herb, but can't find it by searching) wanted to know if they could substitute a cursor at runtime for the one specified. Barry replied a few messages later in the thread that this was now possible "in the current build" or words to that effect. And I can't find it.

    TIA,

    Hank

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,770
    Hi Hank,

    Don't recall.

    What is it you are wanting to achieve.
    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

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

    I don't need it for anything, just wanted to review it and tuck it away (Evernote) so I had it for a rainy day.

    Unfortunately, the Search on the forum seems to only catch threads "started by" the user being searched.

    thanks,

    Hank

  4. #4
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    I can only recall that Fabio wanted to have a temporary cursor instead of DB table as a data source

    since it is not possible to insert a cursor in a grid gadget..
    Is possible to create a phisical table, but to be temporary?
    My data is temporary, if I add a table in the DB, if I use the same function from more than one instance.. all the user see the data of other user..
    Herb said:
    You can create a temporary table that is not in the database.

    I know of two ways.

    1. Create table c:\tempfabio free(Firstname Char(10), Id int)

    By using the word free, it keeps it standalone.

    2. use a table that starts with an underscore.

    Select * from masterfabio into table _tempfabio
    https://www.lianja.com/community/sho...in-Grid-Gadget

  5. #5
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,945
    Thanks, Josip. That was the thread, although I see that I conflated that with another thread were Barry indicated he had done something to make that easy.

    As I said to Barry, it's nothing I need.

    Phabio's answer, which effectively asked "can I create a temporary table that looks like the real thing for a user" I solved 4 years ago. <s>

    Hank

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