Search results for query: *

Looking again, I see I mis-read that. Sorry, ignore my last post. ;)

It looks like you might be repeating info. If I am reading this correctly, you want something like this as a result: insert into TABLE1 (A, B, C) values (1, 2, 3), (4, 5, 6), (7, 8, 9); The way it is set up, it is putting it like: insert into TABLE1 (A, B, C) values (1, 2...

Is it possible to create a table within a PL/SQL block? Basically I am checking user_tables to see if a table exists, and if it doesn't then I am creating it. declare v_count number; begin select count(*) into v_count from user_tables where table_name = 'TEMP_2YEAR_DRIVER'; if v_count =...

I like Benthic's Golden program. Not as cluttered as TOAD...

There are a few ways to do it. If it is not many rows, you could create an insert script. If you have a program like Golden, there should be Data Import/Export tool. I usually just use the Import function in Benthic's Golden.

Turk, The snippit I posted was just the FROM section of the query, not the whole thing. The whole thing is much longer. If that section looks correct, then I might need to focus looking else where in the query. I did paste my query into the window you suggested, but it is rejecting it saying...

Thanks for your input. There is nothing wrong with my SQL. I can run that statement in a different program, such as Toad or Golden, and it will return exactly what I want. The question was and still remains, how do I get this statement that works in other programs to work in Crystal Reports...

I am using CR 8. I am trying to select information from multiple tables and am getting snagged by an invalid character. My best guess is that I am getting hung up on the FROM protion of my SQL Query. I am trying to select information from a nested query. My from statment looks similar to...

I think it is choking on me not moving out of that field. Since it is still editing the record, it has not been updated yet. I did find a work around. I created another subform of a datasheet of the OfferIDs. Not as clean, but functional. I still would like help on this question though...

My goal: Have a listbox full of OfferIDs. I want to display the detailed information for a perticular OfferID when it has been selected in the listbox. Here is what I am doing, that is not working: Created table to hold the selected OfferID. Main form is based off of this table. Put a...

This should help. http://www.microsoft-accesssolutions.co.uk/disable_mousewheel.htm

Same question, but with only one column. I have one column that can span say 3", but I only want the list box to span 1.5". Is there a way to scroll across to the right to view the missing text?

Underlay is working, but now it is forcing the other two sections to the following page. It looks like this: ---------------- | SubReport 2 | | | | | | | - - - - - - - - -...

Ok, something is not working. It will not allow me to put a SubReport within a SubReport. So I created an outside Report to incorporate the two SubReports. Then when I attached that outside report to the main report, the SubReports within do not show up.

Thanks!!!

Got it!!! Thanks guys!

My selection formula is filtering for records with null values in the Expired_Date column. I think that is causing it to continue to display the 1/26/04. Is there anyway to have this pull the minimum from all records, grouped by BookName?

The database table I am looking at has legacy data. I am looking to get the minimum start date, but the rest of the data from the current record. Here is an example: Table: BOOKS Fields: Name Description Release_Date Expired_Date ABCook Cooking 12/30/2003...

Ok, I figured out a little of it, but still need help in this issue. I found out that I am able to add other detail sections, and that works great of a portion of my report. The other thing I need to do is... ______________ _______________ | SubReport 1 | | SubReport 2 | | | |...

...there is a growing SubReport above. I am using Crystal Reports 8. I have a growing SubReport above other SubReports. The problem is, the top SubReport is growing over the lower SubReports. How do I get it to push the other Fields/SubReports down on the sheet? Thanks in advance for any...