Advertisement

05.05.2008 at 02:07PM PDT, ID: 23377784
[x]
Attachment Details

Why doesn't this work with Rushmore?

Asked by jglapski in FoxPro Database, Microsoft Applications

Tags: Microsoft, Visual Foxpro, 9.0 SP2

I am trying to combine parts of a very large table, which can only be linked by record number.

It takes a long time, because of the size of the file, so I am attempting to ensure that it is Rushmore optimized. However, I am unsure of why the code snippet below does not work.

I don't have "not" or "for" in my index, so I am not sure why Rushmore doesn't work. Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:

sele *, recno() as rec from (m.inputfile1) into tabl tp1
inde on rec to rec
 
sele *, recno() as rec from (m.inputfile2) into tabl tp2
inde on rec to rec
 
?SYS(3054,11)
 
sele a.*, b.* from tp1 a, tp2 b wher a.rec=b.rec into curs tp_a
[+][-]05.05.2008 at 09:01PM PDT, ID: 21504681

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 04:26AM PDT, ID: 21506280

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 06:53AM PDT, ID: 21507273

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: FoxPro Database, Microsoft Applications
Tags: Microsoft, Visual Foxpro, 9.0 SP2
Sign Up Now!
Solution Provided By: ramrom
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.06.2008 at 03:07PM PDT, ID: 21511456

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 04:59PM PDT, ID: 21511952

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 03:11PM PDT, ID: 21628067

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628