Solved

How to solve ODBC - Microsoft DBASE Driver Limitation?

Posted on 2004-09-23
8
916 Views
Last Modified: 2013-12-20
Hi Techies,

To create DBF using Microsoft DBASE Driver(*.dbf), the limitation of Microsoft DBASE Driver is:
While dBASE allows a precision and a scale to be specified with a NUMERIC data type, it is not supported by the ODBC dBASE driver. The ODBC dBASE driver always returns a precision of 15 and a scale of 0 for a NUMERIC data type.

How do I overcome this?
Say, I need a field to contain currency, I would like to specify the length of that field to be 10,2. How can this be done?

Thanks in advance.
0
Comment
Question by:lakshmi_n
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 12144039
Can you create it as a Long instead?

Leon
0
 

Author Comment

by:lakshmi_n
ID: 12158115
Hi Leon,

I cannot change the currency field of the DBF to long, as the DBF is used by another system, which has been designed to take up DBASE - DBF with Numeric data type for that particular field.

Is there any way to change the format(structure as (10,2)) after creating the DBF atleast?

Thanks
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 12185402
The other system you mention, is it in fact a dBASE system?  Or is it really a FoxPro system?

The reason I ask is that the dBASE driver supplied by MS is a lowest common denominator driver where if you actually could use the freely downloadble FoxPro driver that supports .dbf files you might have more control and functionality.  dBASE is not a MS product where FoxPro/Visual FoxPro is.

Visual FoxPro ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

No guarantees, but another possible way to attack your problem.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 29

Expert Comment

by:leonstryker
ID: 12972232
I believe CarlWarner should get these points.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12996081
PAQed with no points refunded (of 500)

modulo
Community Support Moderator
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 12997177
I'm glad I could help.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question