FiveTech Support Forums

HI,

This code sometimes work ok, sometimes produce error:
Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: MOVEFIRST

try
   oRs := TOleAuto():New( 'ADODB.RecordSet' )
   WITH OBJECT oRs
      :ActiveConnection := oCn
      :Source           := 'SELECT * from mytable'
      :CursorLocation   := 3  
      :Open()
   END
catch oErr
   FW_ShowAdoError(oCn)
   return .f.
end try

oRs:MoveFirst()
.
.
.

oRs:Close()
oCn:Close()

After few days i have seen that it is huppaning when table is empty

Is that mean that we must always control oRs:RecordCount ????
Is that standard ADO behavior or therw is some other solution ?

Second case
IF :Source is not SELECT statement for example
:Source := 'SET PDQPRIORITY 95'
than oRs:State = 0 and all Methods produce error ...
Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: CLOSE
Question: IS sql statement executed ?
IS that mean thet in this cases it is not need of closing recordset ?
Must control oRs:State in any cases ?

In this case CATCH oErr dont report error ...

ONE MORE Qusetion.
If SQL statement is executed ... is server returning message what is maded ?
Something like "100 Records inserted"
If yes how can i get that message ?
IS there some function like FW_ShowAdoResult(oCn) ?

Best Regards,

cSql := "UPDATE ......" or "INSERT INTO ..."

oCn:Execute( cSql, @nRows, adCmdText )
? nRows

Marc, Rao

Thanks for reply

Regards,