<div>Ruslan,</div>
<div> </div>
<div>Thanks....stupid mistake on my part. Your example provided works as expected.</div>
<div> </div>
<div>Thanks for your help!</div>
<div>Warren<br><br></div>
<div class="gmail_quote">On Sun, Nov 21, 2010 at 2:33 AM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com">ruslan_zasukhin@valentina-db.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">On 11/20/10 11:57 PM, "Warren Kuhl" <<a href="mailto:warrenkuhl@gmail.com">warrenkuhl@gmail.com</a>> wrote:<br>
<br>Hi Warren,<br><br>You write not correct here.<br><br>If you want to use SQL command<br> " Delete FROM Favorites where KeywordF = xxx "<br><br>Then you should use<br> VDatabase_SqlExecute( dbRef, commandStr )<br>
<div class="im"><br><br><br><br><br>> I am trying to delete a record and am getting the following "Wrong ref for<br>> tblRef' in my log. What is this telling me as the same table works as a<br>> select a few lines down in the log.<br>
> <br>> Here is my delete statement:<br>> <br>> put Vtable_DeleteRecord(fDatabase,"Delete FROM Favorites where KeywordF = '" &<br>> tLine & "'")<br>> get vDatabase_Flush(fDatabase)<br>
><br>> My log....<br>><br>> VTable_DeleteRecord...<br>> PARAM: tblRef = "53415400"<br>> ERROR: Wrong ref for "tblRef"<br>> return None<br><br></div>Right, because<br><br>Vtable_DeleteRecord() requires as first parameter<br>
not dbRef but tblRef.<br>
<div class="im"><br><br><br>> VDatabase_Flush...<br>> PARAM: dbRef = "53415400"<br>> return<br>><br>> VDatabase_SqlSelect...<br>> PARAM: dbRef = "53415400"<br>> PARAM: inStrQuery = "SELECT Termf FROM Favorites where KeywordF = 'test2j'<br>
> Order by TermF"<br>> return res = 53415512<br><br></div>--<br>Best regards,<br><br>Ruslan Zasukhin<br>VP Engineering and New Technology<br>Paradigma Software, Inc<br><br>Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com/" target="_blank">http://www.paradigmasoft.com</a><br><br>[I feel the need: the need for speed]<br><br><br>_______________________________________________<br>Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">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>
</blockquote></div><br>