Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
8  2602 
Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
"Brandon" <br******@tenni sshop.com> wrote in message news:<IO******* ************@fe 2.columbus.rr.c om>...
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
"Brandon" <br******@tenni sshop.com> wrote in message news:<IO******* ************@fe 2.columbus.rr.c om>...
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
"Brandon" <br******@tenni sshop.com> wrote in message news:<IO******* ************@fe 2.columbus.rr.c om>...
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@a dvmed.com> wrote in message
news:YZ******** *******@newssvr 22.news.prodigy .com... Byung -
I do this all day long outside of mySql with Visual FoxPro.
You can too - with Versions 5,6,7 and 8.
Install your odbc driver and give it a whirl?
Remote views are COOL, man .
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
mySql / VFP / MS-SQL
"Byung Choi" <bc***@ueic.com > wrote in message
news:b7******** *************** ***@posting.goo gle.com... Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid
Select brand_name from Model
where model.name = 'Test'
This can be transformed into
SELECT brand_name FROM Model_CA, Brand
WHERE Model_CA.brand_ rid = Brand.rid and
Model_CA.name = 'Test'
Byung Choi
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tony Marston |
last post by:
For those who you thought my method of implementing OO principles in PHP was
totally wrong - see http://www.tonymarston.co.uk/php-mysql/good-bad-oop.html
for details, you can now read
http://www.tonymarston.co.uk/php-mysql/model-view-controller.html and tell
me why my implementation of the MVC design pattern is totally wrong.
Go on, I dare you. Make my day.
--
Tony (a legend in his own lunchtime) Marston
|
by: anders |
last post by:
What is the better approach in MySQL from a performance point of view?
I have approx 1000 stock market fond titles that I want to insert in
MySQL on daily basis and keep them in there for some years, I'll then
use the data for presentations, analysis,… the data I save is the
name, the date, the lowest, highest and last value and the volume.
The analysis will be run on all of them on daily/weekly basis.
implementation 1:...
|
by: Eitan Herman |
last post by:
What do i need to add to get something instead of an empty box?
Thanks in advance.
source:
// treeviewDlg.cpp : implementation file
//
#include <commctrl.h>
#include "stdafx.h"
|
by: Beowulf |
last post by:
I have the view below and if I use vwRouteReference as the rowsource
for a combo box in an MS Access form or run "SELECT * FROM
vwRouteReference" in SQL Query Analyzer, the rows don't come through
sorted by Numb.
Everything I've read on the web suggests that including the TOP
directive should enable ORDERY BY in views. Does someone have an idea
why the sorting is not working correctly for this particular view? thanks.
CREATE VIEW...
|
by: Griff |
last post by:
Two questions really, the first one "conceptual" and the other more involved
with design:
1 - There are two schools of thought where I work on the role of the
"controller" task.
The first is that the business object will provide the business rules and
that the controller will implement the rules and then pass the result set to
the view (i.e. do most of the grunt work).
| | |
by: Doug |
last post by:
Hi,
I learned a little about the model view presenter pattern at a
conference this last week and am experimenting with it. It's working
pretty well but I have a question.
I am trying to use it to reset info in a combo box. Below is some
sample code for my view interface and the presenter:
public interface IDevToolView
|
by: jimb |
last post by:
Looking for a simple view on the weather. Just learning the xml stuff.
I would like to add to the the weather.com icon. Any help is
appreciated.
<html>
<head>
<body bgcolor="#000000" text="#FFFFFF">
<p class=MsoNormal><o:p></o:p><span
style='font-size:288.0pt;font-family:Arial'>
|
by: Bill44077 |
last post by:
Hi,
I am new to the MVP pattern and one of the main reasons that we are going
this route is because we are doing Scrum with 30 day sprints - so we have a
continually morphing design. We are using TDD as well to improve our ability
to refactor... you probably all know this approach.
Although the user iterface is supposedly one of the last things that you
need to do, this is a web app and we have multiple nested Repeaters on the
page....
|
by: speedmaster |
last post by:
hi.
I problem is that i want to use pay-per-view implementation for some segments in my site which i m trying to develop, so help me how can i implement the pay-per-view in my cms and oscommerce.
thanks,
waiting for prompt reply,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
