Re: insert into a member from vb

sql's CREATE ALIAS.  The details would confuse you.
Or, creating a logical that only includes that member.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Angela Wawrzaszek" <awawrzaszek@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/01/2005 01:57 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
Maria Starr <mstarr@xxxxxxxxxxxxxxx>
Subject
insert into a member from vb






Hi all,

 

   Does any one know the syntax to insert into a member on the as400
from VB  The statement works until the member name is added to the
syntax

 

Currently trying:        insert into library.myfile(member) (fieldnames)
(fieldvalues)      it is erroring thinking the (member) is the beginning
of the fieldnames

 

 

We also tried:         insert into  library.myfile.member  (fieldname)
(fieldvalues)    but then it thought the library name was our system
name 

 

Thanks in advance!

 

 

 

Angela Wawrzaszek

IT Supervisor

awawrzaszek@xxxxxxxxxxxxxxx

(315) 258-4205

 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.