Record ID Problem

Michael Krugman admin at ktinet.net
Mon Nov 24 18:27:58 CST 2003


Hi Keith:

Thanks for the help...it worked, sort of...now when I add the new 
record, the record that is displayed is the first record in the table.  
Any ideas there?

Mike
On Nov 24, 2003, at 6:17 PM, Keith DeLong wrote:

> Hi Mike,
> Since it is not an actual field in your table, you need to ask for the 
> RecID
> explicitly in in your select statement.
>
>>  Can someone take a look at this and give me an
>> idea of how to display Valentina's record ID?
>
>>  // Get the specific record into a DatabaseCursor
>>  curs = myDataBase.SQLSelect("SELECT  * FROM Clients WHERE ID =" +
>> str(ID))
>
> Change the above to:
>
> curs = myDataBase.SQLSelect("SELECT  RECID,* FROM Clients WHERE ID =" +
> str(ID))
>
>
> HTH,
>
> Keith DeLong
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



More information about the Valentina mailing list