On additional odd behavior noticed with the encrypted string .. Actually this is spooky.. is that in an update of multiple fields, the fields that follow the encrypted field are being offset by one field..
Example: For better understand here is the setup.
This particular data is for storing...
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...
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...
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...
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...
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...
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...
I've stepped through the code with the debugger and watched the Alias() which is correctly switching from the table with trigger, to the view that we use to update the SQL table, then back again.
Here is the trigger code. I've left some of the detail- we update some of the empty() date fields...
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 ...
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 ' ...
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...
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...
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.