Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Mike Yearwood
 To: Erik Hemler
  Where is Erik Hemler?
 Pennsylvania - United States
 Erik Hemler
Subject: RE: Cursorgetprop not working
Thread ID: 209849 Message ID: 209876 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 31, 2008 11:12:45 PM         

> I've created a view that consists of a main table and two other tables that are joined. The code i've used to create the view is
>                  FROM SIMS!PLANPRM ;
>                  ORDER BY PL_NAME"
> CREATE SQL VIEW ManualEditView AS &l_cSelect
> l_cTables = CURSORGETPROP("Tables","ManualEditView")
> l_cFieldList = CURSORGETPROP("UpdateNameList","ManualEditView")

> The view is working, but when I use the cursorgetprop("Tables") command, it's not returning all the tables included in the view. It's only returning the main table and the first join table. The second join table is not there. All of these table are in the same database.
> Also, the "UpdateNameList" property of Cursorgetprop is not working either. This returns the local field names and remote field table + names. It returns the correct values for the fields from the main table and the first joined table, but not the correct values for the field from the second joined table.
> Does anyone have any suggestions as to why this is happening?
> Thanks in advance,
> Erik

Hi Erik

1 - Use TEXT...ENDTEXT to construct your SQL. It's easier than concatenating and you can copy it right over to SQL Server or run it from the VFP command window.

2 - Those properties are set by us, not automagically by VFP. IMO, you're lucky you're getting anything.

3 - I find it infinitely easier to update one and only one tables from a view/spt at a time.

Mike Yearwood
Microsoft MVP Visual FoxPro 2008

We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.


Cursorgetprop not working Posted by Erik Hemler @ 12/31/2008 4:56:23 PM
RE: Cursorgetprop not working Posted by Mike Yearwood @ 12/31/2008 11:12:45 PM