[glibs]

У меня была проблема в 3.0 сп3. В 3.0 сп6 связи убрали, как я погляжу.

В 5.0 форма открывается. Но запрос формируется...

SELECT A.DEL_INVENTTRANSASPICKED,A.INVENTTRANSFEROVERDELIVERY,A.RESERVEONORDERED,A.ADDTRANSACT,A.INVENTTRANSFERUNDERDELIVERY,A.PACKINGMATERIALENABLED,A.COSTPRICEPCSMAXVALUE,A.COSTBREAKDOWN,A.USEQUALITYMANAGEMENT,A.TESTHOURLYRATE,A.MULTISITEDIMENSIONLINK,A.MULTISITEDIMENSION,A.PRODSTANDARDCOSTVARIANCE,A.FISCALLIFOJOURNALNAMEIDINTER16,A.FISCALLIFOJOURNALNAMEIDFINAL,A.FISCALLIFOCALCPERIOD,A.BOMJOURNALNAMEID,A.COUNTJOURNALNAMEID,A.TRANSFERJOURNALNAMEID,A.LOSSPROFITJOURNALNAMEID,A.MOVEMENTJOURNALNAMEID,A.FISCALLIFODEVIATIONPERCENT,A.FISCALLIFOWIPPERIOD,A.DEL_MINAVERAGESETTLE,A.TRANSFERORDERPICKROUTESTATUS27,A.DEFAULTUNITID,A.KEY_,A.LOCKCOUNTING,A.TAGCOUNTINGJOURNALNAMEID,A.POSTESTIMATESPERIODIC,A.POSTPHYSICALTAX,A.INVENTTRANSFERAUTORESERVATION,A.AUTOENDORDERPICK,A.LASTPRICEHISTORY,A.SHIPCARRIERRETURNTO,A.MANDATORYITEMTAXGROUP,A.MULTISITEACTIVATED,A.CLOSEBATCHGROUPID,A.CLOSEBATCHHELPERS,A.MULTISITEDEFAULTINVENTSITEID,A.MULTISITEDEFAULTINVENTLOCATI65,A.MODIFIEDDATETIME,A.MODIFIEDBY,A.RECVERSION,A.RECID,B.DEL_PURCHPRICE,B.BOMMAXLEVEL,B.CHECKBOMWHEN,B.KEY_,B.DEL_PRICEMODEL,B.MANDATORYQTYANDDATE,B.BLOCKREMOVEAPPROVAL,B.BLOCKEDITING,B.BOMCALCGROUPID,B.MODIFIEDDATETIME,B.DEL_MODIFIEDTIME,B.MODIFIEDBY,B.RECVERSION,B.RECID,C.KEY_,C.DEL_ARRIVALJOURNAL,C.EPCMANAGER,C.EPCPARTITION,C.EPCTAGTYPE,C.COMMUNICATIONLOGFILE,C.COMMUNICATIONLOGGINGLEVEL,C.RECVERSION,C.RECID,D.INVOICEREGISTERJOURNALNAME,D.DOCUTYPEID,D.SPECQTY,D.CHECKCREDITMAX,D.STORNO,D.CREDITREMAINING,D.CALCULATEMULTILINEDISCOUNT,D.CALCULATETOTALDISCOUNT,D.REDUCEONHAND,D.UPDATENOW,D.PRINTOUT,D.PRINTPACKINGSLIP,D.PRINTCALLTAG,D.PRINTCODLABEL,D.PRINTSHIPPINGLABEL,D.SALESTYPE,D.KEY_,D.CHECKCREDITLIMIT,D.CREDITLINEERROR,D.CUSTTABLEUPDATECURRENCY,D.ROUTECARDJOURNALNAMEID,D.PRODPICKINGLISTJOURNALNAMEID,D.ROUTECARDAUTOPOSTING,D.PRODPICKINGLISTAUTOPOSTING,D.PROJJOURNALNAMEID,D.PRICEDISCJOURNALNAME,D.PROFITLOSSJOURNALNAMEID,D.COUNTJOURNALNAMEID,D.TRANSFERJOURNALNAMEID,D.CHECKMULTIPLEWAREHOUSES,D.FREETEXTINVOICELEDGERACCOUNT,D.CUSTPAYMJOURNALNAMEID,D.MODIFIEDDATETIME,D.DEL_MODIFIEDTIME,D.MODIFIEDBY,D.RECVERSION,D.RECID
FROM INVENTPARAMETERS A,BOMPARAMETERS B,RFIDPARAMETERS C,AXDDOCUMENTPARAMETERS D
WHERE (A.DATAAREAID=?)
AND (B.DATAAREAID=?)
AND (C.DATAAREAID=?)
AND (D.DATAAREAID=?)
ORDER BY A.DATAAREAID,A.KEY_ OPTION(FAST 1)