Results 1 to 6 of 6

Thread: Select statement from existing VFP tables

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    552

    Select statement from existing VFP tables

    I want to continue using Xcase for my data modelling.

    To create / update tables in my Lianja database I need to do a select statement from some of my Xcase dbf file, vfp files, and then I just work with that cursor for field info and add or update the Lianja tables using code.

    Is there a way in Lianja that I can do a select statement against the vfp tables to do this without having to import them into Lianja tables first

  2. #2

  3. #3
    Senior Member
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    552
    Thanks for that

    With this work with free tables as there is no DBC involved with the Xcase tables I believe.

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,246
    You can just open the VFP table with USE in your code.
    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 MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,071
    Hi David,

    Yes, as Barry says you can USE. I USE with an alias, and having done that you can do whatever you want in terms of select statements.

    Hank

  6. #6
    Senior Member
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    552
    Thanks Barry and Hank, that was much easier than I expected.

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