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  2582 
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.google.c om... 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.google.c om... 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**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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******@tennisshop.com> wrote in message news:<IO*******************@fe2.columbus.rr.com>.. .
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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******@tennisshop.com> wrote in message news:<IO*******************@fe2.columbus.rr.com>.. .
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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******@tennisshop.com> wrote in message news:<IO*******************@fe2.columbus.rr.com>.. .
How about translation approach rather than remote view?
Anybody tried it? Yeah, I use Access for mine....
"swdev1" <ws**********@advmed.com> wrote in message
news:YZ***************@newssvr22.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.google.c om... 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...
|
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...
|
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...
|
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...
|
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...
|
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"...
|
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...
|
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....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
| |
