[Metakit] Select view question.

[Goutam Paruchuri]

Hello !

I have a view called Engines in the database. I would like to define the view and reuse it in several places? Below is a code sample

Sample 1 returns zero rows while Sample 2 returns rows..

I would like db.Engines to be a variable name (like tblEngines as defined).

 

mk::file open db mydata.db

 

# create a view within the datafile which describes what we'll store

set tblEngines [mk::view layout db.Engines]

Sample 1

foreach row [mk::select $tblEngines] {
 puts [mk::get $tblEngines!$row EngineCode]
}

 

Sample 2
foreach row [mk::select db.Engines] {
 puts [mk::get db.Engines!$row EngineCode]
}

 

Thanks !

Goutam

 

 

------------------------------------------------------------------------------------

"Two things are infinite: the universe and human stupidity; and I'm not sure about the the universe."

Sir Albert Einstein

------------------------------------------------------------------------------------

Goutam Paruchuri

Database Consultant,

O'NEIL & ASSOCIATES, INC. http://www.oneil.com
495 Byers Rd.
Miamisburg, Ohio 45342-3662
Phone: (937) 865-0846 ext. 3051
Fax: (937) 865-5858   

 

Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.

_____________________________________________
Metakit mailing list  -  [EMAIL PROTECTED]
http://www.equi4.com/mailman/listinfo/metakit