>i can't create a view coz i am using free table in my progran.. :< .
Wrong. I am using FP2.6 tables in my current app with this code to create a view. The tables are from SBT accounting and not included in the dbc.
CREATE SQL VIEW "LV_CUST_all" ;
AS SELECT * FROM f:\pro30\ardata\arcust01 ;
where arcust01.type< '99'
*and arcust01.custno= ?vp_custno
DBSetProp('lv_cust_all', 'View', 'UpdateType', 1)
DBSetProp('lv_cust_all', 'View', 'WhereType', 3)
DBSetProp('lv_cust_all', 'View', 'FetchMemo', .T.)
DBSetProp('lv_cust_all', 'View', 'SendUpdates', .T.)
DBSetProp('lv_cust_all', 'View', 'UseMemoSize', 255)
DBSetProp('lv_cust_all', 'View', 'FetchSize', 100)
DBSetProp('lv_cust_all', 'View', 'MaxRecords', -1)
DBSetProp('lv_cust_all', 'View', 'Tables', 'arcust01')
DBSetProp('lv_cust_all', 'View', 'Prepared', .F.)
DBSetProp('lv_cust_all', 'View', 'CompareMemo', .T.)
DBSetProp('lv_cust_all', 'View', 'FetchAsNeeded', .T.)
DBSetProp('lv_cust_all', 'View', 'FetchSize', 100)
DBSetProp('lv_cust_all', 'View', 'Comment', "")
DBSetProp('lv_cust_all', 'View', 'BatchUpdateCount', 1)
DBSetProp('lv_cust_all', 'View', 'ShareConnection', .F.)
*!* Field Level Properties for lv_cust_all
* Props for the lv_cust_all.custno field.
DBSetProp('lv_cust_all.custno', 'Field', 'KeyField', .T.)
DBSetProp('lv_cust_all.custno', 'Field', 'Updatable', .F.)
DBSetProp('lv_cust_all.custno', 'Field', 'UpdateName', 'arcust01.custno')
DBSetProp('lv_cust_all.custno', 'Field', 'DataType', "C(6)")
all other fields are not displayed.
All I use is views inthsi app and I have over 200 defined in the system, and they keep growing at 10 per week. I'm only a third of the way done. I use parameters in "sub" views all the time so I may slice and dice the same table 6 ways.