Search results for query: *

Thanks to all. Always impressed and grateful for the help and knowledge of the VFP community.

Many thanks. Guess I'm used to just checking everything's good with the tableupdate(.T.) command. Probably most of the updates occur with the select command anyway so this never came up.

Must have used the sql insert command thousands of times but clearly doing something silly. Inserting a record with 6 fields but the _tally kept showing 0. Decided to just add one field and still no luck. If I create a new table and use the same code it works fine. If I use the append blank...

thx for the two responses. couldn't make the 'app not a table' error disappear even though everything in the project looked to have the proper extension. Decided to go back to an earlier version and rework from there. Suspect the other area was down to a bit of carelessness by me. Seems I...

Have been working on updating a system that has worked fine for years. Have recompiled my test app dozens if not hundreds of times over the past few months with no real glitches. This morning I recompiled and got an error message saying that my app is not a table. I removed the program that...

thanks to all--it was just a vanilla 97-03 format and I'm going with the hint of just turning the data into csv format. Seems to work fine.

I've imported excel xls files dozens of times into vfp but for some reason having trouble. Doesn't matter if I use a wizard or just a command. Also is happening on two machines--one at work gets an error message saying it can't write to a temporary file. At home it just shuts VFP down saying...

Craig/Mike Out of my control--help much appreciated rgw

Have a VFP9 exe with a handful of machines all running XP. No problems but will be adding some Vista machines. Are there any things to look out for when running the InstallShield routine for a mixed operating system environment? Any comments much appreciated rgw

Mike Believe I solved it--had a problem with 22 of 15,000 cards. If the encrypted value had a space at the end I seemed to run into problems--probably a bit too much of the alltrim. I didn't use the chr(0) padding suggested by Craig but rather stored the length of the original encrypted value...

Mike thanks for the links. My triumph was short lived: i'm working exclusively on credit cards and get 99% of them to encrypt/decrypt perfectly using the more secure methods shown in Craig Boyd's update of August 6, 2007. I think it's a problem with the string length. rgw

Shouldn't have been lazy execting t to be harder than anticipated. Many thanks Sweet Potato. rgw

Mike Many thanks. As very much of a non-technical type find it a bit frustrtating when the simple stuff doesn't work. I assume the problem is that there is a problem with doing the encryption in blocks--the 'streaming' code seems to work fine but it looks rather weak when you look at the...

Did some work last year converting credit card data into an encrypted field using the native VFP _crypt.vcx. Got sidetracked onto something else and have only just picked up the test data again. Have a file with thousands of cards and I've found that although the vast majority...

Seems that I forgot to copy the wincrypt.h file over to the user directory. All well at the moment.

I thought the Vista problem was solved as I was able to drop the class onto the form but when I go to compile the application I get an error telling me it can't find the wincrypt.h file. Any advice much appreciated. RGW

Thank you all for your very helpful comments on encryption--it all seems to work very well using the _crypt.vcx. Zips through thousands of records encrypting/decrypting as required on 2000 or XP machines but... I have a shiny new laptop running Vista and thought I'd try it out on the routine...

Ralph I believe it was. I didn't have any trouble when it was machine specific--it encrypted/decrypted many thousands of records without a glitch. But it does make you wonder. rgw

Mike I dug up the original article and there is a comment in the code: "the default provider in Windows 2000 is different than the default provider in Windows XP. Your data may encrtypt/decrypt differently depending on the provider". The author used Windows 2000. I'll see what happens at...

White 605 The XP and the Vista machines (both at home) generate the same result. The 2000 machine (at work) generates a different result. They run exactly the same code with the same key. rgw