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

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 ...

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...

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...

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:...

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...

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.

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

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

OK, I figured this one out. For anyone following this thread, the solution: I replaced: --------------------------------------------------------- oNewDocForm.absolute(i) -------------------------------------------------------- with this: -------------------------------------------------------- oNewD...

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 ...

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 ...

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...

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

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...