Delete Record - Valentina / RunRev

[Warren Kuhl]

Ruslan,

Thanks....stupid mistake on my part.  Your example provided works as
expected.

Thanks for your help!
Warren

On Sun, Nov 21, 2010 at 2:33 AM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 11/20/10 11:57 PM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:
>
> Hi Warren,
>
> You write not correct here.
>
> If you want to use SQL command
>            " Delete FROM Favorites where KeywordF = xxx "
>
> Then you should use
>        VDatabase_SqlExecute( dbRef, commandStr )
>
>
>
>
>
> > I am trying to delete a record and am getting the following "Wrong ref
> for
> > tblRef' in my log.  What is this telling me as the same table works as a
> > select a few lines down in the log.
> >
> > Here is my delete statement:
> >
> > put Vtable_DeleteRecord(fDatabase,"Delete FROM Favorites where KeywordF =
> '" &
> > tLine & "'")
> > get vDatabase_Flush(fDatabase)
> >
> > My log....
> >
> > VTable_DeleteRecord...
> >  PARAM: tblRef = "53415400"
> > ERROR: Wrong ref for "tblRef"
> > return None
>
> Right, because
>
> Vtable_DeleteRecord()  requires as first parameter
>    not dbRef but tblRef.
>
>
>
> > VDatabase_Flush...
> >  PARAM: dbRef = "53415400"
> > return
> >
> > VDatabase_SqlSelect...
> >  PARAM: dbRef = "53415400"
> >  PARAM: inStrQuery = "SELECT Termf FROM Favorites where KeywordF =
> 'test2j'
> > Order by TermF"
> > return res = 53415512
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20101121/f63bcc4b/attachment.htm>