New Message Search Latest Redo
FoxInCloud
views
Gravatar is a globally recognized avatar based on your email address. views
  Tuvia Vinitsky
  All
4BF1FFTZP
  Mar 31, 2015 @ 06:05am
Reply
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.

Gravatar is a globally recognized avatar based on your email address. Re: views
  FoxInCloud Support - Thierry N.
  Tuvia Vinitsky
4BF1FFU7W
  Mar 31, 2015 @ 07:59am
Reply
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.


Gravatar is a globally recognized avatar based on your email address. Re: views
  Tuvia Vinitsky
  Thierry Nivelet (FoxInCloud)
4BF1FF6H9
  Mar 31, 2015 @ 08:15am
Reply

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.



Gravatar is a globally recognized avatar based on your email address. Re: views
  FoxInCloud Support - Thierry N.
  Tuvia Vinitsky
4BF1FF6LM
  Mar 31, 2015 @ 09:37am
Reply
I presume parameters for views that are sub objects are not supported?

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)

Gravatar is a globally recognized avatar based on your email address. Re: views
  FoxInCloud Support - Thierry N.
  Tuvia Vinitsky
4BF18UUX8
  Mar 31, 2015 @ 08:55pm
Reply
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.





-- thn (FoxInCloud)

Gravatar is a globally recognized avatar based on your email address. Re: views
  Tuvia Vinitsky
  Thierry Nivelet (FoxInCloud)
4BG0H0HRW
  Apr 1, 2015 @ 07:56am
Reply
That's what I did.


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.





© 1996-2024