Hi!
What is exact Select statement and a value of the public variable? The '=' sign works different ways in VFP based on the SET ANSI and SET EXACT settings inf VFP. I had situations in the past that 'contition=variable' is .. for all records just because variable was empty value.
HTH.
>Hello All,
>I need to get selective records in a combo with SQL rowsource type.
>I use a normal combo with a select statement and a WHERE condition = public memory variabe.
>This does not give give me the selective records but instead all.
>Any solutions?
>Thanks in advance.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.