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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tcorrigan

  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...
See more

Part and Inventory Search

Back
Top