Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: James Stewart
  Where is James Stewart?
 Christchurch
 New Zealand
 James Stewart
 Tags
Subject: DBSETPROP - updating info in Views
Thread ID: 21903 Message ID: 21903 # Views: 15 # Ratings: 0
Version: Visual FoxPro 5 Category: Databases, Tables and SQL Server
Date: Friday, April 04, 2003 2:40:46 AM         
   


Afternoon All!

I have been changing my DB from direct table accessing to views. Now i have 5 views that make the "client form". Can i use the DBSETPROP for each view/table one after the other like this:

DBSETPROP ('view1', 'View', 'Tables', 'table1')
DBSETPROP ('view2', 'View', 'Tables', 'table2')
DBSETPROP ('view3', 'View', 'Tables', 'table3')

DBSETPROP('view1.UID', 'Field', 'KeyField', .T.)
DBSETPROP('view2.BID', 'Field', 'KeyField', .T.)
*etc

Or do they need to be in order"

DBSETPROP ('view1', 'View', 'Tables', 'table1')
DBSETPROP('view1.UID', 'Field', 'KeyField', .T.)

DBSETPROP ('view2', 'View', 'Tables', 'table2')
DBSETPROP('view2.BID', 'Field', 'KeyField', .T.)
*etc



Thanks in advance. (from the newbie downunder.)
James
Have you been foxed today?
I have :-) !

COMPLETE THREAD

DBSETPROP - updating info in Views Posted by James Stewart @ 4/4/2003 2:40:46 AM
RE: DBSETPROP - updating info in Views Posted by Paul Brown @ 4/4/2003 11:59:32 AM
RE: DBSETPROP - updating info in Views Posted by James Stewart @ 4/14/2003 11:46:24 PM