main logo
Subject: Re: Table order
Author: Pamela Thalacker
Posted: 2002/10/21 13:53:58
 
View Entire Thread
New Search


<i><font color="#663300">Hi Mark,

I think what I was asking was/is is CB ok working with real tables not just the views that it says are really the way to go.</font></i>

A Codebook form or bizobj doesn't give a hoot what you use for data as long as it is available in a cursor in the current datasession.

<i><font color="#663300">at least some of the present company, imply that it (working with views not tables) is the most sensible way.</font></i>

Only if you want the data to be accessed by more than one concurrent user. If you are the only one accessing your data, there is no need.

However, if you need to share data, views make that extremely convenient. It is a built in data buffering system.

<i><font color="#663300">Having avoided them like the plague for some time now</font></i>

Why?

<i><font color="#663300">I'm trying to work my way out of the dark ages 8-)</font></i>

A view is only an SQL statement stored in the DBC with some properties that define if and how the data can be updated to the underlying table.

If you are making extensive use of SQL statements and just haven't bothered with views, then you aren't that far behind the curve. If you are not making use of SQL (available as long as I have used Fox) then you probably want to do some work and get yourself up to speed. It is a universal query language spoken across many platforms and a very useful tool for accessing data. It all depends on what your goals are.

Pamela
pamela AT eagle-crest .D.O.T com
 
©2002 Pamela Thalacker
<-- Prior Message New Search Next Message -->