Microsoft VB doesn't know how to talk to Microsoft FoxPro 
Author Message
 Microsoft VB doesn't know how to talk to Microsoft FoxPro

Does anyone know of a good way to do native interaction with a FoxPro
table?  I say "native", because the Jet engine doesn't really know what
it's doing with FoxPro.  In particular, a FoxPro field has a width and a
number of decimal places, but the Jet Field object just has a Type
property.  If you use this to add a numeric field, you always get a FoxPro
Numeric 17 field, with 6 decimal places.  I need more control than this.
Help me!
--
Joshua Frank
Knowledge Developer
Molloy Group

http://www.*-*-*.com/



Tue, 13 Jul 1999 03:00:00 GMT  
 Microsoft VB doesn't know how to talk to Microsoft FoxPro


Quote:
>Does anyone know of a good way to do native interaction with a FoxPro
>table?  I say "native", because the Jet engine doesn't really know what
>it's doing with FoxPro.  In particular, a FoxPro field has a width and a
>number of decimal places, but the Jet Field object just has a Type
>property.  

Wrong! It also has the Size property and lots of other useful ones.

Quote:
>If you use this to add a numeric field, you always get a FoxPro
>Numeric 17 field, with 6 decimal places.  I need more control than this.

And you have it, so what's the problem?

Quote:
>Help me!

One of the best ways to make a FoxPro database "native" is Importing
its data into a MS Access table. Then work with a truly relational DB
from VB.
Quote:
>--
>Joshua Frank
>Knowledge Developer
>Molloy Group

>http://www.molloy.com



Wed, 14 Jul 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Microsoft VB doesn't know how to talk to Microsoft FoxPro

2. Microsoft doesn't know whats happening??

3. Microsoft doesn't know whats happening??

4. Microsoft doesn't know whats happening??

5. Microsoft DOM doesn't support schema's

6. Microsoft's KB Q113236 Doesn't work

7. Who's right Microsoft or Microsoft

8. Who's right Microsoft or Microsoft

9. Who's right Microsoft or Microsoft

10. microsoft.public.vb.general.discussion, microsoft.public.vb.enterprise

11. Microsoft example doesn't work

12. Microsoft example doesn't work...

 

 
Powered by phpBB® Forum Software