7.2 Beta17 Virtual Tables

[SpringBox]

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

[yvonne.milne]

Hi Simon,

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

Regards,

Yvonne

[HankFay]

Hi Simon,

You are opening the database SHARED.

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

Hank

[SpringBox]

Hi Hank

Tried without the SHARED & unfortunately makes no difference.

Cheers


Simon

[HankFay]

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

[barrymavin]

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