I have experience only with Delphi 1,3,4,5,6,7 and (Paradox, Interbase) Firebird
I need to develop a small Application for myself using Free RAD & free DB
I did download Lazarus (Free Pascal...
I am seting up a DB of Zip codes - 80K records, columns as shown below. I need only about 5 columns for my queries, however.
Does the additional overhead of the extra columns provide a larg...
My SQL 2005 DB already has 3000 rows, three columns.
Column_A and Column_B already have values.....right now Column_C is null.
I need to insert 3000 values beginning with ROW 1/COLUMN_C
...
I need to pull call issue records less than 6 days based on the username who is logged in. My two tables: User contains the username and password information. The MainCallIssue has UserName...
My company has just purchased Netezza so we are in the process of rewritting our applications to utilized this new Database. I have been unable to find online any solid reference of Netezza S...
Hi,
I've got two tables. I want that whenever the 'child' table 'product_type' is updated, the modify_ts of the 'mother' table 'product' is changed to the modify_ts of the child.
How can I...
Hi all. I am trying to get all records back from a database and I am passing in some parameters to get some records back. The parameters I am passing in are the ages of people that I want to r...
Hello,
I am trying to create a webpage to query an Advantage database, which my vendor will not support, creating the sql to quey a databse is not a problem. I am unable to create the conne...
Before reading what is below please realize I have never designed a DB for any one or organization with the exception being what I have dabbled with out of textbooks.
Over the last two week...
I have a Chiropractic client that uses Chiro 8000. The software gave them errors (don't know what those errors were) so they uninstalled and reinstalled the software. Well the default install ...
Hey Guys,
I have a .odbc.dsn file which has the settings to connect to a SQL database. And those settings are on each table of a Access database. I think I have chnaged the settings in the ...
Hello Experts,
I am using a treeview control in my VB6 pgm and I have 3 levels from the root. I wonder how can I lookup a key already there and add a child to it. this is my routine attached ...
Hi X-perts,
I build a db query for MS Access like
SQL = "SELECT * FROM myTable WHERE [myField]='" & fieldString & "'"
It works fine unless the fieldString contains quotation marks ( '...
I have a database with thousands of different phone numbers where the number is in this format:
3347497263
What I would like to do is to change the format acrosst the whole DB so it will...
How do I select data from a view without the duplicate values and have those values appended in the return result?
Does anyone have any experience with a Star Schema db structure with multiple fact tables and dimension tables that have multi-value attributes that mix and match to the fact tables. I'm havin...
Hello Experts,
For 500 points...
How do you insert a checkbox text value in sql 2005 when the end user check the box true? I don't want the booleen value (true, false, 0, or 1). I want...
Ok this is hard and Ive scanned google and can find nothing.
We have an old membership system called clubrunner.
it is an old DOS DB system and it stores the member details within a FIL ...
Hi,
I have a column called page_extras (Type text), located in multiple tables.
What is the best way to get results from all tables
I tried
SELECT page_extras FROM mainmenu, mainmenu2,...
I have a table containing purchase information:
SKU COST DATERECEIVED
123 .99 01-01-2009
123 1.09 02-01-2009
123 1.05 01-15-2009
456 1.99 ...
I have two tables linked by a third lookup folder which uses wineid and retailerid.
It works using keys
Iin an individual record, I can show all associated products to that record - the ...
http://img3.imageshack.us/img3/6989/53645000.jpg
Beside CustomerFamilyMembers entity you will see (0,6). This means a customer does not need to have a family in case a customer is single....
I HAVE A MS ACCESS DATABASE CALLED TOEWYS WITH FORM BEVELE WITH FIELD AGE. IN THE FIELD AGE- THE AGE ARE PUT OF CLIENTS. I WANT DIFFERENT SOUNDS TO PLAY IN MS ACCESS FORM - IF THE AGE OF CLIEN...
http://www.experts-exchange.com/Q_24671626.html
I need a little more help...
I know I've accepted the solution and it is what I am looking for...
But, in looking at the data a little mo...
Hey,
I need some help figuring out how blocks work. Like, if I had a block that could hold 30 records or 200 key pointer pairs, and I need to figure out how many blocks I need to ho...
