Questions tagged [visual-foxpro]
Visual FoxPro is a data-centric, object-oriented, procedural, programming language produced by Microsoft.
10
questions
0
votes
1
answer
300
views
Exporting FoxPro DBF Files
I am attempting to export data stored by a client's Visual FoxPro database to be used in a MySQL context. The data given is a folder of .dbf, .cdx, and .tbk files, as well as a few .dct, .dcx, and ....
- 101
0
votes
1
answer
156
views
How to combined table 2 value in table 1 whare id field is same?
Table 1
id | name | coupn |
-------+--------+------
PR001 | DC001 | 5
PR002 | DC001 | 5
PR003 | DC001 | 6
PR004 | DC002 | 7
PR005 | DC003 | 3
PR006 | DC003 | 11
...
0
votes
1
answer
30
views
Filtering One column into Different Columns in one statement
I need to
SELECT amount FROM table WHERE type='1' AND type='2' AND type'3'
Depending on the types, I need them to be pulled into different columns.
For example,
IF type=1 THEN amount1
IF type=2 ...
- 51
2
votes
1
answer
71
views
Replacing double digit numbers
I have column with numeric values that I need to replace into text values.
I used the sql statement:
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(...
- 51
2
votes
3
answers
91k
views
How do I REPLACE values in column after querying
I have a column with numeric values
I am querying
SELECT column
FROM table
WHERE column='1' OR
column='2' OR
column='3' OR
column='4'
THEN
REPLACE (column, "1", "ABC");
REPLACE (column, "2", "...
- 51
1
vote
0
answers
185
views
.DBC (FoxPro DBF) > FoxPro ODBC Driver > MIDDLEWARE > SaaS
I've been searching for Visual FoxPro ODBC Driver and finally found it. I am using a middleware to connect a .DBC (foxpro) > MIDDLEWARE > SaaS. I see from postings on MSDN that Microsoft suggests ...
- 51
1
vote
0
answers
2k
views
SQL Server Linked Server with Microsoft OLE DB Provider for Visual FoxPro?
We were having some issues with our old Microsoft Visual Fox Pro ODBC driver that we shoehorned into Windows 7 and is no longer supported by Microsoft and has not been for quite a long time...
So ...
- 1,702
1
vote
0
answers
98
views
Slow query speed using workstation processed joins with 100 Mbps connection speed?
In a department where they were complaining that a report was being run slowly, I jumped on one of the empty machines there and tried it out. It took a good 6 and 15 seconds to run.
Run from a ...
- 1,702
2
votes
0
answers
414
views
Import from dbf - collation
I select data from dbf files through OPENROWSET Visual FoxPro OLEDB.
Despite forcing collation on columns (e.g. SELECT name COLLATE Polish_CI_AS FROM Employees) the polish specific characters keep ...
- 303
1
vote
1
answer
299
views
Linked servers on SQL Server 2008 R2 through linked tables in MS-Access?
We have a really old data source (file-based) in Visual FoxPro, that we currently use via linked table through an ODBC data source. Recently, we started having an issue because the latest update to ...
- 1,702