AllExperts > Database Programming 
Search      
Database Programming
Volunteer
Answers to thousands of questions
 Home · More Database Programming Questions · Question Library  · Free Encyclopedia ·
More Database Programming Answers
Question Library

Ask a question about Database Programming
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
About Marty Landman
(Top Expert on this page)

Expertise
Database installation, analysis & design and programming questions.

Experience
Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.

Education/Credentials
MS in computer science.

   

You are here:  Experts > Industry > Data Management > Database Programming

SubjectDate AskedExpert

Question about query11/15/2009Iain M Watson
  Q: I have the following query: SELECT * FROM PickListDetails WHERE Quantity=(SELECT MAX(Quantity) from ...
  A: Your problem is that you need a GROUP BY statement at the end of the SQL statement for the columns ...
conceptual database design10/4/2009Iain M Watson
  Q: I have a question on a homework problem asking me to Identify the mandatory/optional dependencies ...
  A: this look like a relational databases question ?? If so then we are talking about existence ...
SQL Query9/23/2009Iain M Watson
  Q: In a view I want to count the number of activities (CMTR_WR_ActivityType) per person ...
  A: I am not sure which database you are using, but most SQL is the same in relational databases. You ...
Which program to use9/11/2009Iain M Watson
  Q: I have built an Access database that I want to re-write in a different program for resell as web ...
  A: If you want to use the database thru a webserver/browser yuo should probably use MySQL and apache ...
access 2003 inventory database8/19/2009Iain M Watson
  Q: My question is that I need to create and inventory database that can be added to and subtracted from ...
  A: I am not completely clear on what you need. But a basic Inventory database has an Inventory table ...
Dbms7/17/2009Iain M Watson
  Q: what is the basic difference between DBMS & RDBMS?
  A: RDBMS is "Relational database management system", DBMS is the same minus the relational. There are ...
calculations in databases7/13/2009Iain M Watson
  Q: how do i create an expression that affects two fields in two different tables in a form
  A: You can use the POST_TRIGGER command. You can have a block level POST_INSERT trigger on one table ...
Database and caller id7/10/2009Iain M Watson
  Q: My friends parents run a small cleaning company. They have some database that was written by someone ...
  A: This is not an area of my expertise, but there are a few companies that I have found on the ...
database7/9/2009Marty Landman
  Q: can i find work in database in Brazil or USA. what is the scope of database in Brazil and USA. ...
  A: Saeed, Freelance work which is what I do is getting harder to find right now, because of the ...
DB Form6/12/2009Marty Landman
  Q: We need to tick several boxes from a choice of 10 in a form. So a combo/option/checkbox/list box is ...
  A: Maggie, It sounds to me like a checkbox would be perfect for your user interface. Look at the ...
Password6/4/2009Marty Landman
  Q: I'm probally in the wrong place and if I am please tell me where to go. How can I change my ...
  A: Shawn, If you're running windows you'd boot up in safe mode, by pressing F8 while the machine is ...
Database pools?5/12/2009Carlson Lim
  Q: Does there exist a database application that will pool together similar files of your choice? For ...
  A: Amazon and iTunes have similar functionality. Users can group songs or discs to their liking. If ...
Database of emails3/24/2009Marty Landman
  Q: I work on projects where I need to email a particular message to between 100 to 400 web site ...
  A: Sort of. You could use a web scraper function which would probably have to be custom built to do a ...
Choosing a database program2/23/2009Marty Landman
  Q: I have used a simple database years ago and I am no whizz or statistician. However now, I find ...
  A: Chris, First, I don't know SPSS. I do know that it is a canned statistics program, probably ...
Excel duplicate finder1/2/2009Carlson Lim
  Q: I want free software for checking duplicate words in Excel (Deduplication check Software). I have ...
  A: You can use the Control F function to see all of the matches by clicking Control F, then Options, ...
Table, query, and relationship design with membership and attendance10/12/2008Carlson Lim
  Q: I'm trying to design a database for an organization that will record membership in groups and track ...
  A: It looks like you have a good start on your project. I see that you have tables set up for members ...
DBase7/29/2008Carlson Lim
  Q: do you know anything about dbase or Dos? We have old system and don't know how back-up discs would ...
  A: Joe, It depends on what version of dbase you're using. A long long time ago I used dbase III, but ...
POS Database7/14/2008Marty Landman
  Q: I'm trying to make a POS point-of-sale software. I only know using ms access for database. Is ms ...
  A: Jeric, Access is a fine database - your most important decision might be which platform to use ...
Combining two records from a query into one record6/26/2008Carlson Lim
  Q: e. the table has colour information say 30 different colours each with a pattern size. I then get ...
  A: This is possible if you create a query that will query Expr3 in your example above. The SQL would ...
Calculating a business day4/18/2008Marty Landman
  Q: Do you know a simple method of taking a date and calculting 5 business days from that date? For ...
  A: Jill, You didn't say which database you're using. Mysql, like the other databases has extensive ...
Skip Blank Line4/14/2008Marty Landman
  Q: .expert, I have a report, i would like to skip blank line records, how?
  A: Hasmukh, It depends. What are you doing specifically? What software are you using? Can you check ...
simple database4/11/2008Marty Landman
  Q: not sure if I've found the right expert, but, I'm looking for a simple database program that will ...
  A: Johnny, Have you looked at Excel? This sounds like exactly what spreadsheets are designed for. Also ...
Auto select items in a list box based on a combo box4/9/2008Marty Landman
  Q: . i have a small form based on a query, i have one list box of all names in the list and one unbound ...
  A: Yankel, Selecting on the fly is only possible using: 1) javascript 2) Ajax 3) server side ...
ms access2/29/2008Marty Landman
  Q: I have a database from which I need to export data (a query)! The data needs to be exported in a ...
  A: Neil, I'm not familiar with MS Access' export options, however maybe this shareware product will be ...
Oracle global variable2/18/2008Marty Landman
  Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ...
  A: Ali, While I don't personally have experience with this issue I found a discussion involving what ...
Suggest Database Software2/13/2008Marty Landman
  Q: I have been looking around at some different database software, but have not committed to anything. ...
  A: Pat, It doesn't matter which database you use, just as it doesn't matter whether you use Snap On or ...
Query optimization2/12/2008Marty Landman
  Q: Wanna know some of the key points by which we can optimize a big query with so many joins,running ...
  A: Deepa, Start with these online tutorials http://littlelink.webtrouble.com/?WMQP ...
access to web2/11/2008Marty Landman
  Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
  A: Bob, With all due respect you will either need to get a bid from a programmer like me or have ...
access to web2/11/2008Marty Landman
  Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
  A: Bob, If by easy you mean is this something a person with no web development experience can do in a ...
FUNDAMENTALS OF DATABASE8/16/2007Ivan Maskovic
  Q: Sir, i want to know the definitions of a key,primary key,secondary key & the difference among these. ...
  A: Regarding keys, I found this helpful article on wikipedia ...
data security8/7/2007Marty Landman
  Q: I want to know about ; how we can secure our data base file, so that anybody can't open it. Can we ...
  A: There are two basic things you can do which I am familiar with. First, have an id and password set ...
Maintaining a database on the web8/2/2007Marty Landman
  Q: What programs are available (and what is the best) for a db that needs to be web accessible?
  A: There really are a wide variety of options here. From the very simplistic such as my form to ...
Mail Labels7/14/2007Marty Landman
  Q: I have a database completed of 850 names, addresses. I wish to merge this info to mailing labels. ...
  A: I would approach this by writing a simple program to print the data out, and then use the newline ...
Inventory Database7/3/2007Marty Landman
  Q: Hey Marty, I have Microsoft Access 2003 and I need to create a database that will store all of the ...
  A: Jay, This involves the development of an application. What I mean is that you can input the ...
Query Help needed6/19/2007Ivan Maskovic
  Q: I need help in writing a query which works in the following scenario: I have two tables Contacts ...
  A: Sorry Jon, I haven't any experience with Oracle SQL dialect. Nevertheless I would try this: select ...
Building a Database6/18/2007Marty Landman
  Q: I am planning to manage a website that stores client data (information) through forms, and also ...
  A: Avneesh, You may be in luck. I have an open source product which takes form data and puts it on ...
Query Help needed6/8/2007Ivan Maskovic
  Q: I need help in writing a query which works in the following scenario: I have two tables Contacts ...
  A: select a.*, b.contactid from Contacts as a inner join Country_Contacts as b on a.contactid = ...
SQL5/30/2007Marty Landman
  Q: I am studying IT and have an exam and I know I should know this but I have only just found out there ...
  A: Look at http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html and you'll see 12.2.1. ...
sql - create table5/25/2007Ivan Maskovic
  Q: I'am currently using terradata and sql to access our dataware house, I'am new to both. I'm ...
  A: First I should tell I have no experience with terradata. But if I understand your issue right, a ...
ms access5/5/2007Carlson Lim
  Q: I have an access database and I'm stuck with how to rank records. What i did was place a rank field ...
  A: Let's say the table for this is named Task, with columns TaskID, TaskName and RankNumber. I'm not ...

Page:   1 | 2 | 3  |  Next      All


Questions by
Active Experts:
Marty LandmanCarlson LimIain M Watson
   

Email this page
     
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2006 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.