SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.
Can you try this:
modify class awfrm OF aw method wViewSetup && if you use Windows >= Vista, make sure to run the VFP IDE as AN ADMINISTRATOR&& modify this case:
case m.llDot and varSet(@m.lcField, JustField(m.lcParm, @m.lcAlias)) && alias.field or object.property
success = .F.;
or Type(m.lcAlias) == 'O' and lProperty(Evaluate(m.lcAlias), m.lcField); && modify command abOOP
or Used(m.lcAlias) and lField(m.lcField, m.lcAlias);
or cResultAdd(@m.result, Textmerge([View: parameter # ))(' '): Alias|Object ' ' and/or Field|Property ' ' can't be found]
oTowApp is public, and I can suspend and confirm that it exists and is completely correct. It is used all over. However if I have a view like this:
SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.
That fixed the main problem. Thanks!!!
Is it accurate error message btw that
VIEW customers: parameter 31
('otowapp.ofilter.filter1') is not supported.
I presume parameters for views that are sub objects are not supported?
Hi Tuvia,
Can you try this:
modify class awfrm OF aw method wViewSetup && if you use Windows >= Vista, make sure to run the VFP IDE as AN ADMINISTRATOR&& modify this case:
case m.llDot and varSet(@m.lcField, JustField(m.lcParm, @m.lcAlias)) && alias.field or object.property
success = .F.;
or Type(m.lcAlias) == 'O' and lProperty(Evaluate(m.lcAlias), m.lcField); && modify command abOOP
or Used(m.lcAlias) and lField(m.lcField, m.lcAlias);
or cResultAdd(@m.result, Textmerge([View: parameter # ))(' '): Alias|Object ' ' and/or Field|Property ' ' can't be found]
oTowApp is public, and I can suspend and confirm that it exists and is completely correct. It is used all over. However if I have a view like this:
SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.
not until tomorrow ...
That fixed the main problem. Thanks!!!
Is it accurate error message btw that
VIEW customers: parameter 31
('otowapp.ofilter.filter1') is not supported.
I presume parameters for views that are sub objects are not supported?
Hi Tuvia,
Can you try this:
modify class awfrm OF aw method wViewSetup && if you use Windows >= Vista, make sure to run the VFP IDE as AN ADMINISTRATOR&& modify this case:
case m.llDot and varSet(@m.lcField, JustField(m.lcParm, @m.lcAlias)) && alias.field or object.property
success = .F.;
or Type(m.lcAlias) == 'O' and lProperty(Evaluate(m.lcAlias), m.lcField); && modify command abOOP
or Used(m.lcAlias) and lField(m.lcField, m.lcAlias);
or cResultAdd(@m.result, Textmerge([View: parameter # ))(' '): Alias|Object ' ' and/or Field|Property ' ' can't be found]
oTowApp is public, and I can suspend and confirm that it exists and is completely correct. It is used all over. However if I have a view like this:
SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.
-- thn (FoxInCloud)
instead of:
... where field = ?m.obj.obj.prop
you could use:
... where field = ?m.obj_obj_prop && instead of obj.obj.prop
...
thisForm.wViewParmSet(view, 'obj_obj_prop', m.obj.obj.prop)
That fixed the main problem. Thanks!!!
Is it accurate error message btw that
VIEW customers: parameter 31
('otowapp.ofilter.filter1') is not supported.
I presume parameters for views that are sub objects are not supported?
Hi Tuvia,
Can you try this:
modify class awfrm OF aw method wViewSetup && if you use Windows >= Vista, make sure to run the VFP IDE as AN ADMINISTRATOR&& modify this case:
case m.llDot and varSet(@m.lcField, JustField(m.lcParm, @m.lcAlias)) && alias.field or object.property
success = .F.;
or Type(m.lcAlias) == 'O' and lProperty(Evaluate(m.lcAlias), m.lcField); && modify command abOOP
or Used(m.lcAlias) and lField(m.lcField, m.lcAlias);
or cResultAdd(@m.result, Textmerge([View: parameter # ))(' '): Alias|Object ' ' and/or Field|Property ' ' can't be found]
oTowApp is public, and I can suspend and confirm that it exists and is completely correct. It is used all over. However if I have a view like this:
SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.
-- thn (FoxInCloud)
You may want to adopt an alternative parameter strategy, eg
instead of:
... where field = ?m.obj.obj.prop
you could use:
... where field = ?m.obj_obj_prop && instead of obj.obj.prop
...
thisForm.wViewParmSet(view, 'obj_obj_prop', m.obj.obj.prop)
That fixed the main problem. Thanks!!!
Is it accurate error message btw that
VIEW customers: parameter 31
('otowapp.ofilter.filter1') is not supported.
I presume parameters for views that are sub objects are not supported?
Hi Tuvia,
Can you try this:
modify class awfrm OF aw method wViewSetup && if you use Windows >= Vista, make sure to run the VFP IDE as AN ADMINISTRATOR&& modify this case:
case m.llDot and varSet(@m.lcField, JustField(m.lcParm, @m.lcAlias)) && alias.field or object.property
success = .F.;
or Type(m.lcAlias) == 'O' and lProperty(Evaluate(m.lcAlias), m.lcField); && modify command abOOP
or Used(m.lcAlias) and lField(m.lcField, m.lcAlias);
or cResultAdd(@m.result, Textmerge([View: parameter # ))(' '): Alias|Object ' ' and/or Field|Property ' ' can't be found]
oTowApp is public, and I can suspend and confirm that it exists and is completely correct. It is used all over. However if I have a view like this:
SELECT Inspection.Id, Inspection.fky_vehicle, Inspection.InspDate;
FROM ;
dbo.INSPECTION Inspection;
WHERE Inspection.InspDate > ( ?m.oTowApp.cArchiveDate )DBSetProp(ThisView,"View","SendUpdates",.T.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.T.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","ShareConnection",.F.)
DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","dbo.INSPECTION")
DBSetProp(ThisView,"View","WhereType",3)DBSetProp(ThisView+".id","Field","DataType","I")
DBSetProp(ThisView+".id","Field","UpdateName","dbo.INSPECTION.Id")
DBSetProp(ThisView+".id","Field","KeyField",.T.)
DBSetProp(ThisView+".id","Field","Updatable",.F.)DBSetProp(ThisView+".fky_vehicle","Field","DataType","I")
DBSetProp(ThisView+".fky_vehicle","Field","UpdateName","dbo.INSPECTION.fky_vehicle")
DBSetProp(ThisView+".fky_vehicle","Field","KeyField",.F.)
DBSetProp(ThisView+".fky_vehicle","Field","Updatable",.T.)DBSetProp(ThisView+".inspdate","Field","DataType","T")
DBSetProp(ThisView+".inspdate","Field","UpdateName","dbo.INSPECTION.InspDate")
DBSetProp(ThisView+".inspdate","Field","KeyField",.F.)
DBSetProp(ThisView+".inspdate","Field","Updatable",.T.)
forms produce an error in wviewssetup like this. Note the view opens fine initially.