Hi, wonder if anybody can help. I have been having an intermittent problem with the Query Design page, which I cannot seem to resolve. The three sections displayed (when not using SQL directly) from top down are Results Section Tables Relation Section Fields Selection/Manipulation Section On first c...

Many thanks SlideRule. :D I had searched for "padding" through the HSQLDB documentation, but obviously not hard enough. :oops: I am definitely going for the Trigger on creating the record and using a macro to insert and update, but I run through the query route first to help me get a hold ...

Hello all! I'm trying to create a unique reference which consists of a 3 char code, plus another 3 char code and finally a 3 digit number I have: Three tables 1,2 & 3, each with IDs and Codes The tables are linked with Table 1 being the parent of Table 2 and the grandparent of Table 3 My aim is ...

VisitFilter SELECT "Visit"."Date","Visit"."VisitTypeID", "Visit"."ClinicID", "Payment"."PaymentID", "Commission"."CommissionID" FROM "Visit", "Payment", "Commission" WHER...

Updated above.

Hi, I believe that the following are errors in your tables. Table "VisitType" shows records "VisitTypeID" 0 through 6 Table "Clinic" shows records "ClinicID" 1 through 4 Table "Visit"."VisitTypeID" shows entries 1 through 8 therefore all re...

Deleted

Hi Sliderule, Yes, using 2.3.0, although not always knowing what I'm doing. I seem to blunder along and find my way somehow. Thank you, the code works perfectly, and it also helped me to sort out the code from Villeroy, which I eventually managed to get to work as follows (for other dunces like me):...

Syntax error means I've not input it correctly - the grammar is wrong. I'm not sure what error message you mean, but no it has not helped me. SQL Status: S1000 Error code: 1000 SQL syntax error There was another which said "unexpected $end, expecting IN etc", and Unexpected AS. I do know b...

Hi Villeroy, Many thanks for response. I've spent a little while looking at this to try and find out what you have done, but am missing something. I have taken your code and substituted my name for "ThisDate" for the actual field in my db and my table name for "SomeTable", howeve...

Hi all, I am not sure if I am posting in the correct area, please tell me if I am not. Is there a similar function to the Oracle NEXT_DAY Function. I am trying to return the date of the next Monday to a specified date. e.g. "ThisDate" = Thursday 15th June Need "ThatDate" = Monday...

Hi Charlie, Many thanks. All working well!! My new code: sub enterpayment Dim oForm, oFields Dim Response,nRow as integer Dim sSQL as string Dim oTotal as Double Dim oValue2 as Integer oForm=ThisComponent.Drawpage.Forms.getByName("MainForm").getByName("Invoices") 'get subform oTa...

Well this is what I have so far. It is wrong, because I can not, despite reading all sorts of items during the last few days, from Messrs Pitonyak, Benitez and Boyd, (my head is swimming) get oSum and oValue2 into the SQL statement properly. If I print oSum and oValue2 out to screen separately, they...

Right, where to start? I'm not sure of the terminology which is rather hindering searching for help - so here goes. I have a Form (user entry) with a MainForm from a table "Customers" and a GridControl subform from a table "Invoices", linked by CustomerID primary key of "Cus...

You can always add a multi-line text box to display long text values. You mention a list box with , so your long text might belong to another table than the form's table. Add a subform which includes the primary key and the long text at least. Bind the primary key to the parent form's related ID (t...

Thank you for response, and alternative suggestions.

UPDATE:

Downloaded and using HSQLDB 2.3.0 Snapshot and everything working back the way it did.
Many thanks, again.

Many thanks Sliderule. I wasn't aware of that, and have no idea how long I have been using 2.2.9! I will change to the new HSQLDB 2.3.0 when it comes out in 7 days and mark this as SOLVED, once you have had a chance to reply. I was about to post another topic regarding the strange behaviour of queri...

Hi, Using OpenOffice as front end to HSQLDB. I have been experiencing some strange behaviour with my database lately. Obviously, I have become aware that to manage memory, some tables only list a certain number of records and then display the number with a star * indicating that there are more. Howe...

Hi, 2 tables: 1 with account numbers (primary key) linked to 2nd table with addresses. I have a listbox which selects an account number. This then populates another listbox with a concatenated address automatically. However, sometimes the resulting address is too long for a single line of text in my...

Hallo You tell us nothing about your Formulas which return #Value :? For Example =SUM(A1:A3) ignores Text in Range A1:A3 the same written as =A1+A2+A3 returns #Value if there is text in one or more Cells of A1:A3 Karolus Hi Karolus, Thank you for replying. In my particular case columns A & B ge...

Hi JohnSun

That was so quick. Yes that is exactly what I needed!

Many thanks - will mark solved.

Hi, I've been trying to get this right for a while now, but keep ending up down blind alleys. Basically I'm not sure what terminology to search on. Problem: I have a spreadsheet with several formulas, which works well. However, I occasionally need to input a text item into some of the cells which wo...

Regrettably ommitted to mark this thread solved. Did use INSERT and SELECT INTO in the end. Sub Test oDatabaseContext = createUnoService( "com.sun.star.sdb.DatabaseContext" ) oDataSource = oDatabaseContext.GetByName("MY_DATABASE") oConnection = oDataSource.GetConnection("&qu...

I managed to get this sorted and am now happily butchering macros supplied by DACM [Example] OpenForm with Macros Link is to a different thread in this Forum (RoryOF, Moderator) I have found that if I changed part of the code using ConvertToURL everything works fine. So Sub OpenFormFilter_4 (oEvent ...

I have managed to open reports using the DBDocShortCuts extension and using this to create a shortcut to a report and then assigning the shortcut .bat file to the execute event of a push button. It seems to work.

how can i open a form in using standalone forms using ID?

No help but I have exactly the same problem. Might bump this thread up

This does not work for reports - the reports are not dynamic. I believe that if you download the extension DBDocShortcuts, you can create a shortcut to your report and then paste this shortcut into the URL of your push button and it will run the report. Only (very small) downside is that the termin...

Well I think I have found the cause of or at least the general area of my problem. There is a macro which has to be assigned to the open document event of my database. I have assigned it (wrongly I believe) to the .odb file, but think I should be assigning it to the actual database file, which is no...

I have just posted this on the "other forum", but thought I would repeat it here. This is wonderful. From OpenOffice.org Forum The solution is based on an extension I posted a few days ago. It's called Access2Base and you can find it on http://extensions.services.openoffice.org/en/project/...