• Database modeling question

    I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we're deep into data modeling. We can't agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can't quite prove that...

    VirgilReality20 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • After trigger select from other tables using joins

    Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E.... even if those records had no action applied to them. I tried declaring variables from the other...

    Pmnc81795 pointsBadges:
  • view data from ODBC to Crystal Reports

    i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:

    Sryn5 pointsBadges:
  • Oracle 6i Log in – User-name & Password

    What is the user-name and password of Oracle 6i to Log in?

    4004145 pointsBadges:
  • Update Table use Left outer join in ms acces

    hello, i wont to ask i try to update table use from another table, i sue the left outer join if in ms sql server this command is run, but when i try to in ms acces its cant run please see the command Private Sub Command31_Click() Dim update_personallog As Integer update_personallog = "update...

    Wahyono25 pointsBadges:
  • When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?

    Rofnh20 pointsBadges:
  • i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that

    i want to read first 5 records and want to skip the next 5 records and want to read another 5 records in a db2 table using cursor.? how do i do that

    Iluilu5 pointsBadges:
  • Problems witih Cisco AP Aironet 1231AG

    hello! i have done something very stupid...I erased cisco IOS image and now when i connect via com port and set up the ip address, netmask and default router, i still cannot connect to the AP i can't even ping the AP, and in order to upload other image i must be connected to it via tftp but every...

    Air1231AG5 pointsBadges:
  • how to block update command when using STRSQL ( db2/400)?

    Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?

    Altino20 pointsBadges:
  • SQL server as data source for OBI EE

    hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

    NewIT5 pointsBadges:
  • Access 2003 default record locking

    I'm working with a multi-user Access system. When I change the default record locking option via Tools/Options/Advanced and then save the database, the other users still have the original setting for record locking, i.e. the change I have made is not shown on their machines. Shouldn't the change I...

    Jch0275 pointsBadges:
  • wireless roaming howto

    I have 3 routers (2 trendnet, dlink) one of trendnet (192.168.100) is connected to my proxy server and i want the other 2 acts as access point and do roaming. I did a setup using same ssid, differents channels but i can't ping to 192.168.10.100 (proxy connected ). What else should i do? Thanks in...

    Tics5 pointsBadges:
  • Sql Query in AS400

    I am trying to execute a Query String but I receive following error Query exceeded the specified time limit or storage limit however my query length is normal, nevertheless i have executed larger query too. How to solve this problem.

    Mr. SEA130 pointsBadges:
  • database saves to new file

    Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.

    Shazzie70 pointsBadges:
  • Access Switchboard Problem

    The title of the switchboard changes to the title of one of the items. I can't figure out why.

    Tryan1225 pointsBadges:
  • Xml Reader in oledb

    how can i get ExecuteXmlReader() in OLEDB? i used sql server databse in my project. but now i want to change it to OLEDB. but ExecuteXmlReader() is not in OLEDB. what can i do to solve this? pls reply.

    Chinki10 pointsBadges:
  • Unable to restrict the display to top N records in subform in Microsoft Access 2003

    I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query "select top 10 * ...", it executes successfully in the query editor window but...

    Zafarkhurram10 pointsBadges:
  • data copy – paste from the same table not showing in a subform

    I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

    Tcharlton7920 pointsBadges:
  • Slow SQL Query

    when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

    Mxaxyogesh200230 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following