Search results for query: *

I am a serious new guy to rpg programming on an iSeries all i really want to do is have a simple insert statement run in an sqlrpg le program. I am planning on moving SQL to a stored proc later but i just wanted to learn the basics first. C/Exec SQL C+ SELECT * FROM MYLIB/CUSTMST C/END-EXEC I...

I have a table with a list of users and passwords in a SQL Server DB. These users are in no way connected to LDAP,NT,AD. I need to import users into Crystal Enterprise XI as enterprise users. I do not know where the Crystal Enterprise Users and are stored and what table.( i am using a SQL server...

I am trying to figure out how to dynamically prompt the user for something like the Following. (The prompting is used to handle our organization hierarchy at any point in time) They user will pick a date and company level like WHOLE COMPANY,EXECUTIVES,DIVISIONS,REGIONS,STORES this will filter...

I have two tables that join with a Contract table with PK_Contract_ID to another table with Contract Detail with FK_Contract_ID which has a one to many. What i want from the detail table is a date field. Everytime a customer makes a payment the detail table gets a new record of the payment...

I am using Crystal 8, and my data looks like so before i create my cross tab. Week Contracts %Open 1 1500 100 2 1000 66 3 800 53 4 400 26 5 200 13 Now my Week 1 # of contracts is my total contracts the formula is...

Because the weird situation this report required i had to build some helper tables to get things in the format in need from my T-SQL. My stored procedure looks like this: BEGIN EXEC dbo.Keep_Agr_IDs @Number = @Week END BEGIN EXEC Keep_Data END BEGIN Select * FROM Keep_Table_ALL END...

I have a report where i need to show total Number of Contracts for a particular week. Lets say week ending 6/10/2005 and for that week i can get the total Contracts i've all computed the total number of contracts opened that week which are still open at the end of that week. But what i need...

I'm working on a project in which i need to check a trend for contracts and show the precentage of contracts still N weeks away from the week the contract was opened. I enter a begin date and End Date to select my Range. Then for Week Date In my range I count the total number of Contacts, Count...

I'm having some troubles with setting up my form with my crystal viewer. In VB i was able to set up everything dynamically with GerParameterName method, SetParameterValues Method, SetReportSource method. I can't seem to do this in C#. If any body has some code on this subject i'd be very happy...

I've created a custom paging setup but, my navigation buttons at the bottom of my grid, don't allow me to click them and go to the next page. I have custom paging = true and paging = true, and i've set up my datagrid virtual item count as well. Sincerely, Michael

When i select something from one of my drop downs lists, and i output Response.Write(dropdownlist.selectedvalue); it would return something like this NYNY instead i just want NY Sincerely, Michael

I'm working on some ASP.Net pages and i'm using three Drop Down lists. Once the second drop down list is selected and changed i want to populate the third drop down with data from a stored procedure with the use of the other two combo boxes value as my parameters. Where i could use some help is...

I've have a dedicated server where i store my .exe applications and i have never deployed a .Net app. I'm just wondering about how to succefully do this and things i should watch. My main concern right now is when i want to deploy a Windows clients, i have three options i under that Machine and...

Just wondering if anybody knows how to not only set the focus to a Datagrid, but also make sure if goes to a particular cell in the grid. I have a combobox of items and when the user hits enter i want it to got right to the quantity column for that item. Sincerely, Fritts

I'm just wondering if anybody can get a datagrid keypress event to work if you have a single box in the grid selected? It seems to me that the keypress supplied with the datagrid only works if the entire row is selected, i want it to use that keypress if i hit enter so i can return my user back...

In my datagrid i always have an extra row that just sits around blank. I would like to be able to get rid of that extra row? Sincerely, Michael Fritts

How do i push changes from a set of textboxes to my dataset? I understand how to do a stored procedure and grab the data from my sqlserver and set the textboxes equal to the data value. Now for my update, i need to be able to see that the dataset has changes but right now only my textboxes...

I'm using Stored Procedures with SQL server. I have specified the InsertCommand,DeleteCommand, UpdateCommand for my dataadapter. the i go and call this code. dsTrial.GetChanges() If dsTrial.HasChanges Then daTrial.Update(dsTrial, "Trial") Catch ex As Exception...

I'm working with a datagrid and a dataset, and when the user click the save button. I want to delete,Insert, Update any rows that have a changed row state. Now i have developed stored procedures for each event because i cannot use commandbuilder because my data is from more than one table. So...

Is there anyway to restrict the delete key from deleting a row in my datagrid? Sincerely, Fritts