Record will not delete

[Ruslan Zasukhin]

on 11/25/03 11:31 PM, Michael Krugman at admin at ktinet.net wrote:

> Hi Rusian:
> 
> I've tried it this way also...With the quote after recID= ", the SELECT
> statement thinks that this is all that is included.  +id,kServer and
> kReadWrite are no longer part of the statement, so I get the "there is
> no method or property with this name" error...

Michael,

Please understand that kServer and kReadWrite
    MUST NOT BE PART OF SQL string!!!

At first

    query = "SELECT recID,* FROM Customers WHERE recID = " + id

May be it must be in RB

    query = "SELECT recID,* FROM Customers WHERE recID=" + string(id)

The main is that you get SQL QUERY STRING as e.g.

    "SELECT recID,* FROM Customers WHERE recID = 5"



Then you simply call function with 3 parameters.
    
    curs = mDataBase.SQLSelect( query, kServer, kReadWrite )



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------