whereClause Blank Title 109700

Yahoo Archive
1
I tried the business logic tester: PartNum BEGINS "1"
It returned the records I expected to see.

I haven't tested BEGINS in a whereclause so I'm just guessing.
I suspect there is just something wrong with your systax
'" & ComboBox1.Text.Trim & "'", "Part.PartNum"

I often use variables for my whereclause.
It is easier for me to read and troubleshoot.

Something like this?
DIM sPartNum as String = ComboBox1.Text.Trim
whereclause = "PartNum BEGINS " & sPartNum


--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> Is there a way to use BEGINS in a where clause, I am trying this but it is not working...
>
> Thanks,
> Ted
>
> Dim _partData As DataSet = _boReader.GetList("Part", "Part.Company='100' AND Part.PartNum BEGINS '" & ComboBox1.Text.Trim & "'", "Part.PartNum")
>
2
Is there a way to use BEGINS in a where clause, I am trying this but it is not working...

Thanks,
Ted

Dim _partData As DataSet = _boReader.GetList("Part", "Part.Company='100' AND Part.PartNum BEGINS '" & ComboBox1.Text.Trim & "'", "Part.PartNum")