Questions tagged [visual-foxpro]
Visual FoxPro is a data-centric, object-oriented, procedural, programming language produced by Microsoft.
9
questions
0
votes
1answer
25 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
1answer
27 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 ...
2
votes
1answer
49 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(...
1
vote
3answers
53k 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", "...
1
vote
0answers
148 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 ...
1
vote
0answers
1k 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
vote
0answers
88 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 ...
2
votes
0answers
323 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 ...
1
vote
1answer
288 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 ...
