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

  • Users: nbrk
  • Order by date
  1. nbrk

    Version Management

    Kurt thanks for your input Nbrk
  2. nbrk

    Version Management

    Kurt, Thanks for the bad news. There has to be some kind of tool out there that interfaces entrprise to a version manager. Surely?? Nbrk
  3. nbrk

    Version Management

    Sorry to say but we have Crystal Enterprise..any ideas?
  4. nbrk

    Version Management

    Dave, Thanks for your quick response. Have you heard of an interface into PVCS that integrates into Crystal? Nick
  5. nbrk

    Version Management

    Hi all, Does anyone use a version manager to source control their crystal reports? If so, how? I have heard through the grapevine that there is a 3rd party solution for versioning crytal reports...any one else heard of this? Thanks in advance
  6. nbrk

    transfer sybase table data into text format

    You are either going to have to use the "-c" option or create a format file. Good luck nberk
  7. nbrk

    [color red]How to encrypt/decrypt in sybase ??

    I have one question, why would you want to store decrypted passwords in the database? I have seen it done where the client application encrypts the password (through an API call) and then passes the encrypted password to the database that does a compare on the encrypted data for the match...
  8. nbrk

    What are the system tables / fields that hold record counts

    obviously vharchar is varchar......
  9. nbrk

    What are the system tables / fields that hold record counts

    Try this, remember this is a sproc, so create this first create procedure tabcount @tablename vharchar(64) AS select a.name, rowcnt(b.doampg) from sysobjects a, sysindexes b where a.id = b.id and a.name like @tablename after that you can really use this to your adavntage, by executing...
  10. nbrk

    How To Alter Identity Column

    look at: set identity_insert <table_name> on It is in the Transact-SQL volume 1 manual Good Luck
  11. nbrk

    dropdownlistbox

    If this is a single select dropdownlistbox then you can use the index... If index = 1 then If multiselect you are going to have to loop through and check the state FOR i = 1 to lb_value.TotalItems() IF lb_value.State(i) = 1 THEN END IF NEXT Good luck
  12. nbrk

    Most recent record

    You could try something like this....it may need some tweaking select name, code, start_date, end_date, class from test_table a where class = 'M' and convert(smalldatetime, start_date) < getdate() and not exists (select 1 from test_table b where a.name = b.name and a.code = b.code and...
  13. nbrk

    stored procedure submitting as a database job

    don't forget you could do this in isql with the -i option
  14. nbrk

    stored procedure submitting as a database job

    This is pretty crude but you could do this in an ISQL script Label: execute <stored procedure> waitfor delay &quot;01:00:00&quot; goto Label As I said this is pretty basic...hope it helps a little Good Luck
  15. nbrk

    stored procedure submitting as a database job

    Ok, I am a little unsure of exactly you want...would the &quot;waitfor&quot; SQL statement be the kind of thing you are looking for? Good Luck
  16. nbrk

    stored procedure submitting as a database job

    do you want to do this through UNIX or windows? Good Luck
  17. nbrk

    OLE automation in excel

    Here is a quick example that opens an XLS file and saves it as a CSV file...Good Luck OLEObject ole_object // Create or &quot;Instantiate&quot; the ole_object variable ole_object = CREATE OLEObject IF ole_object.ConnectToNewObject(&quot;excel.application.8&quot;) = 0 THEN...
  18. nbrk

    Is there a function that returns the path of my executable?

    Why not set a global variable in the application open event, then you can reference that each time you need to find your ini file Good Luck
  19. nbrk

    Find DataWindow Method Problem

    if gs_inst_tag is character based I believe you would need this ls_find_string = &quot;inst_tag = '&quot; + gs_inst_tage + &quot;'&quot; Good Luck
  20. nbrk

    How to set the column width when query

    or you could do select cust_name=customer_full_long_name That works too

Part and Inventory Search

Back
Top