Query in Valentina Studio pro

[Ruslan Zasukhin]

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

Hi Roy,

Okay, then please note that $P()  is wrong here.
 it is for subreports


1) You need at first create report in Vstudio using some test db.
Do not think about parameters here.


2) in REALbasic, you can specify
  * absolutely other DB
  * and other query in the WHERE part ...

It is only important, that query in RB produce cursor with  the same fields
and the same names of fields.
 
You see?

So in RB you need male SQL string using string concatenation, which looks in
result as:


 SELECT Customer.FirstName, Customer.LastName, Customer.CompanyName,
 Customer.Address, Customer.ZipCode, Customer.City, Customer.Phone,
 Customer.PaymentCode
 FROM  Customer
 WHERE Customer.Client = 1


3) also make sure that you have check
           V4RB/Examples/Reports

They contain each 
  a)  .vsp file prepared in Vstudio
  b) RB projects that use it
       RB project generate some db for example ...


> yes i have seen that video, but t is not what i wont
> 
> I want to create a report of customers that I call up from the real basic
> program
> I want to send in client numbers from a parameter and get a report with only
> those clients
> 
> 
> roy
> 
> 
> -----Opprinnelig melding-----
> From: Ruslan Zasukhin
> Sent: Saturday, August 04, 2012 4:02 PM
> To: roy ; valentina at lists.macserve.net
> Subject: Re: Query in Valentina Studio pro
> 
> 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]