Implementing find mode in a form

[Former Member]

How is find mode implemented in a form?

It's easy enough to have the form mode set to et_FIND_MODE, allow input, and catch the event for when the find button is pressed. Then what do you do?

DBDataSource.Query(condition) doesn't seem usable since there's no way I see to implement a "like" condition for when the user enters something like "abc*" in one of the search fields.

Does this type of functionality require using a recordset and DoQuery and building your DBDataSource collection from the recordset by going through each result in the recordset? That's the only way I can see to do it from what I know at this point.

Any assistance is much appreciated!

Bill Faulk

[Former Member · Accepted solution]

You can implement a "Like" condition using a DBDataSource

for example you want CardCode LIKE 'abc*'

this would be

dsa_Conditions = New SAPbouiCOM.Conditions
 
dsa_Condition = dsa_Conditions.Add
dsa_Condition.BracketOpenNum = 2
dsa_Condition.Alias = "CardCode"
dsa_Condition.Operation = BoConditionOperation.co_GRATER_EQUAL
dsa_Condition.CondVal = "abc"
dsa_Condition.BracketCloseNum = 1
dsa_Condition.Relationship=BoConditionRelationship.cr_AND
dsa_Condition = dsa_Conditions.Add
dsa_Condition.BracketOpenNum = 1
dsa_Condition.Alias = "CardCode"
dsa_Condition.Operation = BoConditionOperation.co_LESS_THAN
dsa_Condition.CondVal = "abd"
dsa_Condition.BracketCloseNum = 2

[Former Member · Accepted solution]

Sébastien, thanks for the reply.

Unfortunately, the user can always put in "abc" or "*abc", and so on, so querying for a recordset and building the dbdatasource object from this seems the way to go. Also, there can be a separate condition for each field the user can enter in find mode which makes for lots and lots of coding.

It'd be nice if there was an alternate version of DBDataSource.Query() which let you just specify a string for the where clause.

Also, I've found that for "flat" forms the thing to do seems to be to build the result set and use a data browser so that the matching records can be navigated with the buttons. In this case I think you have to use a recordset anyway.

[AlexGrebennikov · Accepted solution]

Hi, Bill!

>>It'd be nice if there was an alternate version of

>>DBDataSource.Query() which let you just specify a

>>string for the where clause.

It would be a best solution for your issue, and i've resently read a message, where Frank saying that this feature is planned for v.2005

I suppose there is only one solution for now: it is using of DI-RecordSet to run a codegenerated query to find appropriate records..