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 derfloh 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: hjohnson
  • Order by date
  1. hjohnson

    Sqlexec() Updating SQL with an Encrypted string.

    ...are '..., Cardnumber, Exp_date, Card_name, Card_addr, card_city, etc..) After the update to sql I View the data using Query Analyzer (Select * from ..) and noticed that the Exp_date was empty, but the card_name field appears to contain '12/07', the expected value for exp_date. Card_name...
  2. hjohnson

    Sqlexec() Updating SQL with an Encrypted string.

    Thanks for the quite replies. The Encrypted string does not contain any apostrophes, I was hopeful for this as it would have been a rather simple change. I did try the using the parameters and it almost worked... At least I didn't get the error. The problem appears to be one of the Ascii in...
  3. hjohnson

    Sqlexec() Updating SQL with an Encrypted string.

    I'm sure the answer is staring me in the face, but I'm having an issue when trying to update a field in a SQL table with a string that has been encrypted. I get a message saying -- Unclosed quotation mark before the character string 'Ò«·'. What I find odd is that I also have view doing the...
  4. hjohnson

    Windows Installer rears its ugly head

    One additional (hopefully related) question here, If not I should probably start a new thread. Does this apply to registering of all OCXs, or just a few. I've just added to our application the use MSCOMM32.ocx which is intended to read the weight from a scale. In development it worked...
  5. hjohnson

    Save Printer Environment

    Thanks for the reminder on the orientation and for information on the registry settings. I also have a few reports with custom papersizes which will still needs to be kept. As for the 'Save Enviroment' flag... I believe part of my confusion was that I had assumed that with the default...
  6. hjohnson

    Save Printer Environment

    Does anyone know where in the .frx that VFP stores the 'Save Printer Environment' flag. I'm upgrading to VFP9 from an earlier version and would normally just hack the frx when needed. I'd like to put something together to go through the entire project and strip the tag information from the...
  7. hjohnson

    Dilemma with Set Relation to table with Trigger

    Ramani, The requery() is not used on any of the tables involved in the set relation. The relation ship is still intact (based on the data environment when issueing a 'set'). It's almost as if they are not long in sync. It's kinda hard to example and visualize what is happening. I've trien...
  8. hjohnson

    Dilemma with Set Relation to table with Trigger

    ...code. I've left some of the detail- we update some of the empty() date fields with null as we don't use null date in VFP app. Thanks- Hal ***-------------------------------------------------- Function CustTrigger(tcTriggerType) && Added in case Cursor is built form array created by...
  9. hjohnson

    Dilemma with Set Relation to table with Trigger

    We have just recently moved some free tables into a DBC to take advantage of the triggers to write data into a SQL-server table. The triggers themselves are working fine, however the issue we have come up against is that quite often we are making updates using a Set relation to.. and Scan ...
  10. hjohnson

    Using Popups on Forms

    I apologize, but guess I wasn't explaining this very clearly, but That is exactly what I'm trying to do. I would like the popup to alway be tied to the button positions, but using the this.top and this.left when defining the popup does not work. When defining the popup I've been using ' ...
  11. hjohnson

    Using Popups on Forms

    If moving the mouse would work, I'd settle for that, but it won't. I wan the popup to always be in the same position relative to the command button that invokes it. I can't use this.top/left because those points are relative to the the buttons position on the form and can vary depending the...
  12. hjohnson

    Using Popups on Forms

    I'm probably missing something rather simple. but I'm tring to use a popup on a form when a button's Click event is triggered. **** Release POPUP ButtonPop EXTENDED Define POPUP ButtonPop Title 'Imports' SHORTCUT RELATIVE FROM MROW(), MCOL() **** The mrow() and Mcol() work just fine when...
  13. hjohnson

    Form loads/displays slowly

    I just recently ran into a issue on a form that displays very slowly. By that I mean when the form is executed, the border visible, but everthing within the border is white. After about 4-10 seconds (but sometimes as long as a minute) then rest of the form appears. This occurs in both code and...
  14. hjohnson

    Performance issue opening files.

    Thanks for all the comments. To answer some of the questions: The table is a free table- no triggers or filters. There are 11 fields and only 1 index which is Compound on a char field + dtos(date fields). The whole process takes place in a procedure to which is passed 5 of the 11 fields...
  15. hjohnson

    Performance issue opening files.

    I'm reviewing some code in our app that occasionally has some complaints from users about being slow. I've narrowed the problem down to a portion of code that opens a file, appends a new record, then closes the file. My question is, does anyone know or has anyone experimented with what happens...
  16. hjohnson

    Change Connection for a View

    The solution that I came up with is to use a "template" DBC. When users start the app, this template dbc is copied to a local folder, then customizing some of the settings used in apps, such as connections or views. This lets setting to be adjust without affecting all users. Hal
  17. hjohnson

    Calling report in Another App

    Thanks for your help. I think I will move more towards having it in an app rather than having the reports in the path. Thanks again
  18. hjohnson

    Calling report in Another App

    Thanks, Does the Report app have to be included in the procedural file somehow. How does the calling app know that the report form is in another app?
  19. hjohnson

    Calling report in Another App

    If this is just wishful thinking you can tell me I'm crazy, I can take it. But I think I remember reading somewhere about a way of compiling an App that is just report forms and being able to call from another App, but I can't seem to find it now. What I've got is a application running on the...
  20. hjohnson

    Automating Excel using UNC path.

    I think I may have figured out part of the problem- I'm using sys(5)+sys(2003) to setup full path of the file. For some reason sys(2003) is returning an Empty string. so instead of getting "\\Documents\newfile.xls", all I am getting is "\\newfile.xls" As soon I can solve that it looks like...

Part and Inventory Search

Back
Top