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

Hi Simon,

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

Regards,

Yvonne

Hi Simon,

You are opening the database SHARED.

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

Hank

Hi Hank

Tried without the SHARED & unfortunately makes no difference.

Cheers


Simon

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

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