Search results for query: *

VB6 SP6 Win XP SP3 I have one form that when you resize the form (maximize or drag the form border) the width, height, scalewidth and scaleheight values do not change. As a result the controls do not resize (multiple types of controls). The resize event does fire properly. I have checked the...

Please have a look at thread149-1577419. zemp

CR2008 BO XI 3.1 (Infoview java panel) When scheduling a report the filters option allows the user to change the record selection values that are part of the report. Is there any way to lock or disable this in CR2008 or to remove the or disable the filter option in BO? If this requires...

I am trying to put together a stored procedure with a dynamic execution path based on criteia it collects. I am using a cursor to get the basic OrderID information and an 'Ordertype'. Ther type determines which other tables we need to access for scheduling and dispatching. These will be within...

CR XI I have a report in which I have a formula to increment a shared variable in the GH1. GH1 is set to repeat on each page. I would like my formula to ecexute only when GH1 changes and not every time GH1 prints. Is there a way to achieve this? zemp

CR XI Pro I have a report that has the ability to print a range if invoices. Group header 1 controls the invoices and starts each new invoice on a seperate page. Now I have had to add some information (in can grow subreports) to the group footer 1. The report gathers the information properly...

TLV, type-length-value or Type length encoded. VB6 SP6 I am looking for an example or documentation to turn a recordset (or any collection of string values) into a TLV string of data. Any links to docs or samples would be appreciated. Here is what I need: <total record size byte 1><total...

SQL Server 2000 SP4 Is there an easy method to copy or duplicate a record witrh in the same table. The only difference would be a new PK identity value. I have a table that stores both Bill to and Ship to addresses. When a client enters a new bill to address I would like to give them the...

SQL Server 2000 SP4 Is there a way to show the finished SQL statement from within a stored procedure that dynamically creates it. Even if all that can be done is to send it to a file. zemp

SQL Server 2000 SP4 I have a query that is based on a date range and a bit flag. The query returns a recordset of two records. One record for each state of the bit flag. The values are a SUM. Sometimes the query correctly return only one record. However in this case I would still like two...

VB6 SP6 I have a variable declared as a long. I can assign it a value of 34000 with no problems. However when I try to assign it a sum that equals 34000 I get the overflow error. For exampleDim MyLng as Long MyLong = 34000 ' works MyLong = 32000 + 2000 'error 6, overflow I also get the...

CR 10 Cross-tab placed in Report Header. I have been trying to get the following data set into a cross-tab for display. The table structure is a follows. Month Drug Dental Vision Fees Total ----- ---- ------ ------ ---- ----- 09-2006 100.00 110.00 120.00 60.00...

SQL Server 2000, SP4 I have one table that has entries based on a date. I am trying to get a sum of entries based on the last date within a month and only that date. Here is what I have so far. SELECT TOP 100 PERCENT ClientNumber, SUM(CurrentLives) AS Lives, CurrentDate, CurrentMonth FROM...

T-SQL SQL Server 2000 SP4 I am wondering if it is possible to directly change the name of a field in a table. I can create a new field, copy the data and then delete the original field. But I don't think that that is a clean way of doing things. FYI, I am writing a script to update a...

While doing some testing with 5.4 ERP I haver come accross this error and I don't understand why it is happening. This happens mainly in the AR Receipts when updating or creating batches through code. Can anyone shed some light on the subject? Thanks. zemp

SQL Server 2000 SP4 I am trying to create a Query to update one field from all records (100's of records) in a particuler table. So far I have only been successful in updating one record at a time. Here is what I have so far, declare @CID varchar(20) set @CID = (select...

CR 10 SQL Server 2000 SP4 I have a report on which I need to placew a subreport. I have a SQL statement that gets the information that I need. SELECT GR.GrpID, BE.BenfID, BE.BenfName, BE.BenfOrder, udCarrier.CarrName AS PresentCarrier, GR.TeminateDate, udCarrier_1.CarrName AS...

Using: CR 10. Database: MS SQL Servcer 2000 SP4. Connection: likely ODBC but open to suggestion. Called from a VB app. I am trying to design a large (20+ pages) report for an insurance company and I am not sure of the best way to do it. I am looking for your suggestions and comments. Here...

VB6 SP6 ADO 2.8 PSQL 9.1 winXP SP2 or win2000 SP4 I have an app that worked well with Pervasive 2000i through V8.7 with no major syntax changes required. I have upgraded my test machine to PSQL 9.1 and receive the following error. -2147217887 Multiple Step operation generated errors. Check...

Pervasive 8.6 and 9 MS SQL Server has a 'Truncate Table..' SQL statement that will remove all date from the table and reset the PK identity field to '1'(the starting value). Does Pervasive have a similar statement/keyword? If so what is the synatx? If not how can I acheive the same effect in...