I see that if you create a split DB from scratch as outlined here:
viewtopic.php?f=83&t=61183
It will already be using DB 2.3.2 No upgrade is necessary.
-rvguy
Search found 35 matches
- Mon Jan 26, 2015 3:23 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
- Tue Jan 20, 2015 2:36 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
Re: Base Alternative - More Questions
Thank you, F3K. If you notice my "Update" in my post yesterday (a few back in this thread), I did discover that. While we're on the subject, where exactly does the "Version" of the DB come from? I thought it was contained in OO 4.1.1 when I installed it, but maybe I'm wrong? For ...
- Mon Jan 19, 2015 11:26 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
Re: Base Alternative - More Questions
It's recommended to develop a Base file using the embedded database and split it off once the design work is done or mostly done. You can still edit everything in a split database, just certain kinds of changes are less convenient/take more time to do in a split environment. [rvguy] That's what I un...
- Mon Jan 19, 2015 6:38 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
Re: Base Alternative - More Questions
Regarding the link: 1. Does "Create Cached" pertain to 1.8 (embedded) as well as the newer 2.0 and split option? [UPDATE] I have been doing some research and "CACHED" does also pertain to 1.8. Here is something that doesn't quite fit the mold, however. I have a standard 4.1 insta...
- Mon Jan 19, 2015 5:51 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
Re: Base Alternative - More Questions
Wow, scary enough. While I could back up the DB after each session, during the sessions I could add 40, 50 or more records. And if it crashed before saving, while my total database would not be lost, the effort to re-add the last batch is not minimal. Thinking about this, I thought of a Question #4:...
- Mon Jan 19, 2015 3:38 pm
- Forum: Base
- Topic: Base Alternative - More Questions
- Replies: 11
- Views: 1778
Base Alternative - More Questions
I have been reading the post on "Base Alternative" and have a few questions. Rather than clutter up that thread, I started a new one with these questions. 1. It is said that the "embedded" database that comes bundled with Base is "prone" to data loss and should not be u...
- Sat Jan 17, 2015 7:46 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Duh !! As much as I have worked with SQL I should have known that. Guess sometimes it's just a little too obvious. That's got it. Thank you.
- Sat Jan 17, 2015 4:40 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: [REOPEN] Retrieving the "count" (number of attached reco
Well, all works EXCEPT when there are no attached photos. Records with no photos do not show in the list. I know it's the SQL statement INNER JOIN (records must exist in both tables to be selected) but have been unsuccessful in debugging it. Help ?
-rvguy
-rvguy
- Fri Jan 16, 2015 9:15 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
I'm going to have to spend a few (long) minutes deciphering that SQL statement to determine how it is functioning. But, the bottom line is ... "IT WORKS". I'm not sure how changing the SQL made the form "editable", as you say, but it works perfectly. And, the sort functions on th...
- Fri Jan 16, 2015 8:08 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
It doesn't even get to the macro .... the ID is not even a link. When it works and I click on an ID in the ID column it highlights the ID number and creates a "link", then allows me to click. On this form, when I click on the ID nothing happens. It's just like clicking in any of the fields...
- Fri Jan 16, 2015 6:05 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Even though I am not a Base expert, I am an experienced developer and am also logical. It seems to me the a "Query" is just that - a query. And logically to have it incorporated into a form it will work, but you are limited to the functionality of a query. And although I don't have specifi...
- Fri Jan 16, 2015 5:53 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Oh, so sorry MTP. Yes, this was the macro from the previous thread. However since then I have created new tables and new fields ... same application. For instance the table is now called "Assets" (upper-case "A"), the InventoryID is now called AssetID and the form it opens is now...
- Thu Jan 15, 2015 11:50 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Yes, I did make sure everything was still there. The "event -> mouse button pressed" still calls the macro and the macro is still valid. I believe the event is bound to the AssetID column (in design mode I click on the AssetID Column Heading and it brings up the Properties window, and it's...
- Thu Jan 15, 2015 11:07 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Thanks, MTP. But, one step forward and one step back. I followed your instructions along with FJCC's SQL, and the form and specifically the Photos column now works like a charm ... exactly what I wanted. However, if you remember from above that I made the AssetID a link to open the Asset Detail form...
- Thu Jan 15, 2015 10:25 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
Hey Villeroy, That what I've been hearing. But I am moving into this at a slower pace. I used SQL to create the tables vs. the Table Wizard. Much better control. On the forms, I have been using the Wizard to create the basic forms, then go into Design Mode and tweak. My forms are really not that com...
- Thu Jan 15, 2015 10:11 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
Re: Retrieving the "count" (number of attached records)
F3K: I am not sure how to implement your code. What I did was to use the Form Wizard to create a simple grid. On the grid I included a few fields ... AssetID, Name, Model, Serial. Then, in design mode for this new form I clicked on the header and added a new column which I simply call "Photos&q...
- Thu Jan 15, 2015 6:38 pm
- Forum: Base
- Topic: [Solved] Retrieving the "count" (number of attached records)
- Replies: 21
- Views: 4637
[Solved] Retrieving the "count" (number of attached records)
I have 2 tables - "Assets" and "Photos". The Assets is my primary table, with "AssetID" as the primary key (unique), Name, Model, Serial, and a number of additional fields. I also have a "Photos" table with PhotoID (Primary key), AssetID (FK to AssetID of the ...
- Tue Jan 13, 2015 4:47 pm
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
Re: How do I set up tables and forms for photos
Wow, I didn't know that. I have been using the My Macros container because all info I have found on the internet with examples of what I was trying to accomplish just show the macros contained there. Nowhere did I see any put into the specific file container, nor was there any explanation on this. T...
- Tue Jan 13, 2015 3:56 pm
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
Re: How do I set up tables and forms for photos
Thank you, MTP, for your help so far. On the sort, I created my own work-around. I will have a form(categories) / subform (assets) scenario using grids. Then I can see the categories at a glance, and when I select a specific category, it will show all the assets linked to it in the subform. Of cours...
- Mon Jan 12, 2015 9:39 pm
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
Re: How do I set up tables and forms for photos
Well, the cascade delete is what I needed. I am certainly learning much, but still some things are puzzling. One thing I cannot figure out is this: I have the two forms - main asset form and the photos subform. They link properly and will display properly. But when I am in the form and adding new it...
- Sat Jan 10, 2015 3:00 pm
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
Re: How do I set up tables and forms for photos
Well, after much playing around I did get it to work. However, not quite the way you described. I did not understand about "set up the subform with the photo table as the source". And I could not find Properties -> Data tab -> Link master fields for the photos . But here is what I did, and...
- Fri Jan 09, 2015 2:12 pm
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
Re: how do I set up tables and forms for photos
Thanks for the links, MTP. But I have been successful in setting up a single table with data and images along with a single form to enter the data and add photos. I have been successful at using both internal and external images. That is not the problem. What I am now trying to do is rather than hav...
- Fri Jan 09, 2015 2:58 am
- Forum: Base
- Topic: How do I set up tables and forms for photos
- Replies: 10
- Views: 3205
How do I set up tables and forms for photos
I have been searching the internet and from what I gather I can do this, but I have not found out how to do it. I have a Home Inventory application. My main table is called "assets" and contains the InventoryID (primary key) along with all the data fields normally associated with a Home In...
- Fri Jan 09, 2015 2:44 am
- Forum: Base
- Topic: OpenOffice does not find installed Java
- Replies: 2
- Views: 722
Re: OpenOffice does not find installed Java
I had the same problem when I tried using OO on my laptop. I had to re-install Java and the JRE because the versions I had installed were outdated and open to attacks. But after I deleted old versions of the JRE and installed the latest version, OO Base would not work because it could not find the J...
- Thu Jan 08, 2015 2:53 pm
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
OK, I figured this one out. For anyone following this thread, the solution: I replaced: --------------------------------------------------------- oNewDocForm.absolute(i) -------------------------------------------------------- with this: -------------------------------------------------------- oNewD...
- Thu Jan 08, 2015 2:22 pm
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
I guess I spoke too soon, but this should be an easy one. Retrieving the record via "oNewDocForm.absolute(i)" is fine until I deleted one record. Then, of course, the retrieval is one record off. For example selecting ID=6 actually opens with ID=7. I need to be able to retrieve the detail ...
- Thu Jan 08, 2015 2:34 am
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
Hallelujah ... It works !!!! All is now good. It works properly with just i, bringing up the detail record matching the InventoryID number. I want to sincerely thank you, MPT, for your help. You have helped with more than just a technical solution. Sometimes when I am helping others in PHP or MySQL ...
- Thu Jan 08, 2015 12:15 am
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
OK, here is what I have right now (including your new suggested statements): Sub OpenForm () Dim prop(1) as New com.sun.star.beans.PropertyValue forms=ThisComponent.Parent.getFormDocuments() conn=ThisComponent.Parent.DataSource.getConnection("","") prop(0).Name="ActiveConnec...
- Wed Jan 07, 2015 11:03 pm
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
In the summary form (starting form):
Forms
.... MainForm
........MainForm_Grid
In the detail form (form I want to open up when ID is clicked):
Forms
.... MainForm
........lblInventoryID
........fmtInventoryID
........lblManufacturer
........txtManufacturer
etc. etc. for all the fields in the table
Forms
.... MainForm
........MainForm_Grid
In the detail form (form I want to open up when ID is clicked):
Forms
.... MainForm
........lblInventoryID
........fmtInventoryID
........lblManufacturer
........txtManufacturer
etc. etc. for all the fields in the table
- Wed Jan 07, 2015 6:42 pm
- Forum: Macros and UNO API
- Topic: [Solved] Open a form with a specific record id using macros
- Replies: 19
- Views: 15605
Re: Open a form with a specific record id using macros
I think we are making progress (maybe). These statements do not give me any error, and it does in fact open the detail form when clicking the ID in the summary form. But it opens the detail form to the first record (InventoryID=1) no matter which ID I click on: oDoc = forms.loadComponentFromURL(&quo...