QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

Why are my table and column names not recognized in my query?

PostgreSQL FAQ
The most common cause is the use of double-quotes around table or column names during table creation. When double-quotes are used, table and column names (called identifiers) are stored case-sensitive, meaning you must use double-quotes when referencing the names in a query. Some interfaces, like pgAdmin, automatically double-quote identifiers during table creation. So, for identifiers to be recognized, you must either:

How do I define an AUTO_INCREMENT column that generates unique indentifiers for a table?

Mckoi SQL Database - Frequently Asked Questions (FAQ)
Use the UNIQUEKEY(table_name) function. For example, INSERT INTO MyTable ( my_unique_id, my_value ) VALUES ( UNIQUEKEY('MyTable'), 'record value' ) With a clever use of the DEFAULT clause when creating a table you can make it automatic. eg. CREATE TABLE MyTable ( my_unique_id NUMERIC DEFAULT UNIQUEKEY('MyTable'), my_value LONGVARCHAR(1000) ) The UNIQUEKEY function is an atomic operation that will return a set of sequential numbers for a table on a first serve basis. See similar questions...

What does "N/A" mean in the column of a product table?

Frequently Asked Questions
When you see "N/A" in the column of any product table on this site it simply means that those counts are currently not available. It does not mean that you will not get that information in that particular product. All of our products have every data field available. Some counts tend to fluctuate constantly. In these cases, we put "N/A" or Not Available in that field. See similar questions...

Why are my table and column names not recognized in my query? Why is capitalization not preserved?

PostgreSQL: Frequently Asked Questions (FAQ) for PostgreSQL
The most common cause of recognized names is the use of double-quotes around table or column names during table creation. When double-quotes are used, table and column names (called identifiers) are stored case-sensitive, meaning you must use double-quotes when referencing the names in a query. Some interfaces, like pgAdmin, automatically double-quote identifiers during table creation. So, for identifiers to be recognized, you must either: See similar questions...

How long can my column and table names be in an Oterro database?

Oterro - A High-End Performance Solution For Database Applic...
Yes. Oterro supports the use of table and column names with embedded spaces as long as the name is enclosed with the identifier quote character whenever the name is used. The default identifier quote character is a backwards single quote ('). We recommend, however, that you replace the spaces in names with underscores (_) for ease of use. Yes. The Oterro documentation includes a complete list of reserved words. You can minimize the list by adding the keyword ANSI OFF to your OTERRO.CFG file. See similar questions...

What does the "core" column mean?

Frequently Asked Questions | GM Parts at Wholesale Prices
A core is the old part you are replacing. When you buy a remanufactured part, manufacturers need the core so they can rebuild it and add it to their inventory. The core charge is like a deposit on a soda bottle--you pay it when you place the order, but it's refunded if you send back your old part. See similar questions...

go to top-] What does the "??" mean in the channel column of /WHO?

Relay FAQ
If a user is listed as being on channel "??", it means that person is on a private channel. (further description of private channels below) See similar questions...

What does the ICQ column mean?

FAQ - Bishop Ramsey School Past-Pupils Contact Site
ICQ is an interactive system for contacting people "live" - you can type directly to them and they can respond. The column on the list shows people's ICQ contact numbers, if they have them. The name ICQ derives from "I Seek You" - more details from their web site. See similar questions...

What does the column header mean?

OneOption | FAQs
The column header describes the Class and Set-up for the trade. Hover over it and you will see a brief description appear in the left panel. You can learn more about the whole hierarchy by studying the Tutorials section. See similar questions...

What does "table stakes" mean?

Beginners FAQ - PokerWiki - a Wikia wiki
Answer: This is a basic rule for most cash games, certainly in a cardroom or casino. During the course of a hand, you are limited to betting the amount of money (or chips) that you had in front of you at the start of a hand. You cannot go into your pocket for more money while you have a live hand. In other words, your "stake" is what you have on the "table." This prevents you from buying in for a small stack and only reaching into your pocket when you hit a monster. See similar questions...

What does 'Unique Visitor' mean?

Euraffiliates.com FAQs
In pay per click and pay per impression methods, the affiliate software keeps a check that the person clicking the banner is not the same person clicking again and again. This check makes every visitor a unique visitor. See similar questions...

What does 'Total Unique' mean?

District of Philadelphia : SchoolNet FAQ - SchoolNet
This is the total number of students who are reflected in a report column or row. If this number does not equal the row or column total, it means that some students are double counted. For example, if you run a program report, it is likely that some students may be in multiple programs. The student took an out of grade level benchmark. See similar questions...

What does the stuff in the Flags column mean?

gtk-gnutella - The Graphical Unix Gnutella Client
You can see the type and some of the settings of a connection here. Note push-proxies are implemented in 0.92.1c and later. See similar questions...

What does mean a red cross in the first column?

CDBF - DBF Viewer and Editor : WhiteTown Software : Database...
The red cross means that a record is marked as deleted. You can set and remove red crosses with "Delete" key or mouse left button. You can mark as deleted a few records and then remove all these records, using the command "Pack". See similar questions...

What does mean a green dot in the first column?

CDBF - DBF Viewer and Editor : WhiteTown Software : Database...
The green dot means that a record is selected. You can set and remove green dots with "Insert" key or mouse right button. Then you can The Date fields are stored in a dbf-file as YYYYMMDD. Therefore you have to use conditions, similar to this: See similar questions...

What does the number in the 'Matches' column mean?

About PayScale - Compensation Data, Company Information
This number refers to the amount of data points which match your search criteria. This number is limited to the 100 closest matches, even if there are many more matches available. The report summary shows you the top-level compensation numbers. However, this is just the beginning. Any purchase allows you to view the complete report. For an example of our complete report please see the job titled "Sample Report" on the Employer Reports page. See similar questions...

What do you mean by unique data?

Frequently Asked Questions (FAQs) on Data Sharing
By "unique data" we mean data that cannot be readily replicated. Examples of studies producing unique data include: large surveys that are too expensive to replicate; studies of unique populations, such as centenarians; studies conducted at unique times, such as a natural disaster; studies of rare phenomena, such as rare metabolic diseases. See similar questions...

What do the values in the "Status" column of the task list mean?

The Google Highly Open Participation Contest - Google Code
Please remember that there are many more contestants than there are folks working to make the contest successful, so we may not be able to update the task status values as quickly as we'd like. If you look at a task's description and see that someone has updated it with the phrase "I claim this task", someone else is working on this task and you should look for a different one to complete. See similar questions...

go to top-] What does the "-" in the /WHO, /NAMES, /SINCE, etc. lists mean?

Relay FAQ
If a user (including yourself) has a "-" next to the name, it means that the user is currently using the same host server as you. See similar questions...

Explore Other Topics

How to change the video resolution to 1680x1050, or anything else ?
What is a floating rotor?
Why should I use both the Wrinkle Serum and the Facial Moisturizer?
Why does my website need a Google Page Rank of two or better to have a link to my site?
Can I download account information directly to Quicken and Microsoft Money?
Can I use SC Johnson® Paste Wax with other floor care or home cleaning products?
Will Pointsec for PC slow down my system?
Do I need a visa and a passport to visit Bhutan?
Q:  A deceased person owes me money. How do I file a claim against the estate ?
Can I use your code in my commercial application?
Why are good communication skills so important?
Are lice harmful?
How do I get a copy of a plat map (subdivision map)?
More Questions >>

© Copyright 2007-2013 QueryCAT
About • Webmasters • Contact