Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jlbsloan
  • Content: Threads
  • Order by date
  1. jlbsloan

    SQL passthrough getting ARITHABORT error

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

    CR9 "Prompt For New Values" does not clear the parameters.

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

    CR9 Date Parameters do not default to current date unless selected.

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

    Raise an event from application level into a 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?????
  5. jlbsloan

    Anyone have a Menu that works on a Pocket PC Browser?

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

    How to pass an event from an application object to a certain session.

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

    Wordwrap in report making words disappear w/ Proportional font

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

    Printer keeps defaulting to grayscale.

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

    SQL bit field = 0/1 on one machine and true/false on another?

    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?
  10. jlbsloan

    Distributing VB program that automates Access

    I am trying to distribute a VB aplication that uses an Access object to automate the import of a text file into an Access DB. I want to be able to run this on a machine that does not have access installed on it. If I run the Package and Deployment wizard I get "MSACC9.olb is missing the...
  11. jlbsloan

    Real Data types not equal to each other when they look the same.

    When looking at two different SQL tables that have "Incident_Index" fields which are real data type precision 24, a record will appear to have the same values in this field in both tables yet somehow they are not the same. In my foxpro application it will not recognize these as the...
  12. jlbsloan

    Using a config file and SQL tables as data sources.

    I am trying to write a report in CR 8.0 that will go out to several companies. I want to put the company name in the report title; however, it is only stored in a config("config.ini") file. The rest of the data is in a SQL database. Does anyone know a way to retrieve the company name...
  13. jlbsloan

    Grouping on a value that may exist in 3 different fields.

    I have a report that deals with phone calls and the database has a call number and 3 different fields of operator1, operator2, and operator3. I need to be able to group the calls by operator. How can I make the call show up in the operators group whether they were the 1st, 2nd, or 3rd operator...
  14. jlbsloan

    Reading X,Y coords from table and determining what region on a map.

    Can anyone point me in the right direction? I am trying to read X and Y coordinates stored in a SQL table and determine what region that they would be in on a MapInfo map. I need to filter so that only points from the table that are in a specified region on the map are included in the results. I...
  15. jlbsloan

    Incompatabilities between CR8.0 and CR5.0 Preview control.

    Does anyone know of a resource that will tell me the things in CR 8.0 that I can not use in a CR 5.0 preview control in an application. I am having trouble with any type of looping structure and multiple value parameters. The report works fine in CR 8.0 but CR 5.0 gives an error on the formula...
  16. jlbsloan

    Changed database and report doesn't work.

    I have Crystal reports 8. I have 2 SQL databases that are identical in structure, just have different names and data on the same server. The report works fine on one and when I either set the location of the tables or change the database driver the report acts like it locks up. I have 3...
  17. jlbsloan

    Loading default values into a parameter at runtime from a data base fi

    Is it possible to load defaults into a parameter (at runtime from a data base field) for the user to select from. Thanks for any thoughts on this.
  18. jlbsloan

    Renaming a subreport

    How do you rename a subreport after it is already created?(Crystal reports Ver. 8)

Part and Inventory Search

Back
Top