B4J Question ABMaterial Generator

Discussion in 'B4J Questions' started by wangondu, Sep 26, 2017.

  1. wangondu

    wangondu Member Licensed User

    this morning as i was going through ABMaterial Helper i came across ABMGenerator and clicked on generate code button at the bottom of the page.I have studied the codes and I have created code module and called it DBM.

    Sub ABMGenSQLInsert(SQL As SQL, Query As String, Args As List) As Int
    Dim res As Int
    Try
    Select Case DatabaseType
    Case 0
    SQL.ExecNonQuery2(Query, Args)
    res = ABMGenSQLSelectSingleResult(SQL, "SELECT last_insert_rowid()", Null)
    Case 1
    SQL.ExecNonQuery2(Query, Args)
    res = ABMGenSQLSelectSingleResult(SQL, "SELECT LAST_INSERT_ID()", Null)
    Case 2
    Dim ABSQL As ABSQLExt
    res = ABSQL.ExecNonQuery3(SQL, Query, Args)
    End Select
    Catch
    Log(LastException)
    res = DBERROR
    End Try
    Return res
    End Sub

    question in the above subroutine "ABSQLExt" am being informed it is missing as library
     
  2. alwaysbusy

    alwaysbusy Expert Licensed User

    This is my personal library for MS SQL. You can comment out this code.
     
  3. wangondu

    wangondu Member Licensed User

    okay thanks .
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice