Database

Re: help me understanding left join

11-Mar-10 23:15

This article [^]may help as well

Never underestimate the power of human stupidity
RAH

Mogamboo_Khush_Hua12-Mar-10 2:16

Mogamboo_Khush_Hua

12-Mar-10 2:16

I know that but what i am asking how that cartesian product is done when " where condition is used in left join"

Access 2007 - tabbed forms manage own popups

john john mackey11-Mar-10 5:33

john john mackey

11-Mar-10 5:33

I am thinking this tabbed form method in Access 2007 could be good...

If I set my forms to come up as tabbed forms, can i design a pop-up form to be visible only in the current tabbed form/window?

Aside from a complex set of checks on current view state, is there a property setting that locks a pop-up form to the current parent that launched this pop-up?

Or, is there a way to check what tabbed form is currently active? I'm trying to avoid the user getting buried in a sea of pop-ups, but still allow him to switch between forms if he needs to.

Thanks so much,
JJ

Re: Access 2007 - tabbed forms manage own popups

Eddy Vluggen12-Mar-10 2:23

Re: Access 2007 - tabbed forms manage own popups

12-Mar-10 2:23

john john mackey wrote:
Aside from a complex set of checks on current view state, is there a property setting that locks a pop-up form to the current parent that launched this pop-up?

Not sure if VBA supports it, but you could try to set the new windows as a Child-control of the ParentForm.

john john mackey wrote:
Aside from a complex set of checks on current view state

Viewstate? Are you trying this from Access or from an ASP.NET application?

john john mackey wrote:
Or, is there a way to check what tabbed form is currently active?

That's usually possible, there's a property called "ActiveTab", "SelectedTab" or "SelectedIndex".

I are Troll Suspicious | :suss:

john john mackey16-Mar-10 7:37

john john mackey

16-Mar-10 7:37

I am doing this in MS Access 2007.

I found something about a property (Screen.ActiveForm) - this probably means that I will have to do my own Form, Parent/Child management.

Thanks for the advice on looking about a Child property. I will check into this.

project

salemmohamed10-Mar-10 22:54

salemmohamed

10-Mar-10 22:54

I have project call Managmnet information system for finace,
I use the
1- oracle database 10g
2- oracle developer 10g

I am not have anything about two this software.
I want project alreay did by to this software
or toturial

Mycroft Holmes10-Mar-10 23:53

10-Mar-10 23:53

I think you are doing your boss/client a disservice!

Get hold of a book on database design, read a bunch of articles, have a wander through SQLServerCentral.com.

Depending on the size if the business you are taking on a very large project, one that will take a skilled single developer a substantial amount of time to even understand the business requirements let alone the database design, etl management, data structuring, business logic layer and delivery interface.

Good luck, you are going to need it!

Never underestimate the power of human stupidity
RAH

R. Giskard Reventlov11-Mar-10 0:01

R. Giskard Reventlov

11-Mar-10 0:01

Here: Library of free data models[^].

Also: OraFAQ[^]

Good luck: you're plainly going to need it - does your boss know you have no idea where or how to start?

Tychotics

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Mycroft Holmes11-Mar-10 19:07

11-Mar-10 19:07

What and excellent link - it could help a lot of people here.

Never underestimate the power of human stupidity
RAH

Rob Graham14-Mar-10 6:32

Rob Graham

14-Mar-10 6:32

You mean it could let a lot of lazy idiots leverage someone else's work without understanding it?

Mycroft Holmes14-Mar-10 14:50

What is special about 'Asynchronous Processing=true' in the connection string?

14-Mar-10 14:50

Rob Graham wrote:
lazy idiots

So you know anush 6 threads up, hopefully they can gain something from seeing a data structure, without any understanding I doubt a canned structure is going to really help someone.

Never underestimate the power of human stupidity
RAH

Rob Philpott10-Mar-10 6:18

Rob Philpott

10-Mar-10 6:18

This allows you to execute commands asynchronously (ADO 2) using BeginXXX and EndXXX in .NET in the traditional way.

But, if you want Async access, you could just use multiple threads for that (probably using seperate connections).

What does this entry in the connection string actually do? Is it a case of allowing more than one command to execute at a time against a single connection?

Regards,
Rob Philpott.

Re: What is special about 'Asynchronous Processing=true' in the connection string?

Mycroft Holmes10-Mar-10 23:56

Re: What is special about 'Asynchronous Processing=true' in the connection string?

10-Mar-10 23:56

Absolutely no idea, never used it, never looked into it, was not even aware it existed. I have not looked at a connection string for many years. I wonder if I am missing something?

Never underestimate the power of human stupidity
RAH

Eddy Vluggen11-Mar-10 1:56

Streaming SQL table data to secondary location

11-Mar-10 1:56

Rob Philpott wrote:
What does this entry in the connection string actually do?

Found some good explanation (with usage scenario's) on MSDN[^];

MSDN:

In previous versions of the .NET Framework it was possible to simulate non-blocking execution by using asynchronous delegates or the ThreadPool class; however, those solutions simply blocked another thread in the background, making them far from ideal for cases where it is important to avoid blocking threads [...]

I are Troll Suspicious | :suss:

bonkers12310-Mar-10 3:54

10-Mar-10 3:54

Hi there,

I want a way to stream data from one table in one database to the same table on a different machine.
Is there a way?

Any help would be much appreciated.

Kind regards,
Hugo

Tim Carmichael10-Mar-10 4:07

Tim Carmichael

10-Mar-10 4:07

Option 1: replication
Option 2: write a job to perform the bulk transfer.

Not real time

David Mujica10-Mar-10 4:18

David Mujica

10-Mar-10 4:18

If you don't need to do this in real-time, then you could consider taking a nightly backup of Server A and performing a restore on Server B.

Just a thought.

i.j.russell10-Mar-10 5:34

i.j.russell

10-Mar-10 5:34

If you are using Sql Server 2005 or later, you can use Service Broker.

Eddy Vluggen11-Mar-10 2:03

11-Mar-10 2:03

bonkers123 wrote:
Is there a way?

Multiple, and their applicability depends on the type of database that you're using. SQL Server for example has the option to "link" to another database. It also depends a bit on what you expect from the target-table. Does it have to be "up to date" at all times, or would it be sufficient to have access to yesterday's data?

To add to the pile of options; you could also use the Microsoft Synchronization Framework.

I are Troll Suspicious | :suss:

bonkers12311-Mar-10 20:29

11-Mar-10 20:29

It has to be up to date at ALL times... It's a sql database...

bonkers12311-Mar-10 20:32

11-Mar-10 20:32

So how do I link a table of one db, to a the same table on a different db ... ?

Eddy Vluggen12-Mar-10 0:23

12-Mar-10 0:23

From the Management Studio, expand "Server Objects", right-click on "Linked Servers" and select "New Linked Server". There's several options to specify the credentials for the remote database.

E.g., if you have Server A (with a master database) and a Server B (with AdventureWorks), then you could execute queries like this;

SQL

SELECT [name]
  FROM [master].[sys].[tables]
  
 UNION ALL
 
SELECT CAST([VersionDate] AS VARCHAR(50))
  FROM [ServerB].[AdventureWorks].[dbo].[AWBuildVersion]

More information on configuring a linked server can be found here. Hope this helps Smile | :)

I are Troll Suspicious | :suss:

bonkers12315-Mar-10 1:15