Search results for query: *

Unclear as to what I am doing wrong. HELP! Example of what I am doing. SELECT DISTINCT PCMS_PCMS_CHDOC_DATA.CH_UID AS Num_ID, DimGrpLkup.lkup_trans FROM PCMS_PCMS_CHDOC_DATA INNER JOIN DimGrpLkup ON PCMS_PCMS_CHDOC_DATA.PRODUCT_ID = DimGrpLkup.lkup_product WHERE...

Looking for help creating an "IF THEN ELSE". I would like to pass my .SQL a variable from SQLPlus using the command line and detemine if the variable has actually been populated (It may or May not be). Something as follows. Delare dpart varchar() begin dpart:=&1 if dpart is null then Select...

I am currently tiring to use the "Add Command" under Database Expert in ver.9 with out much luck. I can build individual SQL and they appear to run OK. When I start to link these or Link them to reports it will not display the information or only one row of information. Any help or suggestion is...

I am currently trying to place a Memo field on my report Designer 8.0 from an Oracle DB going through an ODBC driver. When placing it on the report it will only show me the first charter then truncate the rest. Any Help?

I would like my application to to sign on with a secured userid and password and save a file. Is this possible through VB

Does any know of a good site that will explain the use of the Getchunk or Appendchunck. I have been out to the Microsoft site and used their examples with no luck. I can pull the file into my vb code but cannot get it into my database. I receive no errors when running my code it just will not...