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 Chriss Miller 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: *

  • Users: snowcold
  • Order by date
  1. snowcold

    Deploying VB app with a Crystal Report question.

    Thanks for that info. But can the component be added to the wizard once to create this package and then is it in the package for good? or would I need to purchase various copies of this component for each package I distribute? thanks alot!!!
  2. snowcold

    Deploying VB app with a Crystal Report question.

    I'm trying to create a small app that will allow users to print out a task list report, a custom Crystal Report. If I deploy this app to various users, what components from CR will each user need on their machine to sucessfully view these reports? Obviously I am concerned about licensing from...
  3. snowcold

    Puzzled by SUBSTR....

    Well. I learn something new everyday... Thanks to all for the help.
  4. snowcold

    Puzzled by SUBSTR....

    The result of the query select * from nls_database_parameters where parameter like 'NLS_CHAR%'; produces: PARAMETER VALUE ---------------- ----------- NLS_CHARACTERSET UTF8
  5. snowcold

    Puzzled by SUBSTR....

    If it will help, I will post the view tomorrow morning Thanks!!
  6. snowcold

    Puzzled by SUBSTR....

    Yes it is CR. I only typed the create statement half-heartily, not my actual view create statement.
  7. snowcold

    Puzzled by SUBSTR....

    Ok, I'm sorry. I was using the word BLOB to describe my large datafield, which is of type varchar2(4000), this is due to my lack of knowledge of an actual BLOB and because my reporting tool is telling me that my field, which is a varchar2(4000) is a BLOB, because it's larger than 256. So, yes...
  8. snowcold

    Report setup question.

    In the past, I asked how to use a BLOB as a formula and found out that you can use a BLOB in a formula with the isNull function to determine if the BLOB was null and if so, print an "N/A". My question is: Since I can actually do this calculation on the database with a nvl() function, should I...
  9. snowcold

    Puzzled by SUBSTR....

    This does not appear to have done anything. Does it matter that the original is defined as varchar2(4000)? I've got: DBMS_LOB.SUBSTR(table3.field3,256,1) as VALUE It's now displaying the column as size 4000? thanks
  10. snowcold

    Puzzled by SUBSTR....

    OK, here is my issue: Using an Oracle 9.1 database with some views. One field in this view is a BLOB(4000). I have a reporting tool that cannot use blobs in a formula. I figured that I would use SUBSTR to return only the first 256 characters for this field. When I see the final result, it does...
  11. snowcold

    How to use a blob field in a formula.

    Sorry, I searched the FAQ after....I really feel dumb. I really do. I found this FAQ in #4 faq149-276
  12. snowcold

    How to use a blob field in a formula.

    Hello all, I am using CR 8.0 and I am attempting to create a formula where I check to see if a datafield is null or not. When I insert this datafield, I get the error: Blob field or memo field cannot be used in formula. This particular field is set to varchar2(4000). Since this is already a...
  13. snowcold

    Great tip on having Subreports print headers over multiple pages.

    I let this one slip, I just thanked kskid for this but I use this tip frequently and share it to many. thread149-1048360
  14. snowcold

    How do I recompile an OCX?

    to BobRodes.. That is exactly what happened...I was given the .vbp and all related files.. thanks
  15. snowcold

    Planar touchscreen issue.

    Hello all, I've got this situation. We purchased a Planar PT191MU touchscreen monitor, which happens to be capacitive type touchscreen. The issue is that a capacitive type monitor does not work with Vinyl gloves and we cannot find any other device besides a finger, due to absorbing electricity...
  16. snowcold

    How do I recompile an OCX?

    Broken link. Doing a search but to no luck yet. I'll keep everyone posted.
  17. snowcold

    How do I recompile an OCX?

    Are you ready for a silly question? I've received an OCX (with the code) from the developer. I usually debug the app if we have issues in order to troubleshoot...but now I am being instructed to recompile the OCX. How do I do that in VB 6.0? Thanks!!!
  18. snowcold

    Hyper Threading vs. Dual Core

    I think I know the difference...HT is tricking the apps in thinking there are 2 CPUs where DualCore is actually 2 integrated CPUs.... Anyways, I'm looking into purchasing a new CPU and have found the Intel Pentium D 805 Smithfield..this has a Dual core but no HT for 95$. AMD has a dual core...
  19. snowcold

    Motherboard/CPU advice

    Anyone provide info on the different boards? ASUS, gigabyte??? any opinionns? thanks
  20. snowcold

    Motherboard/CPU advice

    I'm definityly open to ideas!!!! Thanks!

Part and Inventory Search

Back
Top