Connection string with keys for FoxPro files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

I have a followup to a situation I posted earlier. I would like to link
tables to a FoxPro database using VBA code. I cannot seem to find
information on how to specify keys for a given table when linking to that
table. Examples would be extremely helpful!

Thanks,

Greg
 
Hi Greg,

I found the following, originally posted by Steve Jorgensen:

"If you don't manually specify the primary key fields when linking a view,
you have to specify it using a DDL query. In my case, I have a table of
view names and DDL statements to re-create the virtual keys. My re-link
routine relinks each view, then uses a temporary querydef to execute the
associated DDL query.

The DDL query format is as follows:
create index <indexname> on <viewname>(<fieldname>[,<fieldname[...]]) with
primary "
 
Back
Top