The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
39 views

DBF corrupted database

I'm in great trouble here. I'm using Microsoft Visual FoxPro 9.0 on my Windows 7 machine. I had some DBF files which was created in MS Visual FoxPro. The files were undoubtedly valuable since they ...
1
vote
2answers
40 views

Can I safely delete .tmp files from a FoxPro 2.5?

Can I safely delete .tmp files from a FoxPro 2.5 application? There are currently over 71k .tmp files. They are located in the root directory and the \TEMP directory.
1
vote
2answers
650 views

Get row from table for last date before date parameter if no row for date parameter or entries null

I have table, which holds the exchange rates for currencies. There is also a Date column, which holds the currency exchange rates acquisition date. For some dates there is a row, but no currency ...
0
votes
3answers
206 views

How to IFNULL or COALESCE rewrite in a SQL query?

I there a way to rewrite a SQL query, so I can avoid IFNULL or COALESCE, because the HXTT DBF JDBC driver (supports SQL92) throws the following error.: Caused by: java.sql.SQLException: The aggregate ...
0
votes
1answer
339 views

Subtract values from SELECT in SQL

I have the following 2 queries.: shipManagementInvoiceNetValue: SELECT IFNULL (SUM (shipManagementInvoice.netto ), 0) AS shipManagementInvoiceNetValue FROM tckopf AS shipManagementInvoice WHERE ...
0
votes
0answers
53 views

Rebuilding indexes and optimizing databases on a directory full of `*.dbf` and `*.cdx` files?

There is a program at work that runs on a directory full of *.dbf (FoxPro "tables") and *.cdx (FoxPro "indexes") files. The program itself has two menu items that we run every day to maintain the ...
0
votes
0answers
66 views

Linking VFP free table directories to SQL databases

My apologies if this is not the correct forum to ask. I'm investigating the possibility of linking 2 VFP free table directories to respective SQL databases in the same server instance. The reason I ...
2
votes
2answers
2k views

FoxPro DBF Index Corruption

We are running a pretty popular application in Russia and other CIS countries through a pretty old accounting system called BEST. It's all built on FoxPro (not Visual Foxpro) DBF/CDX tables. It's open ...