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!

Register Log in
  • Congratulations strongm 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: *

  1. tcorrigan

    Headers from FrontPage

    Yes, that's apparently the only choice.
  2. tcorrigan

    Headers from FrontPage

    This looks like it supports the static <META> tags but how about the case where I need to generate the <META> tag content from the results of a database query?
  3. tcorrigan

    Headers from FrontPage

    No I mean the data in the <HEAD> section of the page. Specifically 1) I want to add static <META> tags and then 2) add dynamic <META> tags based on data fetched from the database based on info in the query string. An alternative to the <META> tags is to create a dynamic <TITLE> based on...
  4. tcorrigan

    Headers from FrontPage

    Is there any way to create HTML headers through FrontPage?
  5. tcorrigan

    Keypress on form with CR ViewerControl

    The problem is that the user doesn't want to use the mouse, he wants to use the keyboard.
  6. tcorrigan

    Keypress on form with CR ViewerControl

    I am trying to set things up so that the user can use the PageUp and PageDown keys when viewing a report in the CR Viewer Control in a VB app. However, even though KeyPreview is set to true in the underlying form, the form's KeyDown event isn't being fired. Does anybody know how to capture the...
  7. tcorrigan

    DB Maintenance Plan Failing

    Try this if you're not doing so already. Back up the system databases (master, msdb and model) in a single step by themselves and then in a subsequent step back up the rest of your databases.
  8. tcorrigan

    Run SQL Command limit in Visual Foxpro 6.0

    Try this: lcFieldx = space(200) SQLExec(sqldatabasehandle, &quot;insert (fieldx) values (?lcFieldx)&quot;) Foxpro will automatically fill in parameters in a SQL statement. A parameter is any label with a ? in front of it, like ?lcFieldx, and if there is already a variable named with that...
  9. tcorrigan

    VFP ODBC driver

    I don't have an answer for you with regards VFP and ODBC, but I can tell you that Visual FoxPro 7 (the latest version that just came out a few months ago) includes a VFP OLE driver. Given that you should be able to use ADO and VC++ to access your data.
  10. tcorrigan

    Mystery Stored Procedure Failure

    Thanks for the response. Tom
  11. tcorrigan

    Mystery Stored Procedure Failure

    Hi Terry, Thanks for your response. I do have some questions, however. As written it appears that your procedure would remain in an infinite loop (while 1=1 ... end). My take on the subject is that you want to keep the loop but use a check for @rowcount = 1 as the exit condition, but maybe...
  12. tcorrigan

    Mystery Stored Procedure Failure

    I use the following stored procedure to assign the next invoice number in my applcation: CREATE PROCEDURE InvoiceNewInvoice @nextinv int output AS set nocount on while 1=1 begin select @nextinv = nextinv from system where pkey = 1 update system set...
  13. tcorrigan

    BAK and TRN Files not being deleted

    One of my clients is running SQL2K with a database maintenance plan that runs daily specifying that the data backup (.BAK) files and transaction log backup (.TRN) be deleted after 1 week. The problem is that they are just piling up and not being deleted. Anybody have any insights as to why this...
  14. tcorrigan

    &quot;Suppress Printing If No Records&quot; Doesn't

    To Jazerr: I added the running total field as you suggested but that didn't solve the problem. To IdoMillet: There is no New Page Before or New Page After specified in any group. I've also gone through and checked Suppress Blank Section in every section of the report, but that still doesn't...
  15. tcorrigan

    &quot;Suppress Printing If No Records&quot; Doesn't

    I haven't been able to try yet what you suggest, but I have used a suppression formula like this: formula = IsNull({Orders.Orderno}) which I believe is functionally equivalent to what you suggest since if there no records the Orderno field should be null. I think we might be off the track...
  16. tcorrigan

    &quot;Suppress Printing If No Records&quot; Doesn't

    Yes, just a completely blank page.
  17. tcorrigan

    &quot;Suppress Printing If No Records&quot; Doesn't

    I tried all kinds of things with regards to suppressing sections but that didn't solve anything.
  18. tcorrigan

    &quot;Suppress Printing If No Records&quot; Doesn't

    Using CR 8.5 and the RDC I'm printing a report based on data generated by a SQL Server stored procedure. Sometimes there is no data but Crystal still prints a blank page, even tho Suppress Printing If No Records is selected in the report options. Does anybody have any insights as to why this...
  19. tcorrigan

    Create a report based on the results of a (SQL) Stored Procedure

    It wasn't but it is now. However I still get the same error message. Tom
  20. tcorrigan

    Create a report based on the results of a (SQL) Stored Procedure

    I want to create a report in an Access 2000 ADP project that is based on the results of a stored procedure. The stored procedure name appears in the RecordSource dropdown list, but when I select it I get the error message &quot;Microsoft Access can't find the object FamilyBarCodes&quot;. I...

Part and Inventory Search

Back
Top