Search results for query: *

I figured out logic on my own to get this to work. Thanks to all who posted to this thread.

The data type is specified as a DateTime. The underlying field is from a SQL Server table whose field type is smalldatetime.

We're getting close. It seems the formula doesn't like the way my original date is formatted (A date is required here). Local DateVar Start := {HoursOverDueNoNationalLogistics.DUE_DATE}; Is there a function that will convert a MM/dd/yyyy formatted field into one that Crystal will use in this...

I'm trying to get the below formula to work but I keep getting an error message(A loop was evaluated more than the maximum number of times allowed. ). Any help would be greatly appreciated. Local DateTimeVar d1 := {HoursOverDueNoNationalLogistics.DUE_DATE}; Local DateTimeVar d2 :=...

This is not my first VB application. I am currently using the Crystal Reports activeX component and I want to switch to the newer way of interfacing with Crystal.

That's my problem. I'm not sure which components I need to add !

I'm trying to upgrade the way I call Crystal from within my VB application, so I can use the Crystal Report Viewer. However, I'm unsure which components/references I need to choose. When I try to run my application I get an error on the following lines of code. Public CrystalApplication As New...

I'm trying to upgrade the way I call Crystal from within my VB application, so I can use the Crystal Report Viewer. However, I'm unsure which components/references I need to choose. When I try to run my application I get an error on the following lines of code. Public CrystalApplication As New...

I'm trying to upgrade my VB application so that instead of calling Crystal Reports via the OCX, I'm trying to use the Crystal Report View Control (RDC). I'm struggling with what references and components I need checked so I can do this. When I try to run my code I get an error message on the...

Somehow a user was able to enter a CR/LF into a text field in one of my tables. I'd like to be able to search the rest of the records to see if this has happened before, but I'm not sure of the syntax I'd have to use. Can anyone enlighten me ? Also does anyone have any idea on how to prevent a...

I'm trying to determine if SUCCESS means the file was transferred in it's entirety.

According to the documentation that I can find about FTPPutFile, a return value of 1 indicates that the operation was successful. I was curious whether this means that the correct # of bytes were transferred or that just a file was created based on the passed parameter ?

I tried exporting into .CSV format, but that's causing the field names to be exporting as part of the data.

It appears that I can only export 65,535 records out of Crystal when I choose to export in Excel format. Is this a limitation of Crystal 8.5 or of Excel ?

That worked, but I don't know why it did. Care to enlighten me ?

I add "SET NOCOUNT ON" to my stored procedure ?

I have a real mystery here. I have a stored procedure that works when I call it from SQL Server Query Analyzer, but returns EOF when I call it from my VB code. I even took the code that makes up the stored procedure and try running that from VB with the same results. Here's the SQL code I'm...

Looked at the link and everything appears to be set up properly. Any other ideas ?

I get the following error message when I try to use xp_startmail: Server: Msg 17952, Level 18, State 1, Line 0 Failed to start SQL Mail session. Check the errorlog file in the SQL Server directory for details. What's interesting is that I can successfully send emails when a scheduled jobs...

Is there any way to figure out which one (dll) is bad ?