Hello

I want to run a parameterised query like:
"SELECT ...WHERE OrderDate BETWEEN DATE romDate AND DATE illDate AND
Type = ype"

1 What should be the value of the params.DataType of the dates parameters on
the TQuery?
2 How to assign a value to the dates parameters (on the right format)?
3.If the pType parameter doesn't have a value, I have to change the where
statement  or there is a better way?

Thanks Sorin

4th question

Where can I find some help about working with parameters on the ElevateDB
Manager?
I open the parameters list but there i'm stuck.

Thanks Sorin

Sorin

>1 What should be the value of the params.DataType of the dates parameters on
>the TQuery?

Without testing I'd guess string since that's what you would enter into a statement if you were typing it in full, and you'll probably need QuotedStr to make sure its got the quotes round it

>2 How to assign a value to the dates parameters (on the right format)?

Again a guess query.ParamByName('pFromDate').AsString := QuotedStr(Engine.DateToSQLStr(Date))

>3.If the pType parameter doesn't have a value, I have to change the where
>statement or there is a better way?

You'll have to change the WHERE clause. As it is you'll have a test "Type = NULL" which will cause an exception

Roy Lambert [Team Elevate]

Sorin

>Where can I find some help about working with parameters on the ElevateDB
>Manager?

Tim's brain

>I open the parameters list but there i'm stuck.

The steps are

1. prepare the query
2. click on the parameter tab if its not the current one
3. click on the parameter you want to set a value for
4. Look down at the bottom. There's a difficult to spot TEdit. Type your parameter in here (including any quotes needed)
5. Set the type using the drop down list to the right of the TEdit
6. Click the little button to the right of the type button and that sets the parameter value

Roy Lambert [Team Elevate]

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
> The steps are
>
> 1. prepare the query
> 2. click on the parameter tab if its not the current one
> 3. click on the parameter you want to set a value for
> 4. Look down at the bottom. There's a difficult to spot TEdit. Type your
> parameter in here (including any quotes needed)
> 5. Set the type using the drop down list to the right of the TEdit
> 6. Click the little button to the right of the type button and that sets
> the parameter value

Thanks for support Roy

Still something is missing.
I create a new.Sql.
Add the sql statement with the parameters.
Click on Prepare and this raise the #700 error on the first parameter
position.

Sorin

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message

> Without testing I'd guess string since that's what you would enter into a
> statement if you were typing it in full, and you'll probably need
> QuotedStr to make sure its got the quotes round it
>
>>2 How to assign a value to the dates parameters (on the right format)?
>
> Again a guess query.ParamByName('pFromDate').AsString :=
> QuotedStr(Engine.DateToSQLStr(Date))

I try with QuotedStr and without but on both cases it raise an error.
Looks like the parameter isn't replaced with the assingned value.

Thanks Sorin

Sorin

It is my understanding that the DATE predicate isn't required for parameterised queries. In my system, a query similar to yours, but without the  
"DATE", works just fine.

select * from Event where EventDate BETWEEN romDate AND illDate

Regards

Peter

Sorin,

> I want to run a parameterised query like:
> "SELECT ...WHERE OrderDate BETWEEN DATE romDate AND DATE illDate AND
> Type = ype"

sql.add('SELECT ...WHERE OrderDate BETWEEN romDate AND illDate');
ParamByName('pFromDate').asDate := MyFromDate;
ParamByName('pTillDate').asDate := MyTillDate;

Uli

Peter


You're dead right. I've learnt something else. Confusing isn't it

Roy Lambert

Sorin


In that case there's something wrong with the sql. Can you post the exact code you're using.

Roy Lambert [Team Elevate]