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 bkrike 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: TheBlueDog
  • Content: Threads
  • Order by date
  1. TheBlueDog

    Encrypt Stored Procs, Views, Etc. - hiding from other DBA

    I have a database which I typically securely host on my own servers, but I am in the position of having to install it now on someone else's SQL Server. My preference is to completely hide the schema from prying eyes. I know in older versions of SQL at least you could encrypt all your procs...
  2. TheBlueDog

    need TOP record value in a FUNCTION

    I am trying to get a single integer value (primary key/identity val from a table) returned in a function. This function queries a table to find the 1 or more records which match criteria I pass in, and the key value I need returned is the key from the very first record in the recordset as I...
  3. TheBlueDog

    Update one input with parsed value from select list?

    I don't know any javascript, but I am wondering if anyone has any basic code they can show me to help me accomplish a task on a webpage I would like to create (all I really know is databases)... I have a select list with a key value in the value field (which I must keep there to send to my...
  4. TheBlueDog

    Link 2 drop down lists on one form, limit list

    I am programming in CF and have 2 drop down lists on one page which both contain I pull from an every-changing database. Although drop down list 1 is pretty small, drop down list 2 is very large and I would like to limit the contents of this long list based on what the user chooses for drop...
  5. TheBlueDog

    Interface getting wrong key back after some trigger-launched inserts

    Desperate for some keen advice here. I have an Access 2000 front end connecting via ODBC to a SQL 2K server, which controls all the logic (I will be transitioning to a new interface, so all logic needs to stay on the server). I am inserting rows on a multi-row form into table A. Table A is a...
  6. TheBlueDog

    Interface getting wrong key back after some trigger-launched inserts

    Desperate for some keen advice here. I have an Access 2000 front end connecting via ODBC to a SQL 2K server, which controls all the logic (I will be transitioning to a new interface, so all logic needs to stay on the server). I am inserting rows on a multi-row form into table A. Table A is a...
  7. TheBlueDog

    Getting wrong key back after some trigger inserts (MSSQL backend)

    Desperate for some keen advice here. I am inserting rows on a multi-row form into table A. Table A is a SQL table which then either inserts a row into Table B or updates an existing row in Table B. An insert/update trigger on Table A manages this process. Unfortunately, when the trigger must...
  8. TheBlueDog

    Can't create and then use new passthrough in same function

    I'm trying in Access 2000 to create a SQL passthrough query and then use that new passthrough query as a form's recordsource in a single function. This worked in Access 97 but the same code won't in 2000 (WAH!!) - it's like the query isn't getting fully created in time to be used as a...

Part and Inventory Search

Back
Top