Results 1 to 6 of 6

Thread: 7.2 Beta17 Virtual Tables

  1. #1
    Senior Member
    Join Date
    Jan 2014
    Posts
    369

    7.2 Beta17 Virtual Tables

    Hi guys

    All was well with virtual tables connecting to VFP9 indexed table with primary key.

    We normally connect using :


    OPEN DATABASE pdsw shared
    DROP TABLE pdsw!vt_iPadImport IF EXISTS
    create virtualtable pdsw!vt_iPadImport connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=S:\xxxxxxx\iPadImport.dbf;Exclusive=No;Base table=iPadImport.dbf;Primarykey=cust_id" as select * from iPadImport


    but after 7.2 Beta 17 when we run this code, the VT vt_iPadImport is created but it crashes the code and when we try to open it manually in Lianja we get a Catastrophic failure warning. Tried everything to recreate but always the same - in DEV and web.

    Do we need something extra in the connection string.

    Cheers


    Simon

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,905
    Hi Simon,

    Set debug on and submit a ticket with the debugging file(s) attached.

    Regards,

    Yvonne

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

    You are opening the database SHARED.

    Does the same error happen when you simply OPEN DATABASE without the SHARED?

    Hank

  4. #4
    Senior Member
    Join Date
    Jan 2014
    Posts
    369
    Hi Hank

    Tried without the SHARED & unfortunately makes no difference.

    Cheers


    Simon

  5. #5
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,187
    Hi Simon,

    If you were in the LAB, SET EXCLUSIVE is on by default. Outside the LAB, you would need to OPEN DATABASE EXCLUSIVE (or SET EXCL ON).

    Hank

  6. #6
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    7,359
    Blog Entries
    22
    Hi Simon,

    As already answered on the ticket you submitted,

    create virtualtable pdsw!vt_iPadImport connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=S:\xxxxxxx\iPadImport.dbf;Exclusive=No;Base table=iPadImport.dbf;Primarykey=cust_id" as select * from iPadImport

    That is gibberish.

    You have specified a CONNSTR as oledb then added "basetabe" and "primarykey" to that oledb connection string.

    I don't know why you dont just use the GUI which will create it properly.

    //
    CREATE VIRTUALTABLE tablename [IF NOT EXISTS] [ALIAS aliasname] CONNSTR "dsn" [TABLE 'basetable'] [PRIMARYKEY 'column'] [PROPERTIES 'prop=value;...'] [AS select_statement]

    create virtualtable pdsw!vt_iPadImport connstr "oledb:Provider=VFPOLEDB;Mode=Share Deny None;Data Source=S:\xxxxxxx\iPadImport.dbf;Exclusive=No;" table 'iPadImport' Primarykey 'cust_id' as select * from iPadImport
    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

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