filepro wish list

Robert Haussmann haussma at nextdimension.net
Fri Apr 29 14:18:30 PDT 2005


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

[...]

> 
> 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.
> 

Interesting scenerio, but in all fairness, *should* this work?
I suspect that it "works" in filePro proper, but what you're
setting out to do is update an undefined record.  mySQL,
MS SQL, etc. are not record-based.  fp_id acts as a type of
bridge between the two systems.  

Given that this is somewhat of a special case, I'd suggest
handling it with a "delete" subroutine that uses low-level ODBC
to update that particular record (via fp_id), and enumerates
the fields, storing NULL in each one.

> 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.

That's exactly how you have to treat them (great explanation).
That's also why, for our purposes at least, the low-level
ODBC routines make much more sense (when dealing with databases
that are going to be updated by external sources).

Bob



More information about the Filepro-list mailing list