Good morning,
Using SPT from VFP 9 I need to retrieve a bunch of records from a table in SQL Server. The know information is a key field values for each of the records. So I am thinking of building an expressing that will use INLIST() as following:
cSqlCommand = "select * from mytable where
inlist( keyfldname, 'val1', 'val2', 'val3 )"
I have 2 questions:
1. VFP help says that the number of INLIST expressions can be up to 25. Is this the same in SQL Server?
2. In VFP INLIST() is Rushmore optimized. Is this the same in SQL Server (if index on KEYFLDNAME exist)?
Thank you in advance for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham