Solved

How to solve ODBC - Microsoft DBASE Driver Limitation?

Posted on 2004-09-23
8
879 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
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now