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!

Register Log in
  • Congratulations derfloh 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. bigbillmac

    OLE and Excel

    Hi Guys, I hope there are some Excel experts out there. I need to create Excel 2000 worksheets from inside a PB App (v10.2) and I thought this would be straightforward!!!! So read the documentation - which makes very little sense. OK let's try another tack. Browse around this here...
  2. bigbillmac

    How do I prevent a dropdown list from displaying

    You can protect it. Bill
  3. bigbillmac

    PB10 and MS SQL Server

    PB 4 - wow? As I remember it was very stable - well 4a was. You can use ODBC with no problems but I would reccommend OLE DB. If you use the db profile painter there is a preview tab which shows you the connection details, eg: SQLCA.DBMS = "OLE DB" SQLCA.LogId = "sa" SQLCA.AutoCommit = False...
  4. bigbillmac

    Need Help Avoiding email challenge using PB 6.5

    It would be a cinch in Java. You could drop files into a directory and get a piece of Java code to do the email. Bill
  5. bigbillmac

    Difference between destroy and destroy()

    Yup, As mbalent says there is no difference between the two in fact there are not two things here at all. Remember you can put brackects around any exprssion you want, so you cold say messageBox( ls_heading, ls_text) or messageBox( (ls_heading), (ls_text)) these are NOT two different forms...
  6. bigbillmac

    PB10 and MS SQL Server

    Yes I noticed a similar post you made some time ago. A while ago I created a new object that was a descendant of the transaction object. In this object I placed my begin/end/test/error check code and used SQL statements as decscribed above (eg Execute Immediate "BEGIN TRANSACTION"; etc)...
  7. bigbillmac

    PB10 and MS SQL Server

    Can anyone help? I have an application that was originally written under PB7. I have now upgraded to PB10, which is infinitely more stable in the development environment - eg I can now actually use the debugger with confidence. However, I have a really serious issue - transaction processing...
  8. bigbillmac

    EBFs

    ...sort of problem. Presumably you cannot even register bugs without a support contract. I upgraded to PB10 from PB7, which was a complete crock of s*&t (ver 7 that is) and Sybase never got the problems of this version running on win2000 sorted out. For a solution you had to upgrade, I am a...
  9. bigbillmac

    EBFs

    Does anyone know how to get EBFs these days? Do I now need a support contract to download EBFs? Even Microsoft provide free bug fixes. Bill
  10. bigbillmac

    project generation error (Link Error)

    Hi, Have a look at the PB7 compile problem thread and this may help. Bill
  11. bigbillmac

    PB7 Compile Problem

    <<Before re-installing PB have you tried uninstalling the existing version of PB.>> I assume you mean the PB10 version? No, I haven't bothererd but I am pretty sure it will work - its basically what I am doing by renaming the c:\program files\sybase directory when I want to run a particular...
  12. bigbillmac

    Multiple DB Connections

    Well you certainly can with some versions, remember this is natural with something like MS SQL Server. In the manual for SQL Anywhere 5, there is a section (chap 28) about starting the database as an NT service and within this section it tells you how to start multiple databases. "To start a...
  13. bigbillmac

    PB7 Compile Problem

    No, I manually rename one of them back to \program files\sybase before I run - so I can only run one of them at a time. I tried installing PB7 in another directory and this was fine until I applied the EBF, which wanted to put most of its files in: \program files\sybase - irregardless of where...
  14. bigbillmac

    Multiple DB Connections

    This may be of no use because I haven't used the Sybase db (I assume this is ASA from the prog names) for quite some time now. But anyway. With some earlyish versions of the db server you could open more than one database in one instance of the server - has this changed? Bill
  15. bigbillmac

    PB7 Compile Problem

    Hi A0C61ZZ, Let me bring you up to date! I uninstalled PB7 and renamed the \program files\sybase directory to \program files\sybase_10. I then reinstalled PB7 and lo and behold it worked. I then applied the final EBF for PB7 and this was all fine and dandy, I thought I had cracked it. So I...
  16. bigbillmac

    distinct non visual objects' type

    Is good food descended from food? If so I am not sure you can overload a fucntion with a descendant - have to say I cannot remember ever having tried it. I assume that you have dived in and given it a go and it told you to sod off? Bill
  17. bigbillmac

    Compute field formatting for mailing address in DW

    Well of course you will get a blank line because the carriage return/line feed pair are not part of the test they are always included: If(IsNull(addl_owner_name_suffix ) or Len(Trim(addl_owner_name_suffix )) = 0 ,'', ' ' + Trim(addl_owner_name_suffix) + '.') + '~r~n' + In another line (ie one...
  18. bigbillmac

    PB7 Compile Problem

    I am running PB7 in windows 2000 and it has compiled programs in the past OK. BTW compilation is to machine code! Now all of a sudden it has stopped compiling and gives the following error message: Codegen compilation error, see file 'C:\DOCUME~1\bill\LOCALS~1\Temp\new_main.log'. When you look...
  19. bigbillmac

    Upgrade from ver 7.0

    Hi, Question for mbalent, I hope you are still watching this. I have now upgraded to version 10.0 - they are still not shipping 10.2. You mention in one of your posts that we now have to use OLE DB to connect to MS SQL Server. Can you tell me what I need to do to connect via OLE DB, or point...
  20. bigbillmac

    Upgrade from ver 7.0

    Thanks for the info! From your posts can I take it that you are a MS SQL Server user too? If so can you tell me how to access image fields please. Bill

Part and Inventory Search

Back
Top