Search results for query: *

Thanks again for the responses. I had considered the an array. I am going to have to find a way to mark the first instance in the record set, so as I can use that field to suppress the subsequent fields. Thanks for the help!!! PS: Looking forward to upgrading. Thanks, Greg

Yes, 8.5, thanks for the reply. I am not using an ODBC data source, but an Active Data defintion file (ttx). My record source is an XML file. Thanks, Greg

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

Thanks, resolved the issue. Works great, just like you suggested! Thanks, Greg

Thanks, I see what you are saying. However, no matter what I seem to do, it is generating 'the summary / running total field could not be created." error. I am using ttx files to read xml data from the print engine. The field is a date/time field and I have experimented with datevar and...

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

You might try http://www.boingo.com/hso/hsiab/ Thanks, Greg

Yes thanks, conn object was cut during pasting. We are using SQL 7 and no linked server. Thanks, Greg

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

Thanks, solved. Was reading from a text file into the data set. Did not take into consideration that the first row should contain headers and I was not supplying this. Thanks again for the tips. Thanks, Greg

Thanks, solved. Was reading from a text file into the data set. Did not take into consideration that the first row should contain headers and I was not supplying this. Thanks again for the tips. Thanks, Greg

Thanks for the help on the connection. I have tried looping through dataset, but I am still dropping the very first record. When I display the dataset in a datagrid it shows all records. myDataTable.Rows.Count results is minus the first record when I check this value. I dont understand why I...

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

Talkturkey that worked exactly the way I needed. Thanks for your patience on my learning curve to the Cobol/RPG/DB2 World. So far has been quite the learning experience. Thanks!! Thanks, Greg

Thanks that works for me in one way great. The value I select from the character field in the physical file is a decimal 7p 3 representation stored in 4 characters. So when I need to write back to that file, I need to put it in the same 4 characters. The full hex value is too large for this...

What you say is correct TalkTurkey and works fine as I have described, but maybe I should have asked the question better. I have a DB2 physical file with a field that is defined as character, a cobol program writes a value to part of this field as a packed decimal value, we have taken an RPGIV...

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

Sure, we are using the IBM I-series box on the AS/400 with a DB2 backend. We are using a proprietary software package and trying to interface with it, so we cannot change the physical file layout. Here is the physical file layout: 01 PTF...