cancel
Showing results for 
Search instead for 
Did you mean: 

help use Markdown

ximen
Participant
0 Kudos
2,154

help use Markdown!thank

VolkerBarth
Contributor

Some hints as to what does not work for you would be worthwhile - otherwise your suggestion seems "too inconvenient", methinks...

ximen
Participant
0 Kudos

copy or input sql code too bad

VolkerBarth
Contributor
0 Kudos

Now I'd like to know whether the votes express the voters's opinion that

  • the Markdown behaviour is acceptable or even good or (1)
  • the tone and contents of this suggestion are not appropriate?

(1): I'll bet it's an OR here, not an XOR:)

Former Member

My opinion, that markdown isn't acceptable and needs to improve, but tone of this suggestion is not appropriate.

Accepted Solutions (0)

Answers (1)

Answers (1)

jack_schueler
Advisor
Advisor

I hope I understand what you are having trouble with.

For inputting SQL code, just copy / paste and then apply the little icon with the 101/010 on it to the code. And then you get something like this...

CREATE VIEW GROUPO.ViewSalesOrders
(ID,LineID,ProductID,Quantity,OrderDate,ShipDate,Region,SalesRepresentativeName)
AS
  SELECT i.ID,i.LineID,i.ProductID,i.Quantity,
         s.OrderDate,i.ShipDate,
         s.Region,e.GivenName||' '||e.Surname
    FROM GROUPO.SalesOrderItems AS i
        JOIN GROUPO.SalesOrders AS s
        JOIN GROUPO.Employees AS e
    WHERE s.ID=i.ID
        AND s.SalesRepresentative=e.EmployeeID;

That's all there is to it.

ximen
Participant
0 Kudos

thanks ! I think I will can you help me this question the web site was :http://sqlanywhere-forum.sap.com/questions/18168/how-i-can-use-of-recursive-query-results-help-thanks