Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CBellucci

    Inserting Image into varbinary(max) field

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

    Inserting Image into varbinary(max) field

    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)...
  3. CBellucci

    Inserting Image into varbinary(max) field

    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...
  4. CBellucci

    Retrieving Images (varbinary(max)) from MS SQL Server

    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...
  5. CBellucci

    Retrieving Images (varbinary(max)) from MS SQL Server

    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)...
  6. CBellucci

    Nick Neklioudov's GridHighlighter Class (oldie but a goodie)

    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...
  7. CBellucci

    Nick Neklioudov's GridHighlighter Class (oldie but a goodie)

    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...
  8. CBellucci

    File Access Denied on Report (Label) File

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

    File Access Denied on Report (Label) File

    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...
  10. CBellucci

    VFP9 Report Problems with Multi-Columns, Memo Field

    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...
  11. CBellucci

    VFP9 Report Problems with Multi-Columns, Memo Field

    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...
  12. CBellucci

    VFP9 Report Problems with Multi-Columns, Memo Field

    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.
  13. CBellucci

    VFP9 Report Problems with Multi-Columns, Memo Field

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

    VFP9 Report Problems with Multi-Columns, Memo Field

    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).
  15. CBellucci

    VFP9 Report Problems with Multi-Columns, Memo Field

    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...
  16. CBellucci

    VFP 9 Edit Box ScrollBars not showing up

    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...
  17. CBellucci

    VFP 9 Edit Box ScrollBars not showing up

    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...
  18. CBellucci

    TOTP seeds: Converting Hex to Base32

    Yep, found that. Was really looking for "real code" to do it.
  19. CBellucci

    TOTP seeds: Converting Hex to Base32

    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...
  20. CBellucci

    VB UINT16 and FIX32

    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...

Part and Inventory Search

Back
Top