Questions tagged [visual-foxpro]

Visual FoxPro is a data-centric, object-oriented, procedural, programming language produced by Microsoft.

Filter by
Sorted by
Tagged with
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 ....
Eli's user avatar
  • 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 ...
Rk Itsolution's user avatar
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 ...
John's user avatar
  • 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(...
John's user avatar
  • 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", "...
John's user avatar
  • 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 ...
John's user avatar
  • 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 ...
leeand00's user avatar
  • 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 ...
leeand00's user avatar
  • 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 ...
Przemyslaw Wojda's user avatar
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 ...
leeand00's user avatar
  • 1,702