Query in Valentina Studio pro

[Ruslan Zasukhin]

On 8/4/12 4:05 PM, "roy" <roy at assistent.no> wrote:

Hi Roy,

> hi
> 
> i try to make a query with parameters. i have a databese with customers with
> clientnumber. i wil have a query that select all my customer with
> clientnumber 1.
> 
> i try
> 
> SELECT Customer.FirstName, Customer.LastName, Customer.CompanyName,
> Customer.Address, Customer.ZipCode, Customer.City, Customer.Phone,
> Customer.PaymentCode
> FROM
> 
>     Customer
>     where Customer.Client =  $P(Param1)
> 
> when i make a parametermname  clientId it get changed to param1
> 
> how do i make a call to a query with a parameter

Have you see this videos?

<http://www.valentina-db.com/dokuwiki5/doku.php?id=valentina:video:vspro:vsp
ro>


Check here sub-reports video


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]