Vb.net Compile error

MARC

• September 26, 2022 14:48

Hi expert

in a UF code dynamique ( VB;net) i'm an error when i compile the code 

I use a Db Hana

This is a part of code where is the error

Dim oRec As SAPbobsCom.RecordSet
    oRec=company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
Dim Qstr as String
    
    Qstr="SELECT T2."DocNum", T2."U_Dossier", T2."CardCode", T2."DocDate" FROM OQUT T0  INNER JOIN  RDR1 T1"""

I want to create a string  then execute  DoQuery

oRec.DoQuery(Qstr)

but I have an error when in compile the code

I have try to replace "" par \" before he name of the column but it's same i have an error

Can you help me

 

Thank's

    

Vote

0

• 

  David Bordones

  • October 03, 2022 07:29

  Hi Marc, 

  Have you tried your string like this?

  string query ="SELECT T1.\"ItemCode\" FROM ITM1 T0 INNER JOIN OITM T1 ON T0.\"ItemCode\" = T1.\"ItemCode\" WHERE T0.\"PriceList\" = 1 AND T1.\"ItemCode\" LIKE '@STORE1' AND T1.\"U_IMatrix\"='N'"
• 

  MARC

  • October 03, 2022 14:57

  Hi David

  I have tried \"  but the resulta it 's the same

  I'm searched on web and I have find this

  Dim Query as string

  Query="SELECT T1.""ItemCode"" FROM ITM1 T0 INNER JOIN OITM T1 ON T0.""ItemCode"" = T1.""ItemCode"" "

  I replace the character \ with the character " and this amounts to putting two "" in front of the name of each field when we want to encapsulate it in a string

  Thank's for your help

Please sign in to leave a comment.