<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><font face="'PrimaSans BT,Verdana,sans-serif'">On 10/23/09 1:02 AM, "Charles Cohen" <<a href="mailto:rwc1717@shaw.ca">rwc1717@shaw.ca</a>> wrote:<br><br>> Other happenings..<br>> If I delete the database and run the application....it errs by not recognizing<br>> the preference table that I use when app.open code is executed...<br>> rsOpen = Nil<br>> rsOpen = mDb.SQLSelect("select * from Choices","EVCursorLocation.kClentside)<br><br>>>Wait a moment!<br><br>>>You use this cursor to add record?<br><br>>>ClientSide cursor is always READ ONLY.</font><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><font face="'PrimaSans BT,Verdana,sans-serif'">In this case I am only reading the cursor not adding a record in this case...</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'">I read this value and if there is nothing....I then open a Serverside cursor to Add the record to this table</font></div><div><font face="'PrimaSans BT,Verdana,sans-serif'">the 'create' database should have created the empty table...but as I said no tables exist in the new database<br><br>>>You need specify ServerSide<br><br><br>> vException is...on the SQLSelect<br>> it should have created an empty database...but throws the log error<br><br>> Table ( or view) is not found: sys_Diagrams<br><br>>>This was produced by Vstudio, not by your app<br><br>> Get View: No view with the name Equity.<br><br>>>This is probably your app<br><br>> The tables should have been made...the .vdb file exists but nothing in it.</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'">The above was just a test to see if I was creating a new database...and I am not...hence the error.</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'">Also....</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><span class="Apple-style-span" style="font-family: 'PrimaSans BT,Verdana,sans-serif'; ">This does not address the problem with being able to only update and remove existing records..</span></div><div><font face="'PrimaSans BT,Verdana,sans-serif'">when I use the existing database...as I said...no log errors...no exception...but no new record with Addrecord</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><font face="'PrimaSans BT,Verdana,sans-serif'">This is the same effect as when I try and add a new record to any table in the existing database.</font></div><div><font class="Apple-style-span" face="'PrimaSans BT,Verdana,sans-serif'"><br></font></div><div><font face="'PrimaSans BT,Verdana,sans-serif'">Thanks<br></font><div> <span class="Apple-style-span" style="font-size: 13px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Harry & Chuck</div><div><br></div></div></span><br class="Apple-interchange-newline"> </div><br></div></body></html>