Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread detaill browser
Thu, Jul 31 2008 7:03 AMPermanent Link

"Norbert Stellberg"
Hello,

following problem:

I have:
A Table: Artikel
Table Fields: Kunden, Artikel

In this table are kunden and artikel:

Name1 123456789
Name1 177456788
Name1 223456789
Name1 223456777
Name2 123456789
Name2 123456788
Name2 223456789
Name2 223456777


A browser and a edit filed named Edit300

What I want is:

The kunde is Name1
Now I will see, which artikel has name1 ======> not a problem
Now I will see, which artikel has name1 with this number begin with 1
S := 'Name1';
DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL =
'+QuotedStr(Edit300.Text);
DBTable1.FilterOptions:=[];
DBTable1.Filtered:=True;

When I put in Edit300 a "1", the browser is empty. But I will see in Browser

123456789
173456788

Now the next in edit300 : "17"

Now I will see in the browser:
173456788

I have made some experiments with this
DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL =
'+QuotedStr(Edit300.Text);
DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL >=
'+QuotedStr(Edit300.Text);
DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL <=
'+QuotedStr(Edit300.Text);

But the result is not ok.
Can you help me ?

with best regards
Norbert
Thu, Jul 31 2008 7:33 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Norbert


Minor point - try to pick the right newsgroup to post to - this one is meant for attachments - I would suggest dbisam.general for this sort of question.

Assuming that Artikel is a string field, and Edit300 will always have the starting characters for Artikel rather than some in the middle or at the end then your best solution is

DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL LIKE ' + QuotedStr(Edit300.Text+'%');


Roy Lambert
Thu, Jul 31 2008 8:02 AMPermanent Link

"Norbert Stellberg"
Hello,

> Minor point - try to pick the right newsgroup to post to - this one is
> meant for attachments - I would suggest dbisam.general >for this sort of
> question.

Sorry, I meant this was the right group.

> DBTable1.Filter:='Kunde = '+QuotedStr(S)+'and ARTIKEL LIKE ' +
> QuotedStr(Edit300.Text+'%');

I am excite ! It's work very well.
Thank you very much.
with best regards
Norbert
Image