Yes, of course. If goes something like that: SELECT O.REC_ID,O.REC_DELETED,O.OWNER_ID, O.TEOID_PREPARATION, O.TEOID_REALIZATION, O.EST_CLOSURE_DATE, O.OFFER_STATUS,O.OFFER_TYPE,O.CUSTOMER_NAME,O.CUSTOMER_CITY,O.VALID_DATE,O.S ENT_DATE,O.SUBJECT, O.OFFER_VALUE, CHAR(DATE(O.CREATE_DT)) || ' ' || CHAR(TIME(O.CREATE_DT)) AS CREATE_DT, SUBSTR(CHAR(O.LACTION_DT),1,16) AS LACTION_DT, D.ELEMENT_ID AS OFFER_STATUS_NAME, U.FIRST_NAME || ' ' || U.LAST_NAME AS OWNER_NAME, DECODE(V.L_ZAL,NULL,0,V.L_ZAL) AS L_ZAL FROM TBL_OFFERS O, TBL_DICTIONARY D, TBL_USERS U,VIEW_ATT_FOR_OFFERS V WHERE (D.DICT_ID = 'OFFER_STATUS') AND (O.OFFER_STATUS = D.FLX_NUM1) AND (O.OWNER_ID= U.USER_ID(+) ) AND (O.REC_ID=V.ID(+))
where VIEW_ATT_FOR_OFFERS goes like SELECT NUM(ID) AS ID,COUNT(ID) AS L_ZAL FROM TBL_REPOSITORY_DESC WHERE TYPE='OFFERS' GROUP BY ID Does it help? Anyway, thanks for response. Marcin Uzytkownik "Diesing, Burkhard" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > Hi, > > > Some days ago I have written simple VB6 application > > which connects to SAP DB with ADO engine. > > SAP DB is 7.3.0.40, on Linux RH. > > And everything works fine, except the fact, that > > one of my users (running Windows XP) is very oftem getting > > the error which > > says: > > -710 Missing select PARSID. > > Did you know on which SQL command the error occures ? > > Regards > Burkhard > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
