filepro wish list

[Fairlight]

The honourable and venerable Walter Vaughan spoke thus:
> 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.

I -think- what you're citing is simply a discrepancy between SQL's DELETE
and filePro's notion of a freechain.  What about approaching it differently
and including a field:  fp_del char(1)

Instead of hard-deleting the record from SQL, soft-delete it via this field
being 'Y' or 'N', and take that field into account in any operations you
perform?

Am I getting you, or am I missing the point?

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

And on a busy system, that could be outdated by the time you finish
creating the actual index.  Useless in that kind of situation.

mark->
-- 
          *****   Fairlight Consulting's Software Solutions   *****
OneGate Universal CGI Gateway:                  http://onegate.fairlite.com/
FairPay PayPal Integration Kit:                 http://fairpay.fairlite.com/
RawQuery B2B HTTP[S] Client & CGI Debugger:     http://rawquery.fairlite.com/
Lightmail Mail Sending Agent:                   http://lightmail.fairlite.com/
FairView Image Viewer for Integration:          http://fairview.fairlite.com/