RE: [delphi-en] Query null field

2005-06-10 Thread CyberBug 

I use DBpipeline, so field data type is from DBase. If
the field is not NULL works, otherwise don't work.



--- Mike Lucek [EMAIL PROTECTED] wrote:

 Use the pipeline's fields editor to set your field
 data types.
 
 Mike
 
 -Original Message-
 From: delphi-en@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On Behalf
 Of cyberbugr3
 Sent: Friday, 10 June 2005 7:22 PM
 To: delphi-en@yahoogroups.com
 Subject: [delphi-en] Query null field
 
 Hi,
 
 I use Report Builder 9.01 and Delphi 6. 
 
 Some fields in Query type string are null, I would
 like to display
 these  fields, but Report Builder give me Could not
 convert variant
 of type(Null) into type(String)
 
 I try to convert fields before printing, but with no
 success.
 
 Can someone help me?
 
 
 
 
 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


-
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Re: [delphi-en] Problem in Report Builder TppReport component

2005-06-09 Thread CyberBug 

Hi,

 Try Query.close and than Query.open



--- Vahan Yoghoudjian [EMAIL PROTECTED] wrote:

 I have a TppReport (Report Builder component
 connected to a TDBPipeLine)
 that uses a query as a datasource. This query text
 is composed of 3 parts (2
 UNIONS) each one based on a certain condition
 provided by the user.
 Let's say
 
 if (checkbox1.checked) then
   // Set first part of the query text
 
 // Set main part of the query
 
 if (checkbox2.checked) then
   // Set third part of the query
 
 For info before setting each text other
 evaluations are done also to
 know if the UNION key word is to be used or now
 according to the
 combination.
 
 Now my problem is that, when I check the
 checkboxes and print the report
 everything works fine. I uncheck the first checkbox
 and reprint again. the
 report preview is displayed but empty. no page
 numbers are displayed. while
 tracing the query returns records, but the report is
 somehow unable to see
 it. On the preview form I have to click on 'next' or
 'previous' page so that
 the preview form positions itself on the first
 page... any similar problems
 with anyone? What do you think the reason is... I
 tried all possible methods
 to fix the problem but could not... like Loaded,
 Refresh,Query.First,
 Query.Next etc...
 
 
 Thanks in advance
 Vahan
 
 
 [Non-text portions of this message have been
 removed]
 
 




__ 
Discover Yahoo! 
Stay in touch with email, IM, photo sharing and more. Check it out! 
http://discover.yahoo.com/stayintouch.html


-
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/