Recent content by CBellucci

Much easier than what I did. And it works. Thanks, everyone!

Okay, as a result of both of your posts, I figure it out. (I think. It's working, that's all I care at 5pm on Friday.) I ended up creating a cursor with one field of type W (blob). Here's the new code: Create Cursor SigTmp(Signature W) Select SigTmp Append Blank Store Cast(FileToStr(Pic.bmp)...

I have a BMP Image I want to insert into an SQL varbinary(max) field. I came up with this code: Store Cast(FileToStr(Pic.bmp) As Blob) To jcBMP CursorSetProp('MapBinary', .T., 0) SQL_Status = SQLExec(SQL_Connection, "INSERT Into SFile (BMPField) Values (' + M.jcBMP + "');") When I execute...

Yep, I read all that. And it makes me wonder: Is it possible that the field being named Image (Image is the field name, not the type) is causing a problem since it mimics a Data Type? ETA: Thank you, Chris! I successfully retrieved the data using: CursorSetProp('MapBinary', .T., 0) SELECT...

This is a two-part question. And I know it has been answered, but I can't replicate successful results with the answers I'm finding, so I am throwing out all I know to beg for help. I am connecting to a MS SQL Server table containing an ID value and field named Image that is a varbinary(max)...

I get to answer my own question! Turns out, Mr. Neklioudov has released a version of GridHighlighter since the version I have been using. I downloaded it and found where he had previously identified the problem and coded a fix for it. From the README: v. 3.7.5 06/14/2001. Increased...

I have been using Nick Neklioudov's GridHighlighter Class for a very long time. Within the last couple of years, however, users have reported getting random (I know not really random, but I can't deduce a pattern) DynamicForeColor errors when the grids using the class are in the screen. Has...

Yep, that's what I ended up doing. Thanks!

We have multiple users printing a report (actually a label) quite possibly at the same time. As a result, occasionally a "File Access Denied" error occurs on the file. The users all access the same file and the executable through a networked drive. Is there a way to "set" the file to keep from...

Here's a screen shot of my report designer: The last problem I had was that the detail gray-bar was always printing. Turns out one of my shaded boxes had slipped behind a Group Footer indicator. Lots of lessons learned with this report! (In fact, I have another I need to de-columnize.) Again...

The comment right about yours, Olaf? I said that after I got all the columns split up in the data, but not on the report. (One column for the report.) I've got it, it's all working. One of the shading boxes got hidden in the Report Designer. I had to go looking for it in the FRX. A future tip...

Yeah, got my report split up into columns in the output table. Only one line/one column per data line now. Still having problems with the report leaving space for the Memo field even if it's empty.

If I don't have columns, how do I present the data across the page? Any suggestions? Each record has one piece of data.

There are 6 columns across the page. The Group Headers and Footers are printed across more than one column. The Memo Field is the DComment in italics, second line in the 2nd Group Header. The DComment line is set to Float and Stretch (it is doing neither).

I have not done a lot of multi-column reports that aren't labels, so I could use a bit of help. Have a report that is 6 columns. Columnar data is printing correctly. On this report I have Group Headers and Footers that go completely across the page. The Header is one line and could possibly be...