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