USING MICROSOFT ACCESSXP
I have a control on a report looking up the total of hours for the month from the time table. I cannot add this table/query of the table into the main underlying q...
Any advice on pulling blob data and dynamically converting to an image file and posting the path of the image into another field?
What would be the best table design for a simple customer ?
Design1 (One table)
tabel 1
cus_Number
cus_Address 1
cus_Address 2
cus_Address 3
exa...
My code:
transaction.setOutDate(rs.getDate("out_date"));
The "out_date" is a DateTime column in my MySQL table. With this code I can only get the date, but not together with the time. Ho...
I did an export of a user schema and then did an import to another schema, all of the rows transfered over but some of the data in the rows where not consistant . I used consistant=y while do...
Hey,
I would like to create a default value FALSE for a mysql in the column flagged.
CREATE TABLE competition (
B1 int(2),
B2 int(3),
B3 int(3),
B4 int(3),
B5 int(3),...
Hi,
I read in several recently published articles about data warehouse, I got the term "BI".
I don't know what it is. If you've any idea bout this, please help.
Thanks
Rfr1tz
My server locked up and after a reboot I got this id Event ID 784 The database is marked as dirty. I can not dig up anything on the net. Does anyone know what this means? I am running a Pe...
Hi,
I know that for weak entity, we have to include the primary keys of the strong attribute as one of the weak entity's attribute. I would like to know if it is possible that the primar...
In my SUM query if the value is null I want it to return 0. How do I handle that for example,
SELECT OrderNumber, SUM(OrderTotal) from tblOrders
GROUP BY OrderNumber
Hallo Folks
I have the following error Process 67 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION on SQL Server patch 3
could anyone assist me how to solve it
Rutger
Hi guys,
Any idea how to implement multiple record groups to a LOV. My requirement is that i have to create a LOV for
a filed "Supplier" . Depending upon the other field in the form , i ...
I am upgrading windows NT IIS (web server) to windows 2003 IIS 6 and SQL 7.0 to SQL 2000. I have install a separate windows 2003 standard edition and installed SQL 2000 and IIS 6 on it. Config...
I've 2 SQL servers using Merge Replicator to sync 2 databases.
In the replication monitor I can see that the syncronization fails with the following error:
"The agent is suspect. No resp...
Hello, where can i get a current database that has AreaCodes and Prefixes (NPA/nXX) like http://sd.wareonearth.com/~phil/npanxx/
I want a more uptodate version...
What is really a decision support system (DSS)? does it relate to data mining? What technology is used to implement it and what are it's functions? thanks
I've got a procedure which access two tables and a view for data. if one of the selects in the proc does not retrieve any data, the results of the procedure are NULL. In this case I'd like i...
connect to database
reorgchk update statistics on table all
SQL2310N
Error "-964" was returned.
Any ideas what might cause this?
Hi,
how do i resolve or convert this code, having WHERE clauses and fairly convoluted with a MAX() functions...
select @ot_type = d.value
FpOM t_employee_ppa_detail d /*(I...
I inherited a SQL Server project using DTS. Unfortunately, there is no documentation and I'm not able to contact the original programmer. The DTS package is written to access 25 different remo...
HOW CAN I DEFINE NEW ORDER OF CHARACTER FOR USEING IN SQL "ORDER BY"
EXAMPLE
MY ORDER IS A C D B INSTAED OF A B C D
AND I WANT SORT SOME WORDS LIKE AB,AC,BA,AAAA,....
IN MY NEW ORDER I...
Hello Experts,
I am stuck in a procedure and need your help. Procedure I am trying to write must do the following:
- Create a .csv file.
- Execute a select statement
- Write the co...
Hello,
I am supplied with a Progress 6.2 DB File, and I want to export the tables and their contents to a text file, how am I going to do this? As a first step, exporting the layout would b...
I am using MS Access 2003.
I have linked tables.
I would like to add some fields to a particular one.
When I try to go into "design view" I get the following error message
"Table 'tblTitle...
I have a table that looks like the following:
rate1, rate2, match1, match2
-----------------------------------
4.242, 5.232, X, Y
4.623, 4.233, X, Y
and so on.
a field in another t...
