filepro wish list

Walter Vaughan wvaughan at steelerubber.com
Fri Apr 29 13:57:14 PDT 2005


Robert Haussmann wrote:
> As far as "automatically start working with the databases" goes,
> I wouldn't go quite that far.  Depending on your specific need
> (high level vs. low level connectivity), however, the setup can
> be pretty straightforward.

...The following only applies to high_level ODBC...

Remember I am the *Biggest* fpODBC fan in the world. What does not work 
(or if does please someone show me my error), is that filePro cannot 
deal with deleting records stored in an ODBC database and then store 
data in that deleted record. At least in MySQL.

So if all you want to do is add records, and build reports, it'll work 
like peaches and cream. Try to update a record that has just been 
deleted and you're up in smoke.

In My Opinion, there needs to be written an export tool that would build 
in the DBMS's a stored proceedure that would set a deleted record flag 
and null out the data, but still allow linkage to a record number. Thus 
the record will appear  blank, but will exist as a "record" in the DBMS.

I Am Not An ODBC Expert, but if an OBDC Data Source recieved a "filepro 
type" delete, and would just "work" like filePro and kick of a stored 
procedure to accomplish the goal, then we'd have something.

[.. steps to reproduce problem..]
Creat a table in MySQL with two fields
Name		Type	Length
-----		------	-------
RN		int	8	Primary Key
Data		varchar	10

Connect using MySQL ODBC driver version 3.51

Create a filePro ODBC file based upon the above table

Add three records with text. filePro properly handles and creates record 
numbers as needed.

Delete record number two.

Try and update record number two.
Here's where it gets fun, and so far I have not seen a way to deal with 
configuring around that.

Secondly, filePro only uses it's indexes. If the data is modifed by the 
external means, you will have to run dxmaint before using an index. In 
essence, you have to treat all indexes as demand indexes that are only 
as good at the time you create them.


More information about the Filepro-list mailing list