file.to_blob code works in Windows XP, doesn't work in Windows 7

[Ronald Anusiewicz]

Would anyone have any idea why the following code works fine in Windows XP but does not work in Windows 7.
My guess is the file.to_blob is failing so the blob can not be written to the field, statement.

tbl.enter_begin(.t.)
		
dim b as B
b = file.to_blob(vcfilename)
tbl.statement = b
		
tbl.enter_end(.t.)

[Tom Cone Jr]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Good morning, Ron,

Suggest you check

1) contents of 'vcFilename' - is there a path issue here?
2) run script with debug to see what Alpha can tell you.
3) verify that the local machine can "see" the source drive and folder
4) what data type is the source file? BMP's and JPEG's come in different flavors. For example, is the source no longer an 8 bit BMP?

-- tom

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Hi Tom and thank you for your reply.

I'm not sure if this is the issue, but I'm running Win 7 32-bit under Oracle VM VirtualBox. I don't have a Windows 7 machine to test this on. I've spent too much time chasing this so my next step is to install the app on a real win 7 machine and see if it works.

Ron

[MikeC]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Ron,

I have run across this in Win7 due to a permissions issue with writing/changing a file in the root of the OS (C usually) drive and the Programs folder....changing to say any default shared area such as My Documents solved the issue. You didn't mention where you were attempting to do this but figure I'd add this to mix to cover more bases.

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Hi Mike,

Initially I had trouble creating the file. That was because I had the path wrong. I fixed it but I am writing the file to my app->data folder.

program files->a5runtime->app_Data

So creating and writing the file is not my problem. My problem is the reading/changing the file to a blob and then writing the blob to a bitmap field in my table.

Works fine in XP. I get nothing in Win 7.

Ron

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Could someone please look at this attached example. There is either something wrong with my code or I think there is a bug. This code works fine when run with Windows XP SP3. It fails when run with Window 7.

The example has some tables, a report and a script. Run the script. Select the excel file, test.xls which I have included with the database. The script runs slowly, so just wait for the message box to appear when the script is finished. The application mspaint will open and be manipulated by xbasic code. At the end, the script opens a report. I�ve attached a copy of what the report is suppose to look like.

Line 101 of the script has a delay value as part of the script runs as if it is a macro. Depending on the speed of the computer, the delay value may need to be changed. The delay value is in seconds and can be tenths.

dim vnDelay as N
vnDelay = 1.0

I suspect that the problem code is lines 150 through 152.

fn = vcfilename
b = file.to_blob(fn)
tbl.statement = b

It appears that the line b=file.to_blob does not work with Window 7.

Can someone try to verify this for me?

Thanks,

Ron

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Oops,

I forgot to attach the database file.

[DaveM]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

program files->a5runtime->app_Data

that would be: "c:\program files\a5runtime\myapp"

Are we to assume your app resides in program files on your computer? If so, may I suggest you move it to a folder on the root of the drive like: "c:\myapp" ? it may help with your problem.

Microsoft has been working for over ten years to get data out of program files. A couple of times they caused data not to work at all in there and then eased back. I saw most of these first in betas we got and they were changed later in final product, but now they are tying it down pretty hard.

[Mike Wilson]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

I got it to work by replacing:

fn = vcfilename
b = file.to_blob(fn)
tbl.statement = b

with:

tbl.statement.memo_read_from_file(vcfilename)

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Hi Mike,

Thank you for your suggestion. Unfortunately, it does not work on my machine. I've attached my window 7 report. The bitmap field is not being written to. I've tried this on my production application, the test application that I've uploaded to this board and my production application on a window 7 notebook computer. Nothing works.

I wonder if there could be a timing issue????

Your suggestion and my original code work flawlessly with window XP.

Thanks,

Ron

[csda1]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Hi Ron,

I wonder if there could be a timing issue????

While not impossible, I don't think it's very likely it would be a win 7 vs win xp issue. Reading and writing blobs is key code in Alpha that I think would fail long before this issue.

Timing is possible, but I have not looked at your code or application, and still would doubt that as a cause.

Permissions would still be the most likely cause. Try it in safe folders that the current Win User definitely can use (e.g. My Documents). Also, try turning off UAC and see if the problem in Win 7 goes away.

To get the config info and folders of both machines, I suggest you try installing my free CSDA DiagInfo and then compare the environments.

[Ronald Anusiewicz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

I want to apologize for not getting back sooner with the answer to this problem. Unfortunately, my father passed away on January 31st following a 6 week illness and my day to day routine is just now starting to return to normal.

As it turns out, the default file type in Windows XP paint is a BMP file. In Windows 7 the default file in Paint is a PNG file. So even though I was naming the file with a .BMP extension, in reality, the file was a .PNG file. After altering my scripting xbasic to set the File Type to a .BMP file, everything worked fine.

Thank you to all who tried to help me with this problem.

Ron

[Al Buchholz]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Ron

My condolences.

Thanks for the solution.

Hope for better days.

[Mike Wilson]

Re: file.to_blob code works in Windows XP, doesn't work in Windows 7

Ron,
Thank you for sharing your personal moment and all that you certainly bring to our community here. My condolences as well, sir.