Dialog problems

cinnamoncinnamon
edited 4:43PM in Open Query Builder
Hi,
I am very new to FR, in fact I am a 4 Hour old user.
I have succesfully craeted a report accessing data from my Interbase database.

I have added a From Date and To Date selection where I want the data viewed in my report to range from & include the From Date as selected up to and including the To Date as selected.

I would also like the "DateEdit control" to default to the date of the day and not stick to the date that I designed the report on.

Any suggestions for a SQL query?

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 4:43PM
    in the onactivate event of the dialogform set dateedit date := now or date
    paramaterize your query's sql statement
    use 2 params
    where fieldname >= :p1 and fieldname <= :p2
    in the params editor set the type and in the value add the dateedit controls name
    ie dateedit1.date

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • Open Query BuilderComment As ...

© Vanilla Keystone Theme 2024