Re: [libreoffice-users] Basic Macros with Base

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
> <harvey@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+unsubscribe@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