Hello,
I'm trying to execute the following code in a (Windows CE 2.11) palm size device (with ADOCE installed)
Dim rs '-- Variable to hold Recordset object
Dim strSQL As String '-- SQL Statement to create new table
'-- Create RecordSet Object
Set rs = CreateObject("ADOCE.Recordset"
'-- Create SQL Statement to create new table
'-- The table has 2 columns -
'-- 1) "NAME" which is a text field
'-- 2) "AGE" which is an integer field
strSQL = "Create Table " & strTable
strSQL = strSQL & " (name text, age integer)"
'-- Execute SQL Statement to create table
rs.Open strSQL, , adOpenKeyset, adLockOptimistic
'-- Close Recordset
'rs.Close
'-- Remove object from memory
Set rs = Nothing
Note in this code, I had to remove "rs.Close" section as it caused "operation requested by the application is not allowed if the object is closed" error.
After I execute the code, it works correctly, i.e. it creates the table but I don't know where the table is created and stored! There's no file with ".mdp" or ".cdb" (equivalent of .mdp in Windows CE environment).
However, the table is stored because, when I try to create a table with the same name, it gives this error "Table 'sd' already exists" (After I have created a table with the name 'sd') That proves that the tables are really stored somewhere but I cannot find them.
Where could they be located? I'm really confused.
Thanks in advance.
I'm trying to execute the following code in a (Windows CE 2.11) palm size device (with ADOCE installed)
Dim rs '-- Variable to hold Recordset object
Dim strSQL As String '-- SQL Statement to create new table
'-- Create RecordSet Object
Set rs = CreateObject("ADOCE.Recordset"
'-- Create SQL Statement to create new table
'-- The table has 2 columns -
'-- 1) "NAME" which is a text field
'-- 2) "AGE" which is an integer field
strSQL = "Create Table " & strTable
strSQL = strSQL & " (name text, age integer)"
'-- Execute SQL Statement to create table
rs.Open strSQL, , adOpenKeyset, adLockOptimistic
'-- Close Recordset
'rs.Close
'-- Remove object from memory
Set rs = Nothing
Note in this code, I had to remove "rs.Close" section as it caused "operation requested by the application is not allowed if the object is closed" error.
After I execute the code, it works correctly, i.e. it creates the table but I don't know where the table is created and stored! There's no file with ".mdp" or ".cdb" (equivalent of .mdp in Windows CE environment).
However, the table is stored because, when I try to create a table with the same name, it gives this error "Table 'sd' already exists" (After I have created a table with the name 'sd') That proves that the tables are really stored somewhere but I cannot find them.
Where could they be located? I'm really confused.
Thanks in advance.