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.
>
>--
+--- "I wear the cheese, it does not wear me..." ------------------------+
| Steve Edberg University of California, Davis |
| sbedberg@stripped Computer Consultant |
| http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu |
+----------------------------------- - an unidentified man in a dream ---+