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