Make pre-prepared sql command in libreoffice basic

Question

I'm trying to make a prepared query based on the value in a field in my form in libreoffice basic.For this, I created a macro. But it returns an error on the query line saying

BASIC syntax error. Unexpected symbol: oInstruction_SQL

Sub concatMotherName

Dim oSourceDonnees As Object
Dim oConnexion As Object
Dim stSql As String
Dim oResultat As Object

oSourceDonnees = thisComponent.Parent.dataSource
oConnexion = oSourceDonnees.getConnection("","")
oInstruction_SQL = oConnexion.createStatement()
Dim valueData As String
Dim dateLabel As String

valueData = ThisComponent.Drawpage.Forms.getByName("Form").getByName("id_mother_label").getCurrentValue()
stSql = "SELECT NOM_MERE FROM ""T_MOTHER"" WHERE ""NUM_MOTHER"" = ?" _
oInstruction_SQL = = oConnection.prepareStatement(stSql)
oInstruction_SQL.setString(1, valueData)
oResultat = oInstruction_SQL.executeQuery(stSql)
If Not IsNull(oResultat) Then
   oResultat.Next()
   MsgBox oResultat.getString(1)
End If
End Sub

Jim K · Accepted Answer · 2021-07-02 12:14:09Z

1

There are two syntax problems. The first is the _ after the query string, which indicates that the next line is a continuation of that one. It's not a continuation, so remove it.

The second error is on the next line: = =.

When these errors are fixed, the code compiles successfully.

answered Jul 2, 2021 at 12:14

Jim K

14.1k2 gold badges26 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

samuel potter Over a year ago

oh my god I didn't saw that...thank you so much !

Collectives™ on Stack Overflow

Make pre-prepared sql command in libreoffice basic

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related