OMA - check the spelling "alais" in your statement. Is this a misprint, or is it what you have in your code?
"Oma Cox" <[EMAIL PROTECTED]> wrote: > >I'm sconnecting to a SQL 6.0 DB (MP2 - Maintenance Management >Application). I can attach to all of the tables but with some of the >tables when I attempt to retrieve data from them I get this error >message. > >[Microsoft] [ODBC SQL Server Driver] Cursor Type Changed! > >Any Ideas what is doing this or what I need to do access those tables! > >Also in the same SQL database that I'm attaching to there is a table EMP >(EMPLOYEE INFORMATION) that has a column named ZIP. I get a dialog box >that asks me to give that column an alias. > >I'm using this below. > >Sattach EMP as EMPINFO using EMPCODE,FIRSTNAME,LASTNAME,ZIP alais >USERID,FNAME,LNAME,ZIPCODE > >Is there any way to stop this dialog box request? > >Also when I attach to any of the tables using only a few of the columns >Sattach command for the table I get all of the columns any way! Is this >correct? > >I'm using Patch four! > >I'll be gone today and I'll check any responses in the morning! > > >Best regards, > >Oma Cox > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
