Recent content by ceesql

I am experiencing very long times when exporting very large e.g.9587kb reports (in eportfolio) to .rpt format using the Active X viewer. I usually end up cancelling. Anyone else have this issue? Or is there a workaround this. Pageserver settings: 20 M before Idle Connect Closed 60 M Idle...

Just finished reading the thread-Wow. We are in the midst of converting a Platinum DB (SQL) to Apprise (Progress V9.1D08). Part of this coversion is having to re-write all Crystal Reports 8.5. The registry has been updated to allow left joins; Using ODBC Merant 3.60 32-bit Progress SQL92 v...

One advantage is speed. Complex formulas can be processed on the server instead of the report.

I need to convert a tables' julian dates to DateTime. Is there a simple way to do this? Any help is appreciated. Thanks

I have Access 97 App, that, until July, has worked fine. July 1 the subj error started appearing. Unable to de-bug - hitting blank. I've located the field which is null (ptdEnd) but unable to locate where this field is being updated. I documented the report form and discovered that the row...

Thanks Terry, I appreciate your reply. DBCC CHECKDB uses a lot of resources against the system. I'm wondering if there is a way to target a specific table. Cenie

I've joined several large tables into 1 table that is updated nightly. There must be bad data in the table because I received this error last night: Server: Msg 614, Level 18, State 3, Line 8 A row on page 774351 was accessed that has an illegal length of 0 in database 'THWG'. How do you...

Anyone heard of an XP patch available for Access applications to handle possible VBA scrip corruption. I have an Access97 application which will be moved to a PC running XP.

I have an OTC 850XL printer, used for invoices, that I send a Crystal Report to. I have a driver which is v3.3. I believe I may need version 2.5 or a generic windows text print driver. Anyone know where I can download drivers like these? Thanks in advance for your help

Thank you all for your expert advice. I ended up with this: &quot;Delete * From tblSales where date_shipped >= #&quot; & LastUpdate & &quot;#&quot; & _ &quot;OR (date_shipped >= #&quot; & DateAdd(&quot;d&quot;, -20, LastUpdate) & &quot;# And qty_shipped < 0)&quot;

Thanks for your help! I'll try this now and let you know.

Thank you for your help. The error I get is &quot;Data type mismatch in criterior&quot; The code worked fine, before I added this statement: &quot;or tblSales.qty_shipped < 0 and tblSales.date_shipped >= dateadd(d,-20,#&quot; & LastUpdate & &quot;#)&quot;

Following is more of the code: sql = &quot;INSERT INTO tblSales &quot; & _ &quot;SELECT tblSales.* &quot; & _ &quot;FROM &quot; & _ *******ODBC CLAUSE HERE****** &quot;INNER JOIN tblSalesOrganization &quot; & _ &quot;ON (tblSales.ship_to_code =...

I'm pulling data from a SQL DB table to a local table in the application.

I am having difficulty adding the dateadd function to a sql script &quot;where&quot; clause within an application. I want to include records that have neg qty within a 20day period. The original code is: sql = &quot;Delete * From tblSales where date_shipped >= #&quot; & LastUpdate &...