Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change A View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01297152
Message ID:
01297418
Views:
18
Any reason why this wouldn't work?
*****************************************************************
* Make a change to a table for testing purposes
*****************************************************************

CLOSE DATABASES ALL
OPEN DATABASE y:\vtc\data\vl_bill.dbc

SELECT 0
USE vl_Bill!CustMast EXCLUSIVE

ALTER TABLE CustMast;
	ADD COLUMN Test123 N(10)
	


*****************************************************************
* Update the view.
* I copied the SQL from the original view and appened it after
* the CREATE SQL VIEW command
*****************************************************************

IF INDBC("v_custmast", "view")
	DROP VIEW v_custmast
ENDIF

CREATE SQL VIEW v_CustMast AS;
	SELECT Custmast.*, Fuelssh1.fsh_pk AS fsh_pk1,;
	  Fuelssh1.fsh_code AS fsh_code1, Fuelssh2.fsh_pk AS fsh_pk2,;
	  Fuelssh2.fsh_code AS fsh_code2, Fuelssh3.fsh_pk AS fsh_pk3,;
	  Fuelssh3.fsh_code AS fsh_code3;
	 FROM ;
	     vl_bill!custmast ;
	    LEFT OUTER JOIN vl_bill!fuelssh Fuelssh1 ;
	   ON  Custmast.cmt_1fsh_fk = Fuelssh1.fsh_pk ;
	    LEFT OUTER JOIN vl_bill!fuelssh Fuelssh2 ;
	   ON  Custmast.cmt_2fsh_fk = Fuelssh2.fsh_pk ;
	    LEFT OUTER JOIN vl_bill!fuelssh Fuelssh3 ;
	   ON  Custmast.cmt_3fsh_fk = Fuelssh3.fsh_pk;
	 WHERE  Custmast.cmt_pk = ( ?lnCMT_PK )

RETURN
I then compared the new view in the DBC against an older copy. All of the DBSETPROP() commands appear the same,
with the exception of the
DBSETPROP(ThisView,"View","SendUpdates",.T.)
In the new view, it's set to False.

1) Will this work?

2) If so, how do I get the SendUpdates setting to set

3) ANy other issues I'm missing?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform