BorlandTalk.com

John F. · Guest

Anyone have an idea why this doesn't work using Local SQL on Paradox
tables?

no rows are returned but it should return one row.

Select P.* From MyAppAlias.Patient P, "C:Backup3-09Patient" BP
Where P.TimeStampKey = BP.TimeStampKey

Both paradox tables have a field named TimeStampKey of type TimeStamp.

Here is my test data in both tables;

Select TimeStampKey from MyAppAlias.Patient Where Pat_Id = 493

Returned one row: 9/7/2003 12:46:31 PM

Select TimeStampKey From "C:Backup3-09Patient" Where Pat_Id = 1172

Returned one row: 9/7/2003 12:46:31 PM

Thanks in advance...