Re: Data entry... dBase IV users? - Steve Edberg - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: Data entry... dBase IV users?

From	Sent On	Attachments
Kevin Speaks	08 Jun 2000 19:13
Steve Edberg	09 Jun 2000 04:58
Kevin Speaks	09 Jun 2000 05:19

Subject:	Re: Data entry... dBase IV users?
From:	Steve Edberg (sbed...@ucdavis.edu)
Date:	06/09/2000 04:58:44 AM
List:	com.mysql.lists.mysql

At 10:13 PM -0400 6/8/00, Kevin Speaks wrote:

Are there any MySQL experts out there that have any experience with dBase IV?

To edit data, I type in

USE TABLE1 BROW

From there, I can change existing data and add new data. How is this done with MySQL?

Yep, I used to use dBase IV (and Db 5, 3, 2, Vulcan, and all the way back to JPLDIS...). As I recall, the BROWSE command allowed you to scroll back and forth through records, re-sort them, and edit/delete/add records.

There is no tool that I'm aware of that is an exact analogue to BROWSE - certainly not in the commandline client 'mysql' - but MySQLGUI (

http://www.mysql.com/download_clients.html

) looks like it comes pretty close. For web-based use, phpmyadmin is pretty versatile. There's also some Java front-ends which are listed, along with phpmyadmin, at

http://www.mysql.com/Contrib/

You could also use a desktop database like MS-Access as a front-end, connecting via ODBC. There have been some problems reported on the list with this, mostly with Access2000 (I gather).

You might even be able to use dBase still; see http://www.dbase2000.com/. It's now produced by KSoft, and is up to version 7.5...it looks like you'd need the "Pro" version for ODBC access.

What kind of platform are you on?

- steve

kevin Curiosity killed the cat, but for a while I was a suspect.

WARNING: I cannot be held responsible for the above because my cats have apparently learned to type.