<div>Seems like my database was corrupted which was causing the record lock issue. I cloned the DB and everything is okay now.</div><div><br></div><div>Warren</div><div><br></div><div><br></div><div> </div>
<div class="gmail_quote">On Sat, Feb 26, 2011 at 12:48 PM, Warren Kuhl <span dir="ltr"><<a href="mailto:warrenkuhl@gmail.com" target="_blank">warrenkuhl@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">I don't have my table/database open. But when I do a 'Select *' on my table in Valentina Studio...it keeps telling me record 1 is locked in my table.
<div><br></div>
<div><font color="#888888">Warren</font>
<div>
<div></div>
<div><br><br>
<div class="gmail_quote">On Sat, Feb 26, 2011 at 12:22 PM, Warren Kuhl <span dir="ltr"><<a href="mailto:warrenkuhl@gmail.com" target="_blank">warrenkuhl@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">Ivan,
<div><br></div>
<div>Thanks for the info on record locks. I will do my selects with out record locks. But now my problem is...if I have a record that is locked. How can I unlock it?</div>
<div><br></div>
<div><font color="#888888">Warren</font>
<div>
<div></div>
<div><br><br>
<div class="gmail_quote">On Sat, Feb 26, 2011 at 12:15 PM, Ivan Smahin <span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com" target="_blank">ivan_smahin@paradigmasoft.com</a>></span> wrote:<br>
<blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">
<div>
<div></div>
<div>On 2/26/2011 8:04 PM, Warren Kuhl wrote: </div></div>
<blockquote type="cite">
<div>
<div></div>
<div>I have a record lock in a table and am not sure how to get rid of is. Is there anything I can run on the Valentina database/table when opening my application to clear all record locks?
<div><br></div>
<div>Thanks,</div>
<div>Warren</div></div></div><pre><fieldset></fieldset>
_______________________________________________
Valentina mailing list
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a>
</pre></blockquote><a href="http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:vdatabase_class:sql_methods&s[]=lock" target="_blank">http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:api:vdatabase_class:sql_methods&s[]=lock</a><br>
<font color="#888888"><br><pre cols="72">--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
<a href="http://www.valentina-db.com/" target="_blank">http://www.valentina-db.com</a></pre></font></div><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br><br></blockquote></div><br></div></div></div></blockquote></div><br></div></div></div>
</blockquote></div><br>