Hello! Why do u need semicolon there? U can just give-- Select Name,Surname,' ',Address as Details from personm where persID = 1098
Think this works. -----Original Message----- From: Roger [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 12:01 AM To: [email protected] Subject: Re: [sqlite] File locking additions Hello guys. I have a small problem.I am trying to write some sql queries. Whenever i put a semicolon, sqlite returns an error immediately.for instance if i select as follows Select Name||" "||Surname||" ; "||Address as "Details >From Person where PersID=1098
