Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mickyang

  1. mickyang

    list your database table indexs.

    select so.name as TableName, sind.name as PKName, case when (sind.status & 0x800) = 0x800 then 'PK' else 'IX' end as IndexType, sik.keyno, col.name as ColName , case when sind.indid = 1 then 'Yes' else '' end as 'Clustered Indexes' from sysobjects so inner join sysindexes sind on...
  2. mickyang

    When I use Crystal Report 9 , how to assign server name in RAS.

    When I use Crystal Report 9 , how to assign SQL server name and Database name and User ID and user password in RAS. i can use Session("oClientDoc").DatabaseController.Logon "sa", "password" assign userid and password , but how to assign SQL server name and...
  3. mickyang

    WEB-server printing blank pages

    ans... http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr8_web_best_practices.pdf
  4. mickyang

    RetrieveStoredProcParams & Not enough memory for operation ?

    My Visual Basic code: '======================================================== Set Crystalreport = CreateObject("Crystal.CrystalReport") Crystalreport.ReportFileName = "C:\182.RPT" MsgBox Crystalreport.RetrieveStoredProcParams...
  5. mickyang

    How to export to DHTML ,when i use crystl32.ocx(8.0)?

    >1) You need two patch files from the Seagate Site. > cr8dev.zip and > dbexdrvr.zip Thank You... But... I can't found cr8dev.zip and dbexdrvr.zip on http://support.crystaldecisions.com Please tell me how to get cr8dev.zip and dbexdrvr.zip two files ?
  6. mickyang

    How to export to DHTML ,when i use crystl32.ocx(8.0)?

    How to export to DHTML ,when i use crystl32.ocx(8.0) ? my VB code : Crystalreport.PrintFileName = RepOutFileName CrystalReport.PrintFileType = crptHTML30 Crystalreport.Destination = 2 crystl32.ocx can export DHTML(HTML4.0) ?

Part and Inventory Search

Back
Top