On Sun, 24 Feb 2008 15:35:22 -0500 Drew Jensen <[EMAIL PROTECTED]> dijo:
> SELECT * FROM "MainBank" > WHERE ( ( "Selections" LIKE '%LFc-___' ) ) > ORDER BY SUBSTR( "Selections", LOCATE( 'LFc-', "Selections") + 4, 3) ASC I have one other issue that has just come up. Using my new query I went to merge the data into a Writer document. The query data showed up fine in the Data Sources window (F4). I dragged it into the Writer document, specified all the fields to merge, and told it to merge. It merged the field names, not the data. Strange - that never happened before. So, to clear the Writer document and try again, I did Select All in the document window and hit Delete. A message popped up "do you want to delete the data." Without thinking I hit Yes, and it proceeded to delete 90 rows from my MainBank table. And it left the bogus text in the Writer window. The text in the writer Window is what was selected at the time. Of course, I should have paid more attention - "data" is not the same as "text." On the other hand, I had no idea that you could delete data from within Writer. What I need is some mechanism so the data in MainBank can never be deleted except from within Base - that is, a way to block Writer from doing anything but reading the data. Because it took me forever to get the CSV file from Kexi into Base, and I don't remember exactly what I did that finally succeeded, so now I have to go through all that again and try to restore the 90 records that I accidentally deleted. Is there a way to allow Writer only to have read permission? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
