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...
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.
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...
Well, I had found where someone had a similar problem and claimed the height needed to be at least 34 pixels. So I made mine 37 pixels. However, when I grabbed the bottom of the box on the Edit Box control and pulled it down, it settled at 53 pixels and showed the ScrollBars even in editing the...
This should be simple, but it isn't. I dropped an Edit Box on a form, made a CURSOR Memo Field the control. Size of the Edit Box is about 2 lines. I want the ScrollBars to show, but they just won't, even if ScrollBars = 2. I've played with Themes .T. and Themes .F.
What am I doing wrong? I know...
I need to convert a hex number to a base32 number for creating a QR code to use Google Authenticator (or like) for Multi-Factor Authentication. I've found lots of online tools, but no code I can actually put in my program.
Example: If I get a hex number like this...
Well, duh... That's what I get for staring at the screen and not reading it. One of the methods does require by reference (GetCapabilities). But this does not. What can I say? The end of a long day... but this is exactly an example of clear eyes and multiple eyes looking at the "problem" -- even...
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.