Recent content by mike1reynolds

My last problem turned out to be an index problem w/ Pervasive.SQL. One table is imported from a spreadsheet while the other is linked from SQL, so I figured I could just add my own indexes to the imported spreadsheet and reverse the order of the INNER JOIN, but this query never returns too...

The following query never returns, even though there is an index on the name field in the Patient table: SELECT p.Name FROM sheet4 AS s INNER JOIN Patient AS p ON p.NAME LIKE s.LASTNAME + ', ' + s.FIRSTNAME + ' %'

This query works: SELECT p.AcntNumber, p.Name, d.FromDate FROM Daysheet AS d INNER JOIN Patient AS p ON d.AcntNumber=p.AcntNumber But this does not: SELECT p.AcntNumber, p.Name, d.FromDate, c.CPT FROM Daysheet AS d INNER JOIN Patient AS p ON d.AcntNumber=p.AcntNumber INNER JOIN Charge AS c ON...

I'm using Pervasive SQL, not Microsoft and they don't have DTS. Thanks Moniker!!

When I load a spreadsheet I can't add an index because it is a linked table, so I want to save it in MDB format so that I can add an index and then export it to SQL. However, when I save the file as an MDB file the data is all still linked as a spreadsheet and I still can't add an index. (I...