Dynamic File Driver Error -104

1

Using Clarion 11.1.0.13758 dynamic driver not working correctly.

I’am getting a error -104 sending query by Prop:SQL}
In the code below TheFile{PROP:Sql} gives me a error, createFromSql not giving any error

SQLTable &DynFile

SQLTable &= NEW(DynFile)
SQLTable.UnfixFormat()
SQLTable.ResetAll()

		   SQLTable.SetDriver(AnyTable)
           SQLTable.SetOwner('smart')
    
           SQLTable.CreateFromSQL(Query) (This query is ok)
                    TheFile &= SQLTable.GetFileRef()
                    IF STATUS(TheFile) = 0 THEN
                      OPEN(TheFile)
                        IF ERRORCODE() THEN MESSAGE(ERRORCODE() & '-' & fileerrorcode()). Not getting the error
                    END
                    TheFile{PROP:Sql} = Query
2

That PROP:Sql call is not needed. If CreateFromSQL succeeds the table is populated with results of the query and ready to go. Some thing like this :

myDynFile   DynFile
myFile      &file   
myBuffer    &group 

    code

    myDynFile.SetName('MSFile') 
    myDynFile.SetDriver('MSSQL') 
    myDynFile.SetOwner(SomeOwnerString)
    if myDynFile.CreateFromSQL(pSQLStatement) <> 0
      ! there was a problem
    else 
      myFile &= myDynFile.GetFileRef()
      myBuffer &= myFile{PROP:Record}
      buffer(myFile, 200)
      loop
        next(myFile)
        if errorcode()
          break
        end   
        ! do stuff here
      end 
    end