NULL? Type? Length? as hidden fields on the form and can therefore validate the input to the table automatically. I pass the table validation information for each column, i.e. SELECT nicename FROM columnnames WHERE dbcolname='dbabnm1' I then use css to format the form and I have a seperate lookup table in the database for user friendly column names,Į.g. The outline of the PHP code I use is below. #How to build data base for form openoffice base softwareWhilst I have never come accross web form designer software for MySQL, I have never really used it as when coding with PHP and MySQL I let the software do the work. Which is part of the http:/ / / wiki/ Category:Base_Documentation page, just in case the longer link breaks. Http:/ / / wiki/ FAQ_%28Base%29#How_can_I_import_a_spreadsheet_table_to_a_database.3F Here is a FAQ entry you may find interesting: I suggest you check them out for yourself. Based off of the KEXI website, i can see that KEXI looks like it may be more user-friendly, but again, i have not tried it recently. I personally am biased towards the OO Base solution, as i have been telling clients and just about anyone who will listen to use Open Office as their home/office document solution. I have not used KEXI in a while, and there have been some nice looking improvements since i last tinkered with it. i am going to just suggest you try them both out. There are administrative MySQL tools available, such as:īut i do not think this is what you want.Īs to OO Base vs. All of my MySQL interaction tends to be from a command line, so i have never researched other options, and am not familiar with this type of GUI based solutions. I am glad to see we are on the same proverbial page, however, i personally do not know of any open source/free web form design programs which can be used to interact with MySQL by the end-user. But even this functionality is some time (~months) away." So maybe I will just hope they can do this and it doesnt take that long for them to develop. #How to build data base for form openoffice base installMind you they have said "We will look at the option of generating your application as a PHP script you can install, so you can take your own app out and install it in your site. I have asked them if ZOHO can be downloaded to run on our own servers, but they have said no. I have seen ZOHO Creator and that looks like what I need, but the only trouble is - it is only available on their website, and would mean I would have to give everyone Internet access in order for them to look at the database (which is not an option). I have also tried looking at Open Source CMS products, but I am not sure if CMS is going to do what I need. I have tried playing with KEXI last night on my KUBUNTU home computer, but I couldnt find a way of making the forms on there save as a web version. I dont like the form designer in MS Access, but it does allow me to pick the fields from the table which is the main thing I am looking for. In Access I assume there is a way to convert/move the tables to an SQL server (also assuming it will allow you to convert to MySQL or similar). I went through a number of tutorials online (usually based on Libreoffice Calc cells), string-searched both main books by Andrew Pitonyak ("Useful Macro Information For " and " Macros Explained (OOME)") but after trying tons of snippets I got nowhere.If it imports from spreadsheets that would be great, but it is not an option I am concerned about.Īt the moment I have imported data into MS Access, so the "data" part is in tables all ready. Last time I used BASIC was probably around 1990. I NEVER used before a macro both in Microsoft nor Libreoffice suites, so I am moving veeery slow. Today is the very first day I play with Libreoffice Base (and its bugs), and this is just something nice that I would like to add for tomorrow's demo. Prints correctly Combo2, so I assume I have a proper reference. #How to build data base for form openoffice base generatorMsgbox() rem Name of the Event generator (Combo1)Ĭb2 = ("MainForm").getByName("Combo2") Msgbox(()) rem returns Checked/Unchecked status of Combo1 This is the macro I have been playing with: Sub MyMacro(oEvent as Object) I expected to find something like tVisible(Combo1.isVisible()) but I have been too optimist. I created a database Form with 2 comboboxes, Combo1 and Combo2.Ĭombo2 visibility depends on Combo1 status: Combo1 checked, Combo2 visible Combo1 unchecked, Combo2 hidden.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |