Vb.net Compile error

MARC

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


    

Comentarios

2 comentarios

Fecha Votos
  • Comment author
    David Bordones

    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'"

    0
  • Comment author
    MARC

    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

    0

Iniciar sesión para dejar un comentario.