2. ASPRunnerPro General questions
  3. Query Designer Page
This topic is locked

Query Designer Page

 		11/16/2009 8:17:50 AM
ASPRunnerPro General questions
E
 erdinoxyz author

I want use if then else in Query Designer Page.

This possible. What I do?

(For example;

if SalesDate<Date then

SalesUnit=0

Else

SalesUnit=SalesUnit

End if)

This code I want Possible Where?

Thanks.
Sergey Kornilov admin 11/16/2009

What database do you use?
To be on the safe side I'd create a view/query in your database using If/Then/Else and then use this view as a datasource in ASPRunnerPro.
E
 		erdinoxyz author 11/17/2009



What database do you use?
To be on the safe side I'd create a view/query in your database using If/Then/Else and then use this view as a datasource in ASPRunnerPro.


I want use (MS Access mdb database.)
J
 		Jane 11/17/2009

Hi,
I recommend you to use Custom format for SalesUnit field on the "View as" settings dialog on the Visual Editor tab:

http://www.xlinesoft.com/asprunnerpro/docs/_view_as__settings_custom.htm
E
 		erdinoxyz author 11/19/2009



Hi,
I recommend you to use Custom format for SalesUnit field on the "View as" settings dialog on the Visual Editor tab:

http://www.xlinesoft.com/asprunnerpro/docs/_view_as__settings_custom.htm


Very Thanks.