Problem with cursor
Erik Mueller-Harder
valentina-list at vermontsoftworks.com
Sat Sep 25 19:08:37 CDT 2004
Hi, Michael --
On Sep 25, 2004, at 18:27, Michael Bierly wrote:
> curData = mDb.SqlSelect("Select LibraryName, LibrarySize,
> RankInAsp From LibrariesBuild Where Asp = " +
> Trim(curAsp.Field(1).GetString) + " Order By LibrarySize Desc" ,
> kV_Client,kV_ReadWrite, kV_Indexed)
Looks like you're missing single quotes around the literal in your
where clause. Try:
... where Asp ='" + trim(curAsp.Field(1).GetString) + "' order by ...
HTH,
-- Erik
More information about the Valentina
mailing list