Problem with cursor

[Michael Bierly]

Erik,

Asp is a numeric field but just to check everything, I tried your 
suggestion. Still no luck.

Mike

On Sep 25, 2004, at 7:08 PM, Erik Mueller-Harder wrote:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>