SQL command syntax

Can you describe the librarybook table?

Ensure you have a BookTitle column in librarybook  table.

ok now it looks like this:
dmoLibrary.sdsBook.CommandText := 'SELECT * from librarybook '+
                                    'WHERE BookCategory = '+ QuotedStr('Fantasy')+
                                    ' ORDER BY Book Title';

I had a look at the table and it is named "Book Title" 2 words. But now I still get an error:
First chance exception at $7542C41F. Exception class TDBXError with message
'Token unknown - line 1, char 71
Title'.

try putting double quotes around the column name in the ORDER BY clause:

dmoLibrary.sdsBook.CommandText := 'SELECT * from librarybook '+
                                    'WHERE BookCategory = '+ QuotedStr('Fantasy')+
                                    ' ORDER BY "Book Title"';

alternatively instead of using * in the select statement for the columns to retrieve specify the columns and use an alias for the column Book Title so there is no space in the name.

eg:

dmoLibrary.sdsBook.CommandText := 'SELECT BookId, BookCategory, Book Title as BookTitle from librarybook '+
                                    'WHERE BookCategory = '+ QuotedStr('Fantasy')+
                                    ' ORDER BY BookTitle';

Both would have been required.

solved the problem