|
Home > Archive > FoxPro Help and Support > October 2005 > Differences in Table Indexes between FoxPro & SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Differences in Table Indexes between FoxPro & SQL
|
|
|
| On a VFP table you could create an index that consisted of an expression.
For example, I have an index that looks like
this... DTOS(DateFieldName)+
ALLTRIM(SocialSecuri
tyNumFieldName)
In SQL Server however, indexes can only exist essentially on a column name.
In SQL Server it's not possible to use an expression as an index.
So my question is, when you need to upgrade a VFP table containing
expression indexes to SQL Server, how do you accomodate the expression
indexes in SQL Server? I'm sure I could simply use a SQL table column that
contains a formula to essentially calculate the expression for each row, but
this seems too taxing.
| |
|
|
|
|
|