After looking for a driver to open legacy dbf drivers to connect, the next level trouble a have is this one:
first, i can retrieve the data but when trying to filter by a parameter (somesc columns) i get an error.
The error says about the database can't determine some blah blah!
The error is a columm tha is formated ( 1234 ) about 8 space, fixed. The values in the query appears like that. I resolve this by Trimming Ltrim(ColumnName) and i get this (1234).
Now in SqlExpress, how can i filter by the new Trimmed Expression? (This is a primary key that the DBF use)
SELECT column1, column2, column3
SELECT Ltrim(column1) as NewExp, column2, column3
Where NewExpre = @NewExpres -Error-
View Complete Post