DAO Query in VB.NET error
Posted on 2004-04-24
I'm using DAO in vb.NET (yes, i know ADO.NET exists i just don't know how to use it YET)...
Anyway... i have the following code...
dim dDB As Database
selectString="SELECT t1.[file path] & t1.[file name] AS [FileName & Path], t1.[file size], t2.[file size]
FROM FileSys1 AS t1 INNER JOIN FileSys2 AS t2 ON (t1.[file name]=t2.[file name]) AND (t1.[file path]=t2.[file path])AND ((t1.[file size]<>t2.[file size]));"
When i run this code, when it reaches the "dDB.Execute(selectString)" line it shows me the following error:
An unhandled exception of type 'System.NullReferenceException' occurred in simpledb.exe
Additional information: Object reference not set to an instance of an object.
Although when i copy and paste the SQL statement into an access query it works fine!
In vb.net i can successfully execute queries such as dDB.Execute("DELETE [Table1].*, * FROM Table1 ;")
How can i make my code work!