4gl 使用 java 來執行查詢

 

大至如下, 在這只是作個註解    

let l_sqlurl =
                "jdbc:sqlserver://172.16.1.xxx:1433;"
                ,"database=mydb;"
                , "user=userid@172.16.1.xxx;"
                , "password=pwdpwdpwd;"
                , "encrypt=true;"
                , "trustServerCertificate=false;"
                , "loginTimeout=30;";

    call java.sql.DriverManager.create() RETURNING l_DrivMan  
    call l_DrivMan.getConnection(l_sqlurl) RETURNING l_conn
    call l_conn.createStatement() returning l_segment
    call l_segment.executeQuery("select * from users") returning l_resultset
      
    while  l_resultset.next()
      Display l_resultset.getString(1)
    end while    

VS 2016 專案更新到 VS2019 後原本多語系的功能都只回預設的那個語系.

 VS 2016  windows form .net framework 3.5 

把專案改成 .net framework 4.0 後就可以了.

很鳥的問題