• Implementing DBMS

    My company does not have information services staff and I am not planning to ave one at this moments because of the expanses. We have 12 WINTEL microcomputers that we used for variety of tasks withing the organization. We use Microsoft Office for words and financial application and power point, but...

    Mis15 pointsBadges:
  • Months query in Microsoft Access 2000

    On the basis of my query i have built a totals query as follows: SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate FROM qryMargin GROUP BY qryMargin.invoicedate; I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange...

    Peljo20 pointsBadges:
  • blanks (”) instead of NULL’s in SQL Server 2000

    I have a development team that wants to represent all fields with no values with a '' (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL's. Aside from taking up more space in the database than is...

    ColdDBA0 pointsBadges:
  • Can’t gert nested subforms to work in MS Access 2007

    Hi, and thanks for taking a minute to read my post. I am trying to get nested subforms to work, without success. I have a main form with a subform, then a subform inside the first sub. I'll call them 1 (for the main), 2 (for the first sub), and 3 (for the second sub). I can get 1-2 to perform...

    Mballard10 pointsBadges:
  • The most widely used form of database is a?

    The most widely used form of database is a?

    Jthomps25 pointsBadges:
  • MYSQL/PHP based CMS (Mambo,Joomla) on the 400.

    Has anyone setup one of the MYSQL/PHP based CMS (Mambo,Joomla) on the 400 yet? I use these CMS on regular Apache 2.0 servers with MYSQL 5.0 & PHP 4+ These CMS are very flexible and adaptable and I would like to use on the 400.

    DHanneman200 pointsBadges:
  • Download from the AS400 tab delimited file

    I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended. Any...

    Butcheanes5 pointsBadges:
  • trigger to update

    My Table Structure is: Table A Table B Table C colA -PK Col B-PK Col C-PK Col B-FK Col B-FK Col C-FK This relation establish a Concurrent relation where in Cascade Property fails.I can set Cascade property for any two tabnles...but not the third table. My requirement is : 1)To Update PK of Table B...

    Adithi5 pointsBadges:
  • How to manipulate data or values in my tables SQL Server

    A question emailed to us i can now connect the database i made (in mssql server) but the problem is i do not know how to manipulate the data or values in my tables. for example, in my login program. i do not know how to declare that the input of the user must compare first to the login_table (in my...

    ITKE344,900 pointsBadges:
  • MS Access Date Time

    I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time

    Han848490 pointsBadges:
  • Exporting MS Access data to Oracle

    Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....

    M15 pointsBadges:
  • ‘m trying to verify that a SQL DATABASE is empty ,

    I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE. They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

    MAB TRIBEFAN5 pointsBadges:
  • Generic database design to store logs of every database change

    Hi there, Can anyone help me out by providing a generic database design for having logs of all the changes to my master table so that I can review all the changes at a later point of time through my application. Every response will be appreciated.... thanks, Sudhakar

    NAGA5 pointsBadges:
  • How to read/write Access 2003 mdb records on server via INTERNET connection

    It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When...

    RalphW25 pointsBadges:
  • i want to know some real time applications of RBMS design algorithms

    while observing the relational model and the algorithms in relational database schema designing there were no real time examples for finding the dependencies, closures, minimal cover,loss less join or dependency preservation.can i get a single relation explaining all these algorithms

    Suchi5 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • Community Message: Answer these questions and earn Knowledge Points

    Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. You can find...

    ITKE344,900 pointsBadges:
  • IIF clause

    Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 0.001 20 0.009 1 1.32 4 0,32 0,5 1,67...

    Peljo20 pointsBadges:
  • Visual Basic IF statement…

    I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? If...

    Mandi195350 pointsBadges:
  • Passing DataTable to Web Service Function

    Hi! I have fetched out data into datatable from source database and want to pass this datatable into my webservice function. so that webservice function could insert data into destination database. any help will be highly appreciated. m4atiq.

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following