Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CREATE SQL VIEW considerations
Message
From
05/10/1997 18:06:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
CREATE SQL VIEW considerations
Miscellaneous
Thread ID:
00053351
Message ID:
00053351
Views:
63
As mentioned this week, many people suggested to deal with views programmatically because of the limitations of the view designer.

So, what I am doing is do create the view in the load of the form. However, to create a view, we need to have a database open. So, I create a database to hold this view. Now, what will happen if 2 users are accessing the form as the same time and do this create view with the same name on the same database? Or, is it like a SQL cursor where it is not related?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform