Problems with ms ado 2.8 in an win xp environment
iris2009
Member Posts: 56
Hello,
I have got the following problem. I am polling data from an access database. Nav Client is 6.2 Classic, installed on a Win xp machine.
Polling works fine, till you copy the correspondig codeunit from test database to the productive database. In this case you get the following, you get the following error message: "Assignment invalid. It is not possible to assign a _recordset to a recordset." (Orignial in german: "Ungültige Zuweisung. Es ist nicht möglich, ein _Recordset einer Recordset zuzuweisen."
When I delete the variables (recordset, etc.) and add them again, its working fine. But this is hardly a solution... Has anyone solved this??
Here is my code:
Name DataType Subtype Length
Field Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Field
Fields Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Fields
Connection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection
RecordsetFirst Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset
IF ISCLEAR(Connection) THEN CREATE(Connection);
Connection.Open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + RhewaSetup."Database File Name");
IF Weighingdata.FINDFIRST THEN REPEAT
IF (Weighingdata.Type = Weighingdata.Type::Einfach) AND (Weighingdata."Reg No Singleweighing" = 0) THEN BEGIN
RecordsetFirst := Connection.Execute('Select * from Erstwaegung where barcode = ' +
FORMAT(Weighingdata.Barcode));
IF NOT RecordsetFirst.EOF THEN BEGIN
Fields := RecordsetFirst.Fields;
I have got the following problem. I am polling data from an access database. Nav Client is 6.2 Classic, installed on a Win xp machine.
Polling works fine, till you copy the correspondig codeunit from test database to the productive database. In this case you get the following, you get the following error message: "Assignment invalid. It is not possible to assign a _recordset to a recordset." (Orignial in german: "Ungültige Zuweisung. Es ist nicht möglich, ein _Recordset einer Recordset zuzuweisen."
When I delete the variables (recordset, etc.) and add them again, its working fine. But this is hardly a solution... Has anyone solved this??
Here is my code:
Name DataType Subtype Length
Field Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Field
Fields Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Fields
Connection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection
RecordsetFirst Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset
IF ISCLEAR(Connection) THEN CREATE(Connection);
Connection.Open('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + RhewaSetup."Database File Name");
IF Weighingdata.FINDFIRST THEN REPEAT
IF (Weighingdata.Type = Weighingdata.Type::Einfach) AND (Weighingdata."Reg No Singleweighing" = 0) THEN BEGIN
RecordsetFirst := Connection.Execute('Select * from Erstwaegung where barcode = ' +
FORMAT(Weighingdata.Barcode));
IF NOT RecordsetFirst.EOF THEN BEGIN
Fields := RecordsetFirst.Fields;
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 329 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions