Solved

How to solve ODBC - Microsoft DBASE Driver Limitation?

Posted on 2004-09-23
8
904 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to know if my Checkbox is True in VB6.0? 9 65
MS Access 03, TransferText, decimal places 8 85
Automatic Email Reminder 4 70
Assign a value in Excel V-Basic 3 28
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.

679 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