Recent content by Gustavo

No it is not the primary key. It contains duplicate entries in that column. I tried making it primary but Access does not like that.

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...

OK, I believe I see what your doing your passing with ''. I wasn't even placing that on the command line. Currently I have server .BAT files that will call this .SQL. I was hoping I could just modify the .SQL and not effect the .BAT's to add ''. Any way aroudn this?

This how I am invoking it. from my .bat file the TESTING may or may not be there when the .SQL is being invoked. sqlplus DimRptSelect/************@DBA @c:\qafileshare\FindCDs_TEST.sql TESTING I can't thank enough for the help.

A little closer. I believe your code worked. Now it appears it does not like when I am give an &1 from the command line. I receive the following Enter value for 1: Is there a SET that I can do to get around this.

I will need to return more then on row. Yeah sorry about that I am trying to figure this whole SQL thing. It appears that my "if statement" will be come more complicated now that I need to return more then one row.

I think I'getting further. Now I get a ORA-01422: exact fetch returns more than requested number of rows. It appears that I will need to get a little bit fancier. I'm just sure of the syntax.

Hi Ken thanks for the response. No what I do is in a DOS command and depending what the DOS command does it will feed the .SQL &1 &2 &3 and &4 may or not be populated with anything.

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...

Hello, I did finally correct this issue. The crviewer.dll will either get installed with report designer or update via intranet/internet. The crviewer.dll is ONLY for the web browser. If you unregister the .dll then open up the web browser and run a report via the web it will download the proper...

Hello, I apologize for bothering you but did you ever get this resolved, if you did how?

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?

General access containing the files would be read only. My application, however, using a signon and password it provides, would be able to write. I am using NT security and have tried the LOGONUSER API with no success

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