Dear Thomas Budeism
What is your problem. Why write insulting me. What the hell is wrong
with you. Are you pompous because you feel you know everything about
Sqlite. When i first posted this e-mail i realised it was not concise
and i reposted, but thanks to those on the forum that understand and a
try using single ticks instead of quotes:Select Surname||',
'||First_Name||' ; '||Address as "Details" ...
This is the more correct(in SQL) way of specifying a string.
John
On 3/9/06, Clay Dowling <[EMAIL PROTECTED]> wrote:
>
> Roger said:
>
> > The reason i need a semicolon is because, i am cr
Roger said:
> The reason i need a semicolon is because, i am creating some queries for
> my reports and there are instances i concatenate some fields which i
> then seperate via a semicolon, but they occur in one line e.g. for the
> above query
>
> Smith, John ; South Africa
Roger,
Your best be
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 Surname||", "||First_Name||" ; "||Address as "Details
> >From Person
> where PersID=1098
The reason i
4 matches
Mail list logo