Delete Record - Valentina / RunRev

[Ruslan Zasukhin]

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]