error after restotration of nav db

smshyd
smshyd Member Posts: 72
edited 2012-11-15 in NAV/Navision Classic Client
Hi all
I am using Nav6.0sp1 and sql server 2005. we shifted the server to another system, It was working fine few hours then
giving error
This message is for C/AL programmers:

Invalid assignment. It is not possible to assign a _Recordset to a Recordset.
can any body tell me what may be the problem

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    That look like you are using some automation.
    Can you give some more info on what exactly does not work?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • smshyd
    smshyd Member Posts: 72
    very thanks for your response kirki,
    when I debug it, it is stoping in the below line
    ADORecordSet := ADOConnection.Execute(SQLString,RecordsAffected,RSOption);
  • kriki
    kriki Member, Moderator Posts: 9,121
    Check the subtype of variable ADORecordSet.

    You are using "Recordset" but need to use "_Recordset" which is strange because I am using the same code and it uses "Recordset".
    What library are your variables using?
    I have 'Microsoft ActiveX Data Objects 2.8 Library'.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • chi
    chi Member Posts: 17
    Hi smshyd
    I had the same error when running a report. After recompiling this object, it could be run without error. Have you tried recompiling the object contains the code occurring that error yet?
  • smshyd
    smshyd Member Posts: 72
    Hi chi,
    I compiled and uploaded the licence again. It is working fine.
    thank you kriki and chi for your suggestions

Categories