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 ...
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 ...
I have the following 2 queries.: shipManagementInvoiceNetValue: SELECT IFNULL (SUM (shipManagementInvoice.netto ), 0) AS shipManagementInvoiceNetValue FROM tckopf AS shipManagementInvoice WHERE ...
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 ...
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 ...
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 ...