Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

powerbuilder SQL code question

Comment:

Ok - I'm trying to do a sort in powerbuilder 6.5. What I have is this situation....I am sorting by this field - let's just call it "priority" Presently "priority" can be set to H,M, or L (for high, medium, low - respectively). I need to sort by this field - but it sorts alphabetically - so it is not accurate. I'm trying to make an expression in powerbuilder SQL to set H=1 M=2 and L=3. I cannot seem to get it to work. What I have tried is: if(priority = 'H', 1, 'M', 2, 'L', 3, 4) --4 being if it isn't prioritized at all-- It gives me an error - the only way I can get it to work is if i do something like... if(priority = 'H', 1, 2) This assigns all others to the value "2" - How can i get this to work? Any help is appreciated very much - i'm new to powerbuilder!

using WSH to install prin...

Kylix

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Very Strange!! We'r currently using our own-written Powerbuilder application and using SQL Server. THe problem is when we load a report from the client PC(Win98), it loads very slow, it takes about 2...

Summary: I have a SQL database that I have designed. (I am using SQL 2000 Developers Edition) I know how to code the querries, but where in the webpge can I put that code? Do I have to specify what type of c...

Summary: I am looking at a MS SQL Server database that has some fields of type 'image'. I would like to find out how much data is in these fields. When I run a query, it appears to display only the first 255 ...