Autosearch again

rbuser

I am a real newbie at this and I really don't have much sql experience.
I am using RB 5.56 attached to an advantage database. I designed a very
simple report that lists information on a client. After I had made the
report using the visual query tools, I text edited the sql file to make
a change I couldn't find out how to do any other way. The change worked
and my report was done and worked except for one problem. I lost the
initial user input to pick the customer the report was to be printed for.

I am now not able to use the visual query tools and I can't figure out
how to get the search input to work. I tried putting a variable on the
report but I don't know if this will work; or the proper syntax.

main table = Clients
Search Field = File Number (string)
I want it to be mandatory that data be entered when the report is first run.

Can I accomplish this? If so, Where do I enter the SQL language (
directly in the text, or in a variable) and lastly, what is the exact
syntax I use?

Thanks for anyone's help!!!!!

Keane

rbuser

Hi Keane,

please show us the current SQL expression. You should at least be able to change the expression at runtime as needed.

regards,
Chris Ueberall;

rbuser

Rather than list the whole SQL statement, I will give the first lines.
As you can see there is no mention of the autosearch function.


The statememnt goes on to define the rest of the fields which is the
same text as above then finishes with this:


Hope this helps! I was hoping to define a variable and put in a SQL line
in the calculation for the variable so the actual SQL statement stays
the same as above.

Keane

rbuser

Keane,

why would you need to edit the SQL expression as text?
From the given excerpt I don't see a reason to do so.

regards,
Chris Ueberall;

rbuser

Your right! I probably didn't need to, but I did! I was trying to put an
IF x then why statement in and I didn't realize I could have did that
using the visual tools. The change I made i took out but it was too late
to use the visual tools again so it deleted my auto search which brings
me back to either redoing the whole report format or adding the auto
search capabilities without using the Visual Tools. Remember, I am a
newbie who is learning fast back through mistakes. There was just
insufficient documentation with the product which came bundled with our
application.

Keane

rbuser

Keane,

then I would recreate the pipeline without editing the SQL expression. It's a matter of seconds.

HTH,
Chris Ueberall;

rbuser

And how do i do this?

keane

rbuser

Keane,

select the data page delete the existing pipeline a create a new one by calling 'File - New' from the menu (fundamentals, please take a look into manual 'RBuilder.pdf')

regards,
Chris Ueberall;

nardmoseley

Perhaps this example will help you...

http://www.digital-metaphors.com/tips/EditSQLAndSearch.zip


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com