Whing Dela Cruz
asked on
adodc1
How to correct my code in ado RecordSource?
select s.proname as [Item Description], s.Procode as[Item Code], s.Quantity , um as [UOM], s.sellingprice as [Price 1],s.vndrid as [Supplier],pricea as [Price 2], priceb as [Price 3] from stock s inner join typediscount t on s.procode=t.proid order by s.vndrid='" text1.text & "'"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When i tried to run it to mssqlserver Query as this
select s.proname
as [Item Description], s.Procode as[Item Code], s.Quantity , um
as [UOM], s.sellingprice
as [Price 1],s.vndrid
as [Supplier],pricea
as [Price 2], priceb
as [Price 3]
from stock s
inner join typediscount t
on s.procode=t.proid
order by s.vndrid = & "text1.text" & ""
then an error says
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '='.
Can you correct this error?
Thanks!
select s.proname
as [Item Description], s.Procode as[Item Code], s.Quantity , um
as [UOM], s.sellingprice
as [Price 1],s.vndrid
as [Supplier],pricea
as [Price 2], priceb
as [Price 3]
from stock s
inner join typediscount t
on s.procode=t.proid
order by s.vndrid = & "text1.text" & ""
then an error says
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '='.
Can you correct this error?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi! You had given me correct answered! Thanks to you and more power..
Can you extend your help to my other posted question? I hope you will...
Can you extend your help to my other posted question? I hope you will...
ASKER