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 2585
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: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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...
|
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |