Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor adapter with 2 tables
Message
 
To
15/09/2008 11:36:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01347281
Message ID:
01347646
Views:
16
>Thanks Borislav. There must be something more cause I'm not getting a result cursor. Here is my code.
>
>text TO this.oCa.SelectCmd PRETEXT 15 NOSHOW
>     SELECT test_financing.keyID, Test_financing.tip_id, Test_financing.amount,
>            Test_financing.source, Test_financing._year, test_phases.phase
>            FROM \\tpdfiles\data\dfreeman\tip\data\TEST_FINANCING.DBF
>            left join test_phases on test_financing.tip_id = test_phases.tip_id
>            WHERE  Test_financing._year = ( ?m.lnYear )
>    ORDER BY Test_financing.tip_id
>endtext
>
What you get as error after CursorFill()?
IF  NOT this.oCa.CursorFill()
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform