Query works in foxpro not in .net
- From: Peter Proost <pproost@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 31 Jan 2008 16:52:29 +0100
Hi group, I've got following problem:
If I run this query in visual foxpro it returns one row:
select provo.artco, provo.code, provo.o_lsta, provo.o_vp1, provo.voorraad, klakort.korting from provo inner join klakort on provo.o_groep = klakort.groep inner join klant on klakort.klant = klant.kode where artco = '00100.1035' and klant = '0000067'
if I run the same query like this in vb.net it runs fine (no errors) but it returns 0 rows. Any tips are welcome.
Dim con As New OleDbConnection("Provider=vfpoledb.1;Data " & _ "Source=\\server\dbf\;Mode=Share Deny" &_
"None;Collating Sequence=general")
Dim cm As New OleDbCommand("select provo.artco, provo.code, provo.o_lsta, provo.o_vp1, provo.voorraad, klakort.korting from provo inner join klakort on AllTrim(provo.o_groep) = AllTrim(klakort.groep) inner join klant on AllTrim(klakort.klant) = AllTrim(klant.kode) where artco = '00100.1035' and klant = '0000067'", con)
Dim da As New OleDbDataAdapter(cm)
Dim ds As New DataSet
Try
con.Open()
da.Fill(ds)
con.Close()
Catch ex As Exception
End Try
Best regards,
Peter
.
- Prev by Date: Re: Multiple DB sessions and tcp ports limitation
- Previous by thread: Re: Multiple DB sessions and tcp ports limitation
- Index(es):
Relevant Pages
|
|
