Hi, If your Paradox Apps are written in a reasonably DB-independent way using Delphi Components, and not expoiting and Paradox-only features (are there any?), then porting those same applications to MySQL via ODBC should be a manageable task.
If you do need to start from scratch, and the functionality is simple, then an Access Forms app, using MySQL Linked tables would be an option. M2CW Quentin -----Original Message----- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:38 a.m. To: [EMAIL PROTECTED] Subject: RE: Editing Forms MySQL provides a rich list of APIs with which scripts and programs perform data management. Other than directly entering INSERT and UPDATE commands directly at the mySQL command line, there is not built-in data entry functionality. Data entry (including, verification, validation, limit-checking) is performed by scripts (PERL, PHP) or programs, such as those written in C. <SUBJECTIVE_OPINION> The easiest method to create data entry is browser-enabled forms using a PHP script front-end. The API is quite extensive and easily handles tasks I've had to write hundreds of lines of code in years past. Since everyone has a browser on their desktop, this prevents you from developing thick-client interface. If some client-side calculations are required (thin-client technology), these can be easily handled in JAVA or JAVASCRIPT. Finally, having started from a browser-based application, migrating your application and database to the internet is far less costly and time-consuming </SUBJECTIVE_OPINION> The lack of data-entry and programming functionality is a fact-of-life of the SQL-family of relational databases. Like you, I, too, come from a dBase/FoxPro/Access development world where these capabilities were built-in to the database engine itself. The SQL-family simply provides an API access to your data and leaves insertion, update, retrieval, and display to your own devices. -----Original Message----- From: Robert A. Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: Editing Forms I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end tool but am unsure of where Paradox is going and my customers are tired of the lost indexes and val files that come with Paradox even though I feel that it has served them very well. On to the question. I cannot get a sense of what a MySQL database would look like. In Paul Dubois's book and Sams "Teach Yourself" the references in the index have a paucity of references to data entry. The favoured version being to dump the data in from another file. I must write a data-entry front end for a large amount of data for a small business. Half of the code I usually write is meant to present the user with a fast, secure, set of customized data entry forms. I can find almost no code for this outside of the browser interface. Am I barking up the wrong tree with MySQL asking it to be something that its not or am I simply too myopic in my search. Can I put together a database that will function in a small office that may eventually, and I say this with some hesitation, move access of the data to the web. My problem is trying to envision the end product and am I am having great difficultly. Would Delphi and/or Kylix make this a viable operation. Thank You Robert Smith --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
