Search results for query: *

I have a report that groups records first by room number, then by student name and must stay in this order. A student may appear in multiple rooms and I would like to show each student only once in the entire report regardless of how many rooms they appear in. Example: Room 1 Student 1...

(Crystal 8.5)On the first and last record of a group, I want to set a variable equal to a value within that record. I need to do this for every grouping. So I initialize the variable in the report header whileprintingrecords ; shared datetimevar start_date:= cdatetime("01/01/2006 10:10:00...

I am trying to create a short cut to a batch file from within a batch file. I have experimented with the following code, but been unable to link to the batch file. del "c:\link.url" echo [DEFAULT] >> "c:\link.url" echo BASEURL= >> "c:\link.url" echo [InternetShortcut] >> "c:\link.url" echo...

We have a symbol ls2208 hand held barcode reader connected to our PC via a Synapse wedge. The scanner will scan correctly for numerous times, then receive 4 beeps. The documentation says this is due to a communication error and needs to be programmed. We have checked all the options, and this...

I am using an ASP page to read records from a text file and make multiple entries into a SQL database. I wish this to be an all or nothing entry, if one fails then all the entries will rollback. This seems to work with under 10 records, but fails after that point with the following error...

My problem is I am dropping the first record in my Dataset when writing to the DB. Dim MyDataSet As New DataSet MyDataAdaptor.Fill(MyDataSet) Dim MyDataRow As DataRow Dim strSQL As String = "" Dim sqlConnection As SqlClient.SqlConnection Dim sqlCommand As SqlClient.SqlCommand Dim sqlCommand2 As...

I have no clue with rpg and I am trying to convert some data. So please be kind. I am trying to convert a character value into a packed decimal using rpg ile. Here is what I was thinking, pass in a value like ('0555.000') into the procedure. Pack the data and return the packed decimal...

I would like to make a logical file/view of data contained in a physical file. The data is comp3 data contained within a character field. The physical file layout for this field is: Field1 pic x(283) the panel accessing this table uses a copy book to define it as: Field1 pic x(100) Field2...

I know I can use DB2 SQL to read packed fields from a table. When loading data from a file I currently use a cobol program to convert packed fields and load tables. Is it possible to insert or update packed fields from DB2 SQL? What are some good resources on packed fields? Thanks, Greg

I have been tasked with acquiring a palm based solution for our organization. I have look at Palm OS and Windows OS for handhelds and numerous development environments. We need a solution that our programmers can develop in (mainly Microsoft shop) for a wide variety of applications including...

I have a insert into statement that when run from a stored procedure does not return a record set. But if I extract it and manually run the code, I return a record set. INSERT INTO VCShrpy..EmployeeFinal SELECT 'T' AS Record_Type, 'A' AS Command, DBShrpn..employee.emp_id AS...

My question is, if a transaction contains a call to a store procedure that inserts data into a table and this procdure then calls another store procedure to update another table. Will the entire transaction be rolled back if the insert or update fails in either nested stored procedure? This...

I have an ASP page with numerous forms that calls a javascript function. This function then submits the form using myform.submit(). This works fine in EI but does not do anything in Netscape7.01. It does fine until the form submit, then hangs. I tried using document.myform.submit(), but it...

I am using ASP to connect to a MS Access 97 mdb using a DNS-less connection. I then query the mdb and concatenate the fields and add delimenters then write to a text file. When I read this from the record set and write to a text file, I am getting erroneous/extra data on the ends of certain...

I have an on-demand subreport that builds from a different stored procedure than the main report. Is there a way to pass a parameter from the main report to the stored procedure of the on demand crystal sub-report?