Search results for query: *

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

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

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

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

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

Hi, I've got this code, which quite happily collects a list of DSN's from the PC, but I want to place this into a drop down list on an Access Form... Any ideas? Thanks Jamie Private Declare Function SQLDataSources Lib "ODBC32.DLL" _ (ByVal henv&, ByVal fDirection%, ByVal szDSN$, ByVal...

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

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

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

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

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

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

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

Thanks SQLBill.

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

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

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

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

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

Thanks Dan. Works a treat! Cheers Jamie