Hi
My child view is buffered to 5. The child table is PATLINE. The dbc is
PATHLAB. The code for the view is
Create SQL VIEW "LV_PATLINE" ;
AS SELECT * FROM pathlab!PATLINE WHERE PATLINE.PATID = ?LP_PATID
DBSetProp('LV_PATLINE', 'View', 'UpdateType', 1)
DBSetProp('LV_PATLINE', 'View', 'WhereType', 3)
DBSetProp('LV_PATLINE', 'View', 'FetchMemo', .T.)
DBSetProp('LV_PATLINE', 'View', 'SendUpdates', .T.)
DBSetProp('LV_PATLINE', 'View', 'UseMemoSize', 255)
DBSetProp('LV_PATLINE', 'View', 'FetchSize', 100)
DBSetProp('LV_PATLINE', 'View', 'MaxRecords', -1)
DBSetProp('LV_PATLINE', 'View', 'Tables', 'PATHLAB!PATLINE')
DBSetProp('LV_PATLINE', 'View', 'Prepared', .F.)
DBSetProp('LV_PATLINE', 'View', 'CompareMemo', .T.)
DBSetProp('LV_PATLINE', 'View', 'FetchAsNeeded', .F.)
DBSetProp('LV_PATLINE', 'View', 'FetchSize', 100)
DBSetProp('LV_PATLINE', 'View', 'ParameterList', "lp_patid,'I'")
DBSetProp('LV_PATLINE', 'View', 'Comment', "")
DBSetProp('LV_PATLINE', 'View', 'BatchUpdateCount', 1)
DBSetProp('LV_PATLINE', 'View', 'ShareConnection', .F.)
*!* Field Level Properties for LV_PATLINE
* Props for the LV_PATLINE.testno field.
DBSetProp('LV_PATLINE.testno', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.testno', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.testno', 'Field', 'UpdateName',
'pathlab!patline.testno')
DBSetProp('LV_PATLINE.testno', 'Field', 'Caption', "Test No.")
DBSetProp('LV_PATLINE.testno', 'Field', 'DataType', "C(4)")
* Props for the LV_PATLINE.testname field.
DBSetProp('LV_PATLINE.testname', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.testname', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.testname', 'Field', 'UpdateName',
'pathlab!patline.testname')
DBSetProp('LV_PATLINE.testname', 'Field', 'Caption', "Test Name")
DBSetProp('LV_PATLINE.testname', 'Field', 'DataType', "C(30)")
* Props for the LV_PATLINE.testrate field.
DBSetProp('LV_PATLINE.testrate', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.testrate', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.testrate', 'Field', 'UpdateName',
'pathlab!patline.testrate')
DBSetProp('LV_PATLINE.testrate', 'Field', 'Caption', "Rate")
DBSetProp('LV_PATLINE.testrate', 'Field', 'DataType', "N(10,2)")
* Props for the LV_PATLINE.trepdate field.
DBSetProp('LV_PATLINE.trepdate', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.trepdate', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.trepdate', 'Field', 'UpdateName',
'pathlab!PATLINE.trepdate')
DBSetProp('LV_PATLINE.trepdate', 'Field', 'DataType', "D")
* Props for the LV_PATLINE.treptime field.
DBSetProp('LV_PATLINE.treptime', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.treptime', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.treptime', 'Field', 'UpdateName',
'pathlab!patline.treptime')
DBSetProp('LV_PATLINE.treptime', 'Field', 'Caption', "Rep. Time")
DBSetProp('LV_PATLINE.treptime', 'Field', 'DataType', "C(8)")
* Props for the LV_PATLINE.trepmade field.
DBSetProp('LV_PATLINE.trepmade', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.trepmade', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.trepmade', 'Field', 'UpdateName',
'pathlab!patline.trepmade')
DBSetProp('LV_PATLINE.trepmade', 'Field', 'Caption', "Rep. Made")
DBSetProp('LV_PATLINE.trepmade', 'Field', 'DataType', "L")
* Props for the LV_PATLINE.patid field.
DBSetProp('LV_PATLINE.patid', 'Field', 'KeyField', .T.)
DBSetProp('LV_PATLINE.patid', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.patid', 'Field', 'UpdateName',
'pathlab!patline.patid')
DBSetProp('LV_PATLINE.patid', 'Field', 'Caption', "Bill No.")
DBSetProp('LV_PATLINE.patid', 'Field', 'DataType', "I")
* Props for the LV_PATLINE.tlineno field.
DBSetProp('LV_PATLINE.tlineno', 'Field', 'KeyField', .T.)
DBSetProp('LV_PATLINE.tlineno', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.tlineno', 'Field', 'UpdateName',
'pathlab!patline.tlineno')
DBSetProp('LV_PATLINE.tlineno', 'Field', 'Caption', "Line No.")
DBSetProp('LV_PATLINE.tlineno', 'Field', 'DataType', "N(2)")
* Props for the LV_PATLINE.repcoll field.
DBSetProp('LV_PATLINE.repcoll', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.repcoll', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.repcoll', 'Field', 'UpdateName',
'pathlab!patline.repcoll')
DBSetProp('LV_PATLINE.repcoll', 'Field', 'Caption', "Rep. Collected")
DBSetProp('LV_PATLINE.repcoll', 'Field', 'DataType', "L")
* Props for the LV_PATLINE.repcdate field.
DBSetProp('LV_PATLINE.repcdate', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.repcdate', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.repcdate', 'Field', 'UpdateName',
'pathlab!patline.repcdate')
DBSetProp('LV_PATLINE.repcdate', 'Field', 'Caption', "Report Collected
Date")
DBSetProp('LV_PATLINE.repcdate', 'Field', 'DataType', "D")
* Props for the LV_PATLINE.drcode field.
DBSetProp('LV_PATLINE.drcode', 'Field', 'KeyField', .F.)
DBSetProp('LV_PATLINE.drcode', 'Field', 'Updatable', .T.)
DBSetProp('LV_PATLINE.drcode', 'Field', 'UpdateName',
'pathlab!PATLINE.drcode')
DBSetProp('LV_PATLINE.drcode', 'Field', 'DataType', "C(4)")
Endfunc
Please let me know if there is any fundamental mistake.
Ajoy Khaund
Neamati Road
Near Bhogdoi Bridge
Jorhat 785 001
Assam, India
Tel: 91-376-2351288
Cell: 91-94350-92287
Mail: [EMAIL PROTECTED]
Mail: [EMAIL PROTECTED]
"Walking on water and developing software from a specification are easy if
both are frozen."
- Edward V. Berard, "Life-Cycle Approaches"
----- Original Message -----
From: "MB Software Solutions" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2007 9:43 PM
Subject: Re: VFP6 SP5 data not been updated from view
> Ajoy Khaund wrote:
>> Hi
>> I was not able to follow my own thread as my land line telephone was down
>> so
>> internet was also not there. I went to the client's place. There cant be
>> anything wrong with the view as such as the app has been working for the
>> last four years or so. The parent table had about 60,000 records where as
>> the child had about 192,000 records which is not much at all. So I made
>> two
>> databases for data before year 2007 and one for the current year.
>>
>> What I have doen is befor the 'Save' I take a count of the no. of records
>> in
>> the child view. 'Save' and then do a requery to see if the same no. of
>> records have come in the child view again else raise an error to check
>> for
>> data not been saved.
>>
>> I have had no complaints for the last three days but the problem which
>> was
>> there also did not happen everyday. So lests see with fingers closed.
>>
>
> How are you saving....TABLEUPDATE? Is your remote view table buffered?
> Some had suggested you show us the view definition by doing a GENDBC and
> posting the resulting code here. That way we can better help you!
>
> --
> Michael J. Babcock, MCP
> MB Software Solutions, LLC
> http://mbsoftwaresolutions.com
> http://fabmate.com
> "Work smarter, not harder, with MBSS custom software solutions!"
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
