Search results for query: *

The following statement works in some spots and not in others: convert(datetime,b.dateval) >= DateADD(year,-@Years,GetDate()) and convert(datetime,b.dateval) <= getdate() b.dateval is a char and @years is an int. It works when I have it in a basic where clause, but it doesn't work if I have...

To create a new form, I copied and pasted from another form that was very similiar. In the new form I changed the form properties to point to the new datasource (among other changes). Now when I run and open the new form, I can't edit any of the fields. I can set focus on the fields and can...

I have a cross tab report that is rather wide and long and spans multiple pages. It exports properly to HTML and Word, but when I export to PDF the column labels, the row labels, and page numbers do not print on the pages that are too wide, but do print on the pages that are too long. Does...

I feel so stupid that I can't figure this out. I am writing a script that creates several tables. Essentially it starts out as: create table x( a number, b number); create table y( c number, d number); create table z( e number, f number); begin --my variable declaration -- a bunch of...

I am passing in a string to my report. It works if the string I pass in is less than 250 chars, but if it is greater, I get teh following error: 'Value does not fall within the expected range.' How do I resolve this? There is a length limit option for the parameter, which I tried setting...

I have a string that contains values seperated by commas. I want to use these values in my IN clause. This is what I mean: to simplify branch_string char(10); branch_string := '1,2,3,4'; select * from branch where branch_id in (branch_string); How can I do this? Thanks in advance.

I am using a formula to create a string. The string is long and wraps, but I would prefer to control this with line breaks. I have looked through the functions in the formula editor, but haven't found anything. Is this something I can do? Does anybody know the syntax to do this?

I posted this on Other Topics, but maybe I should have posted this here. My report has three groupings (Year, Month, Branch). I wrote a stored procedure that successfully returns incidences to be tallied for a specified time period, plus incidences prior to the specified period, necessary for...

My report has three groupings (Year, Month, Branch). I wrote a stored procedure that successfully returns incidences to be tallied for a specified time period, plus incidences prior to the specified period, necessary for a ytd calulation. I have a branch total, monthly total, and a report...

The below sql is not bringing back the results I want. I have tried using joins, which I think are the answer, but obviously it still isn't working. The Lookup table is suppose to bring back the different severity types ie) Catastrophic, Serious, Major, Minor. All the incidences in the...

This is a short example of my code: insert into table3(a,b,c,d,e,f,g) select h,i,j,null,null,null,k from table 1 union select null,null,null,l,m,n,o from table 2 If I run each insert statement individually, it works. But if I run them together in a union I get the error: ORA-01790...

I am not an Oracle person, so it has taken me awhile to learn how creating a report based on stored procedure results differs from Sybase (thanks partly due to this website.) I now have my package, procedure and cursor created. I have added my stored procedure to the report and the Parameter...

I am not an Oracle person, so it has taken me awhile to learn how creating a report based on stored procedure results differs from Sybase (thanks partly due to this website.) I now have my package, procedure and cursor created. I have added my stored procedure to the report and the Parameter...

The .net version is quite stripped down from previous versions and there are lots of things I can't figure out how to do that I could do before. I want to make a union for my sql statement, but the SQL Statement window is read only so I can't manually write it. So I put my union in a stored...

I created a stored procedure that looks like this: CREATE OR REPLACE PROCEDURE procname ( --declare parameters) AS --declare variables begin --assign value to variables SELECT FROM WHERE UNION SELECT FROM WHERE UNION SELECT FROM WHERE; --I don't need an order by on the union...

I am having trouble suppressing a blank subreport. I looked through the forum and other's seemed to have similiar problems, but they seemed to be able to suppress the subreport, but an empty space was in it's place which they wanted to get rid of. For me, I can't even get that far. I have set...

I have a listbox which I populate with a resultset. My resultset brings back 428,700 rows. But when I ask for the listcount it gives me -30052. Why? The listcount works when the resultset is smaller. Is there a maximum size a listbox can handle? Thanks.

I found the following in the forum archives. select (rand() * MaxNum) + MinNum However, it doesn't work. I specified 59 as my max and 48 as my min. It returned random numbers higher than 59. If I set my MinNum to 1, it returned numbers from 1-59. How can I specify a range from 48-59?

I want to return all tables that don't have an index on a particular field. Can I do that? If so, how? Thanks!

I am getting the above error message when I do a select on a few particular fields from Oracle from within VB using an Oracle driver. VB help says that the problem is with my ODBC Driver, but doesn't say anything more than that. Any suggestions? I can select other fields without any problem...