Database

martinsz10-Aug-01 4:53

martinsz

10-Aug-01 4:53

Thanks for your answer Carlos;)
But since I am using an Access database it does not seem to work by using "*" sign. I would be grateful for other suggestions!!!

Best regards/ Martin Cool | :cool:

Carlos Antollini10-Aug-01 5:19

10-Aug-01 5:19

No problem
In Access you Have the LEFT JOIN and the RIGHT JOIN syntaxis

Like this:

FROM 
         Company LEFT JOIN email ON 
         Company.ID = email.companyID

This expession assums that you have Company that don't have email. If a company don't is in the table email the company is showed.

In others words: It selects all companys, including those without email.

Cheers!!!!
Big Grin | :-D

Carlos Antollini.

martinsz13-Aug-01 4:24

martinsz

13-Aug-01 4:24

Hi & Thank you!!!
But how do I do if I have Many tables that I want to join. For example.
I want to see all companies including companys without email and also including companys without telephonenumber etc. Will I need some sort of nested join-query to do this? if so What how shall I write this?

Thanks in advance, Martin Cool | :cool:

Carlos Antollini13-Aug-01 6:13

MS Access Field List Disappeared

13-Aug-01 6:13

Is the same

Select Company.*, email.email, phone.phone
FROM          
Company LEFT JOIN email ON          
Company.ID = email.companyID AND
Company LEFT JOIN phone ON
Company.ID = phone.companyID

If the phone or the email for that company don't exist, you will see the field like NULL.

Cheers!!!!

Carlos Antollini.

Douglas Troy9-Aug-01 3:07

Douglas Troy

9-Aug-01 3:07

Working in MS ACCESS, developed a small database to track some dept. specific data for projects (nothing big). While working, I have somehow managed to make the Field List Editor disappear. Eek! | :eek:

Clicking the toolbar button and/or the menu item that normally "re-displays" the field list editor, does NOT make the editor visible. I found something in the ACCESS help system that indicated something about piviot tables causing this problem, but I'm not using piviot tables in my project; anywhere. Confused | :confused:

Does anyone know how to get the field list back?

TIA.

D.

OLE DB/ATL guides worthless

Bigge8-Aug-01 23:17

Re: OLE DB/ATL guides worthless

8-Aug-01 23:17

For the last month i have studing OLE DB with ATL and the ATL wizard in Visual studio c++.
I have Read severals articles about connecting to a database with CCommand and Caccessor and making SQL questions under DEFINE_COMMAND......
All this articles reflects a DB with only one Table. When you then wont to connect to several tables making SQL question, how do i do that?
Is it not possible or what? It must be, or else i think the ATL class for OLE DB is useless.

/Bigge

Not Active9-Aug-01 4:45

Not Active

9-Aug-01 4:45

Just like with anything the wizards are a good start, but you must be able to add to what has been provided. The ATL OLE DB wizard only works with one table soyou will have to hand code the Accessor to provide for the additional tables.

ATL OLEDB Template Insert

Brad Bruce8-Aug-01 16:11

Brad Bruce

8-Aug-01 16:11

I'm learning how to use the ATL templates to access a database. I can read from the table with no problems at all. Smile | :)

Unfortunately I can't insert. Cry | :((

I read somewhere that an insert into an empty table can be trouble. Frown | :(

Any suggestions.

Re: ATL OLEDB Template Insert

Not Active8-Aug-01 16:34

Not Active

8-Aug-01 16:34

What is the problem with the insert? Do you get errors or just empty records? Do you have the update property set?

Re: ATL OLEDB Template Insert

Brad Bruce9-Aug-01 12:09

Brad Bruce

9-Aug-01 12:09

I checked further today. The open statement fails when I have the insert, update or delete property set, but works when opened for reading.

I am using the Oracle OleDB driver from Microsoft. I'm wondering if it is a Read-Only driver????

Brad

Select DISTINCT and CRecordSet

Derek Price8-Aug-01 12:08

Derek Price

8-Aug-01 12:08

Hello,

Is there any way to "select distinct" after deriving a CRecordSet class? I have a rather large table that has a small number of distinct values I'm looking for. Using "select distinct" works well when I query the database using a database viewer, but I'm not sure how I would do this in the derived CRecordSet class. Is there a way?

Thanks in advance!
Derek

Carlos Antollini8-Aug-01 12:35

8-Aug-01 12:35

Using CRecordset::Open();

in the second parameter you can write your sql string.
Open(CRecordset::dynaset, "Select Distinct * from table where...");

Cheers!!!
Wink | ;)

Carlos Antollini.

Derek Price8-Aug-01 12:38

Derek Price

8-Aug-01 12:38

What if I already have a derived CRecordSet class like:

class CEmployeesRecordSet : public CRecordSet
{
...
}

Is there anyway to do it from this class?

8-Aug-01 14:27

If you can't answer that question yourself you need switch to VB or other languages where you won't hurt yourself.

Carlos Antollini9-Aug-01 4:10

Stored Proceure Parameters

9-Aug-01 4:10

Yes, You don't have problem with that.

You only need to use the open method in your class. Your class is derived from the CRecordset class, is for this that you don't have problem.

Cheers!!!
Wink | ;)

Carlos Antollini.

Bigge8-Aug-01 6:44

Major Problem with moving MSDE DB

8-Aug-01 6:44

I want the AAID to be the BBID but this aint working!

DECLARE @sune int
SELECT @sune = MAX(AAID) FROM TEST_SESSION

INSERT INTO CAB_TEST
(BBID, CabComment, CabName, CabFNum, CabFName, CabSNum, CabEmp, CabRefDes)

VALUES(@sune, Null, 'Kabel1', '222-221', 'Styrkabel', Null, 'Chassi', Null);

Plezz Help

/Bigge

Bigge7-Aug-01 10:03

Re: Major Problem with moving MSDE DB

7-Aug-01 10:03

For the Last 6 hours i have tried to connect to a MSDE database wich was produce on a another computer using Win 2000, When i use the ATL wizard consumer function I get the messeage "Could not open column information"
I have troubel to connect to other sources to, it had work before but something is really wrong now, and Im very frustrated.

I can look at the database in Access 2000 but when i will create a new table i get the mes. "You got no exclusive access to the database at this time".

My questinon to you people are, How should the producer of the DB configure his database(using Access 2000 adp project) so it easy can move it to another machine and system?

Im very grateful for answers.

/Bigge

CodeGuy7-Aug-01 10:27

CodeGuy

7-Aug-01 10:27

Do you have admin priviledges? What are the security settings on the DB? Is it corrupted? Have you run a compact/repair successfully? Do you both have the latest MDAC on your systems?

Re: Major Problem with moving MSDE DB

7-Aug-01 10:50

When i lanche his DB i change the login ID and Sql server ID under connection in Access. And link the *.mdf file to the catalog om my computer. Thats it
We have admin priviledges, the security settings im not shore of. compact/repair were is this option?

I have only installed MSDE and i tried to use servicepack 3 for SQL server 7 to uppgrade MDAC and more. But i got some failurs. Do you now witch pack i should uses to uppgrade?

Thanks alot
/Bigge

Re: Major Problem with moving MSDE DB

Bigge8-Aug-01 0:47