Rick Schummer wrote: >>> I was thinking about adding a BINARY index to a logical/boolean field in > some of our tables and wondered if that would cause problems for the DotNet > (3.x) app that uses ODBC to interact with our database.<< > > I know you have your answer to this problem Mike, but to clarify it for > future archive searchers, the VFP binary indexes are new to VFP 9. The ODBC > driver for VFP is only compatible with features through VFP 6 so the OLE DB > driver is the only way to access the tables with the new index type. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com
It's a good reminder for others, Rick, so thanks for that clarification. I'm also creating a new FREE table that's going to use the Auto-Incrementing Integer (candidate key) field which falls under the same light--must use OLE DB to take advantage of that. Question though--in the help docs, it talks about the binary index for deleted records....I was under the impression that it was for 1/0 kinds of expressions like LOGICAL fields (.T./.F.). In my test builds, it didn't seem to error when I applied a BINARY index on the logical fields, so I'm assuming I'm correct in my usage. Any ideas to the contrary? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
