Hi every body, Can some one help m

[Guest_imported]

Hi every body,
Can some one help me please?
the command " create view " functions correctly in the environment Visual Fox Pro 6.0 but when one calls this command starting from .exe file a msg appears "fonctionality non available " ,how can one solve this problem?
Thnks for any help

 

[fluteplr]

certain commands are not available from the runtime environment Create View is apparently one of them. If you have not the latest service pack (5 I think) you might want to do that as some functionality has been added to the run time in the last few service packs.

Other than that you will have to create the view in code.

 

[GrigoreDolghin]

Hello.

I am positive that it works in VFP SP4 & SP5. I've used it. Please be so kind to post the line which creates the view. Grigore Dolghin
Class Software
Bucharest, Romania

 

[Guest_imported]

Thanks for your reply so I've a command which has in click event this only line [create view].

 

[SGLong]

You need to include the name of the view you want to create (i.e. CREATE VIEW MYCLICKEVENT) so that later you can SET VIEW TO MYCLICKEVENT.

 

[weedz]

Be aware of the following:

Create view myFile:
Creates a view file from the Visual FoxPro environment.

Create view can also be used to create a view in a database.

HTH,
Weedz (Wietze Veld)

http://www.crowncap.demon.nl

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best. - Steve McConnell

 

[Guest_imported]

Hi,
I downloaded the service pack 5 as envisaged but the same message perciste.
Can some one help me?

 

[TomasDill]

Hi!

This command opens the view editor window that is strictly VFP design-time environment functionality. Thus you cannor use it in EXE in run-time. To create view programmatically, you should use "CREATE SQL VIEW ... AS SELECT ..." command.

If you still need view designer in run-time, search

http://www.universalthread.com

for custom view designers. Otherwise, just install developer version of the VFP on the client computer and run your EXE file from developer environment.


Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[DEDMOD]

On that subject, Vlad, if you do a CREATE VIEW REMOTE, how do or can you make it read-write? --DAVE

 

[TomasDill]

Hi!

DEDMOD, DBSETPROP() it! You require to set only certain properties to make it updatable: Key field, key field updatable property (if you want key field updating) and the Updatable property for view. Maybe something other, like an a way SQL WHERE clause generated.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs