>not sure you can do it with remote views either - what would >be the update command?)
I'll give you an example with a local view. Take any free table (ie,customers.dbf), use the view designer, for simplicity purposes select all fields, then go to the last page of the pageframe, reset all keys, mark the customer code field as the key field and also mark it as updatable, mark the rest of the fields as updatable, click the send updates checkbox and save the view. Then run it, change any one record and save it. You'll see that the view updated the base table. I suppose that the view uses the customer code field, marked as keyfield and supposedly with unique codes, to update the base table records. In my example, the table is indexed on the customer code field, but as a regular index, not a primary key. And yet, the view works well and updates the base table. Now, I want to replace the view with a cursor adapter. I know that the CA class is supposedly a wrapper for views and improves on them very much. The CA code resides in the form or in a prg file, and not in the DB container. This is to me a major advantage. But the help I've seen is not very clear on how to create updatable cursor adapters from free tables (or bounded tables with no primary keys) Any other takers? >otoh you don't *have* to create ca's to upgrade to vfp9 <s>. I know that, but I just want to improve the inherited app, which is very poorly coded. Most of it is procedural code ported from FoxDOS. Very little oop code in it. Rafael Copquin ----- Original Message ----- From: "Andy Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 06, 2006 2:24 PM Subject: Re: cursor adapters on free tables > Is it possible to create updatable cursor adapters for ... tables ... with no primary keys? iirc - No! (not sure you can do it with remote views either - what would be the update command?) otoh you don't *have* to create ca's to upgrade to vfp9 <s>. Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
