The only reference, I found to DoCmd in the LO Base Guide 7.3 is on page 504 (Special commands), i.e. rather brief ("To name a few").
As the employed syntax compiles in LOBase without error, I assume it is correct as described below, so far. So I'm looking for a better explanation for the behaviour. By the way, I am running Version: 7.3.4.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Calc: threaded LO Base is my front end toward a Mariadb (V10) as backend database server system. Cheers Harvey On Tue, 2023-01-24 at 14:45 -0500, Andrew Pitonyak wrote: > > I am not familiar with "DoCmd.RunSQL", I will have to look it up > (unless you have a few links). Is DoCmd a server? > > I have not used Base with Macros in a long time, but, last time I > did, I was creating connections to a database and then running SQL > commands using a connection object. > > I have examples in AndrewBase.odt if that is of any help to you. > > https://www.pitonyak.org/database/ > https://www.pitonyak.org/database/AndrewBase.odt (called Random DB > Ramblins, and yes that is spelled incorrectly). > > > On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo > <har...@nimmo.de> wrote: > Where can I find the syntax of the DoCmd.RunSQL command to be used > with > a LOBase Macro in Basic? > > My assumption was > X = "SQL string" > DoCmD.RunSQL X > > The SQL string runs correctly is correct when executed as SQL Command > in the Base Tools/SQL window. > > The Basic Macro with the above statemsnt compiles without error when > the SQL command text is enclosed in "" quotes. But at runtime it > halts > with the message that the variable X is not set. However, a Basic > Print > statement shows the correct value for X. > > (By the way, the Watch function displays no values for any variable. > Not sure if it should) > > My conclusion is that I ma using the wrong syntax for DoCmd.RunSQL > > Any ideas? > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy