Solved

How to solve ODBC - Microsoft DBASE Driver Limitation?

Posted on 2004-09-23
8
908 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hide vba in gp 7 127
Passing a Text Box name to a Sub 6 104
Where is user Lync data stored 4 134
VBA- How to change font, color and format in outlook e-mail sent from Access 2 173
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.

738 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