Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word won't open DBF
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00916551
Message ID:
01081747
Views:
31
I don't believe that would pertain my string is only 195 characters. This is another intersting KB, 834699. It suggest using "`", the single back quote for field names. Take a look at this:
{DATABASE  \d "O:\\Finacct\\Source\\Directory\\Data\\memodata.dbf"
\c "DSN=FoxPro Table;UID=;PWD=;
SourceDB=O:\\Finacct\\Source\\Directory\\Data;
SourceType=DBF;Exclusive=No;BackgroundFetch=No;Collate=MACHINE;
Null=Yes;Deleted=Yes;" 
\s "SELECT nproperty as '. Property Number .', descrip as '.                             Description                             .', amt as '.    Cost    .', serialno as '.  Serial Number  .' 
FROM memodata.dbf ORDER BY `nproperty`" \l "2" \b "63" \h}
Pretty simple but I get "Error! Cannot open data source." The as name has spaces to create the field width needed.


>Have you done any experomenting yet?
>
>No, sorry. But I did find this in MSDN if that is any help:
>
>Knowledge Base
>
>WD: Error Messages When You Try to Connect to a Mail Merge Data Source by Using the Mail Merge WizardPSS ID Number: 318532
>
Extreme Programming = Plan -> Design -> Code -> Test
Previous
Reply
Map
View

Click here to load this message in the networking platform