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

    SQL Trigger

    Yksvaan, Excellent, thank you so much for that! Have squeezed it into my trigger and works perfectly. Regards Jamie
  2. Gaylord

    SQL Trigger

    Hi, I am trying to write a trigger, whereby it gets todays date, which is pretty easy, but I also want the date of the monday of that week... So if I inserted some thing tomorrow I want the date in the date column as 6/12/04, and a weekstarted column with 5/12/04... I have no idea how to go...
  3. Gaylord

    Date calculations

    Hi, I am having a few problems with the formatting of dates using a SQL trigger.... I get todays date, no problem, then I add a day to it, try and format it and it comes across in a totally different format, for example... I want the format to be 12/12/2004 and it gives me Dec 12 2004 12:00am...
  4. Gaylord

    Refresh list!

    Hi, I have a form that requires the user to import some data from an oracle database into an access table. This is controlled by a simple form that when I press "import" it pulls all the required information from the database accross. This bit works fine.... However the next step requires...
  5. Gaylord

    Oracle Error

    Hi, I am using Access to format some information before inserting it into an Oracale Lite database. I can quite happily access the information, format it, but when I try and insert or update it back into the database I get the following message. Run-time error '-2147467259 (80004005)...
  6. Gaylord

    Dynamic Dropdown Lists

    ...Dim SQL_FETCH_NEXT As Long Function GetDSNsAndDrivers() SQL_FETCH_NEXT = 1 SQL_SUCCESS = 0 Dim i As Integer Dim sDSNItem As String * 1024 Dim sDRVItem As String * 1024 Dim sDSN As String Dim sDRV As String Dim iDSNLen As Integer Dim iDRVLen As Integer...
  7. Gaylord

    Creating Oracle DSN's Programatically

    Thanks for this. I'll give it a try. Hopefully this is the light at the end of the tunnel! Regards Jamie
  8. Gaylord

    Query problem

    That's great! Thanks so much for that. Was luck that I spotted it.. Quite an unusual name, but better done now. Cheers Jamie
  9. Gaylord

    Query problem

    Hi, I am trying to insert the following into a table, which is working fine..... Update = "INSERT INTO TEMP (ID, POLLING_NUMBER, NAME) " Update = Update & "VALUES (" & curRecord & ", " & rt.Fields("POLLING_NUMBER").Value & ", '" & formatName & "');" But when I try and insert an individual...
  10. Gaylord

    Creating Oracle DSN's Programatically

    Ahh, Possibly not..... What I am trying to do is to create the ODBC DSN links to the databases through VB. Now, I can do this quite easily for SQL server databases, but unfortunately this time I have been given an Oracle database(s) to work with. I think it should be quite simple, but I...
  11. Gaylord

    Creating Oracle DSN's Programatically

    Ahh ok. Not to go into two much information, but each database exists uniquely as a district or smaller region. These are then queried and updated individually. The data structure is identical and really only the amount of data is different, depening on the region, eg a borough of London...
  12. Gaylord

    Creating Oracle DSN's Programatically

    Hi, Does anyone know how to create a DSN for Oracle programatically using VB? I have found code snipets for SQL server, but nothing so far for Oracle.... The reason for doing this is that I have (potentially) 400 or more seperate DB's to use at any one time and the prospect of setting these up...
  13. Gaylord

    Updating multiple columns

    I had a feeling that was going to be the case, oh well better bite the bullet and start typing! Thanks for the help. If anyone has a simple solution then let me know as it may well save my sanity :) Regards Jamie
  14. Gaylord

    Reference Guides!

    Thanks SQLBill.
  15. Gaylord

    Updating multiple columns

    Thanks for answering Denny, My question relates to if there is an easier way of generating the set command than entering each one, for example data.name = inserted.name, data.date = inserted.date, and so on for the next 200 columns. Is there any way of generating this programatically...
  16. Gaylord

    Updating multiple columns

    Hi, This maybe a simple question, but I am trying to create a query to update a record within a database with a huge number of columns (somewhere around 200+). My trigger so far is as follows, where it updates a record with a new date, but I need this to update each column. I read a number of...
  17. Gaylord

    Reference Guides!

    Hi, A quick question which I hope someone can advise me with. After using the forums I am starting to get a better understanding of how things fit together, but would like to get some decent reference books.... Any suggestions of a "SQL bible"??? Thanks in advance Jamie
  18. Gaylord

    Simple trigger question

    Thank you so much. I will try the next few steps now! Cheers Guys Jamie
  19. Gaylord

    Simple trigger question

    Hi, This is my first attempt at a trigger and I seem to be having a bit of a brain freeze! I insert a record into a table with basic user info, a trigger then grabs the newly inserted information and puts it into a second table for later use. However whenever i do this it takes everything...
  20. Gaylord

    Paaing variables

    Thanks Dan. Works a treat! Cheers Jamie

Part and Inventory Search

Back
Top