SELECT FROM Db

[Liam Lambert]

Hello everyone
what am I doing wrong with this script
I have used similar code that worked but this does not

  global gConID
   local tBookingID
   set itemDel to tab
   put fld "id"  into tName

   put "SELECT  (Surname) FROM Booking where FirstName = 'tName'"  
into tFname
   put revdb_querylist(,,gConID,tFname) into tName
   put tName into fld "surName"

Thanks
Liam

IRELAND
liamlambert at mac.com