Summary:

Resolution: If you fix Accessing Fields From a DAO Recordset error in time, your PC will run like brand new. In order to fix your errors and speed up PC, it is recommended that your download the 'Accessing Fields From a DAO Recordset Repair Tool'. This is definitely your ideal tool to solve Accessing Fields From a DAO Recordset problem in the shortest time.

Download the Accessing Fields From a DAO Recordset repair tool

In order to repair Accessing Fields From a DAO Recordset issue, install SmartPCFixer immediately. This system optimizer software is already proven to locate, identify, and remove Accessing Fields From a DAO Recordset errors. Your computer should run faster and smoother after using this software.


Method for Advanced Users

Issue

How to use the DAO COM object from Dexterity sanScript to retrieve values from a DAO recordset?

Resolution

The following sample code uses a DSN to connect to Access database.
It then retrieves the
two fields/columns for every row and displays them to the screen.
The Data Access Objects (DAO)
library was marked in the Libraries section in Dexterity.
The table is named MyTable and there are
two columns of type string in the table; ID and Name.
The connection string and information would be different if you are connecting to a different kind of database,
however the methods used to access table/column information would be the same.

local DAO.Workspace wrkJetWrkSpc;
local DAO.Database dbConnect;
local DAO.DBEngine dbengine;
local DAO.Recordset RcrdSt;
local text SQLStr;

=== SQL STRING USED ONCE CONNECT TO DB ===
SQLStr = "select * from myTable";

try === CREATE AND OPEN CONNECTION ===
dbengine=new DAO.DBEngine();

wrkJetWrkSpc = dbengine.CreateWorkspace("NewODBCWorkspace", "", "", DAO.dbUseODBC);
dbConnect = wrkJetWrkSpc.OpenDatabase("Test", DAO.dbDriverComplete, false, "ODBC;DSN=AccessDB");

RcrdSt = dbConnect.OpenRecordset(SQLStr, DAO.dbOpenDynamic, DAO.dbExecDirect, DAO.dbOptimistic);

RcrdSt.MoveFirst();
while not RcrdSt.EOF do

can access the field by name or position
warning str(RcrdSt.Fields[].Item["ID"].Value) + " " + str(RcrdSt.Fields[].Item[1].Value);

RcrdSt.MoveNext();

end while;
else
throw;
end try;

This article was TechKnowledge Document ID:
29828

What Else Does SmartPCFixer Offer You?

Apart from fixing Accessing Fields From a DAO Recordset problems, SmartPCFixer is designed to provide the user's computer system with better optimization, which helps you manage startup items, desktop, browser objects, Internet, system service, Windows optimization, file extensions and so on. With these sophisticated utilities your system is tuned up to run at the optimal state.

SmartPCFixer provides you with Registry Backup, System Backup, Favorites Backup and Folder Backup. In addition, the new built-in function of Restore Point enables you to create a system store point so you can recover your system to a previous state if you do not like the changes you have made. This ensures the safety of your system when you run the registry repair process.



Related: Updating Windows,Updates Microsoft,Google Error 403,Delete Cookies Mac,Downloads Directx
Read More: ,Microsoft Agent 0x80040154,vpn error 429,no sound after windows 10 upgrade,http get adobe flash player,error messages