General information
Title:
Problem retrieving data from 2.5 dbf with codepage 866
I have to retrieve some data from tables with structure like:
Table 1
Id C(2) - key field
Name C(20)
Table 2
Id C(2) - foreign key
SomeData C(20)
Fields Id contain binary data and tables are marked with code page 866. I open this tables in VFP 2.5 with current codepage 1251.
Now I can find records in table 2 corresponding to any record in table 1 only if I perfom SET NOCPTRANS TO Id. But this statement cannot help me when I try to do, for example:
SELECT SomeData FROM Table1, Table2 WHERE Table1.Id = Table2.Id AND Table1.Name = "A"
(searched record has Id = CHR(18)+CHR(186))
I think VFP opens again tables participating in SELECT so perfomed SET NOCPTRANS has no effect.
How to do this task?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only