Recent content by jlbsloan

I am using VFP8 and executing an SQL statement which is getting the following error. "Connectivity Error: ODBC SQL Server Driver .... Insert Failed because the following SET options have incorrect settings: 'ARITHABORT'" I can copy this exact statement to the Query Analyzer and it runs fine...

The question is why does cr9 behave this way when none of the previous versions did? "Prompt user for NEW values" should not keep old data!

You can always do a subreport that just displays the company name from the database. Just specify the tables and record selection formula to make sure you always get at least one record.

In CR9 I preview a report giving values to the parameters. After the first preview, refresh the report using "Prompt for new values" and only enter values for some of the parameters. On the preview, the parameters that I did not enter new values for still have the values from the first preview...

In CR9 the parameters do not have the same defaults as the earlier versions. For example, a date parameter used to default to the current date even when it was not selected in the prompting window. CR9 only does this if you click on the parameter in the prompting window. Is anyone else...

I can use a winsock control at the application level and receive the event, but when I try to put a Winsock in the session code ( class, module, form, etc.) the event does not fire. How would you refer to the sessionID in the code behind? Is there any way to create a collection of session...

Does anyone know how to raise or pass an event to a specific session. I have a tcpip control that receives network messages and i need to diplay a certain aspx page when a message comes in. Any ideas?????

I am looking for a horizontal menu that will work on a Pocket PC Browser that does not look like hyperlinks.

I have an HttpApplication object oUpdateClient(Winsock control) listening for network messages which fires the NetworkReceive() event. I need to raise an event or something in a specific Session that notifies the user that a certain type of message has arrived. I am using Forms Authentication...

I have a textbox on a report that is set to stretch on overflow. The box grows, but when using a proportional font such as Arial, some of the words disappear when they should be wrapping around to the next line. Example: the word DEMANDING will not show on the report. If i take off the G at...

I found the solution under a different post. The report stores the default printer info from the machine that you made it on. If it is a laser printer(black and white) then it will set a color printer's setting to grayscale when it is run. Here is the solution if anyone else needs it. 1.open...

when printing bitmaps on a foxpro report the application keeps changing the printer setting to grayscale. Does anyone have any ideas on what is causing this? The code that runs the report is as follows: report form formname to printer noconsole nooptimize

The hot fix did the trick. One of the computers was on version 8.0.0.371 and it also had a version 6.? p2sodbc.dll. Thanks

Both computers have SQL 2000, Windows 2000, Crystal Reports 8 Pro. When I try to run the report on both computers, one works fine with the 0/1 comparison and the other errors out and wants a true/false value. Does anyone know if there is a setting in Crystal or a patch that will fix this problem?

Check the Table in SQL and see if it will take NULL values. If not then change your NULL date value to an empty string (VBNULLSTRING) before you pass it in or you may have to specify a default date value if that doesn't work