CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 SQL Statement

Print topic Send  topic

Author Message
Graham Pearson
Posted: 06/28/2004, 6:30 PM

When creating a Grid Builder, I am trying to create an SQL Statement
with IN, Is their any way to modify the Conditions select box to
include the IN so if I happen to have a list of values it would
create a query from the values.





---

Graham Pearson, System Administrator / Web Developer

Northern Indiana Educational Services Center

56535 Magnetic Drive, Mishawaka IN 46544

http://www.niesc.k12.in.us
Graham Pearson
Posted: 06/29/2004, 4:17 PM

6/28/2004 8:30:10 PM

Graham Pearson <gpearson@niesc.k12.in.us> wrote in message

cbqgmq$qcc$1@news.codecharge.com



Solved this one by changing the where clause from parameter to
expression and adding in the IN (#Variable.Expression#)





> When creating a Grid Builder, I am trying to create an SQL
Statement

> with IN, Is their any way to modify the Conditions select box to

> include the IN so if I happen to have a list of values it would

> create a query from the values.

>

>

>

>

>

> ---

>

> Graham Pearson, System Administrator / Web Developer

>

> Northern Indiana Educational Services Center

>

> 56535 Magnetic Drive, Mishawaka IN 46544

>

> http://www.niesc.k12.in.us

---

Graham Pearson, System Administrator / Web Developer

Northern Indiana Educational Services Center

56535 Magnetic Drive, Mishawaka IN 46544

http://www.niesc.k12.in.us

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.