Database

Re: Data type mismatch blues.

24-Feb-04 5:12

try not enclosing numericals in quotation marks

Adodc2.RecordSource = "SELECT * FROM Supplier WHERE JOB_NO = " & JobNumber

Marypoppins24-Feb-04 18:52

Marypoppins

24-Feb-04 18:52

Thanks, that sorted it out.

connect to web service

arzu23-Feb-04 21:43

arzu

23-Feb-04 21:43

please show me on how to connect my SQL database using web services

given2fly

Re: connect to web service

Verdant12324-Feb-04 5:08

base de donnée avec une classe en C++

24-Feb-04 5:08

you have to be a little more clear...

do you want to be able to retrieve and update the database(s)?

what languages and environments are you going to use? (ASP.NET/C#?)

with ASP.NET and visual studio, i would start with making a simple web service application, then write the methods i would want to expose, along with any private methods required

if you intend to send and receive any complex data, then you should probably design your message format beforehand.
see Place XML Message Design Ahead of Schema Planning to Improve Web Service Interoperability

also a general guide to webservices:
How ASP.NET Web Services Work

MagicFans9122-Feb-04 23:24

MagicFans91

22-Feb-04 23:24

je dois faire une classe en C++ réalisant une communication avec une base de donnée je souhaiterai connaitre le nom de la classe ki gère cette communication sinon quelles sont les méthodes k je devrai utiliser
Merci d'avance;P

MagicFans91

Re: base de donnée avec une classe en C++

Sarvesvara (BVKS) Dasa23-Feb-04 2:06

Sarvesvara (BVKS) Dasa

23-Feb-04 2:06

English please....... D'Oh! | :doh:

I was born intelligent
Education ruined me!.

Re: base de donnée avec une classe en C++

Verdant12323-Feb-04 12:06

Re: base de donnée avec une classe en C++

23-Feb-04 12:06

are you asking about inheritance in c++?

maevava26-Apr-04 1:54

maevava

26-Apr-04 1:54

salut
tu devrais changer de forum en choisir un en français par exemple Poke tongue | ;-P

pour faire ce que tu veux cherche vers ADO
vas voir sur ce site il y a des exemples et des tutoriaux
http://www.cppfrance.com/
je peux pas t'aider plus je suis pas très douée

bon courage

Maeva

Install my SQL Database to other Machine

Sarvesvara (BVKS) Dasa22-Feb-04 20:12

Sarvesvara (BVKS) Dasa

22-Feb-04 20:12

Hi all,

All these days, I was working with MS Access and deploying the same to the server was easier for me... (jus a upload).

Now, I am working on a project with SQL Server 2000 and this is going to be deployed into an Intranet Setup. So, the scenario is to in stall the database with few tables' contents mainteined. Even though this is going to be taken care by the 'intstallation team', I am quite curious to know about the process

My requirement is...

*** How would I take the database tables and the contents to the client's place (obviously it should be in CR-ROM, but How is the copying process done?)

*** How is the database installed into the client's SQL Server?

*** What next???

Thanks in advance.

I was born intelligent
Education ruined me!.

Re: Install my SQL Database to other Machine

TLWallace22-Feb-04 20:43

TLWallace

22-Feb-04 20:43

Try the following from Microsoft:

Walkthrough: Using a Custom Action to Create a Database During Installation

Using SQL Server Desktop Engine Merge Modules

Microsoft SQL Server 2000 Desktop Engine (MSDE) Installation, Deployment, and Patching

HOW TO: Create a SQL Server Database Programmatically by Using ADO.NET and Visual Basic .NET

Re: Install my SQL Database to other Machine

Sarvesvara (BVKS) Dasa23-Feb-04 2:05

Sarvesvara (BVKS) Dasa

23-Feb-04 2:05

Thanks.. will walk through these one by one...

I was born intelligent
Education ruined me!.

Re: Install my SQL Database to other Machine

Verdant12323-Feb-04 12:10

Saving DataSet into Access MDB

23-Feb-04 12:10

i think he was asking more about how the data would be installed, etc... not how to deploy MSDE in an install...

usually i take the lazy root and let SQL enterprise manager generate the scripts for me, then i export the data from my machine and re-import on the target machine...

dave charlton22-Feb-04 18:15

dave charlton

22-Feb-04 18:15

I have datasets with multiple tables that I would like to save as a new Access database (or at least an Excel workbook) instead of XML.

The format does change a bit, so I really don't want to go through a bunch of hoops hardcoding every table and field.

Isn't there a way to simply save a dataset as an MDB?

(ie, for each table in the dataset, create a table in the MDB of the same name, with the same fields, and the same records.)

I know it's a little unusual to do, but shouldn't this be simple?

Problems building Query

xfitr221-Feb-04 18:16

21-Feb-04 18:16

I am having problems building a Query and would really appreciate if anybody had any ideas. I need to build a query where I select only the new people that have come in during a quarter that have children ages 0 to 5. (ie The person does not get counted if they came in during another quarter that year) I have been making multiple queries and runnning this report using VB6 code and it is very slow. Below is a list of my tables and other info: (I've simplified the tables to make it easier to list.)

Language\DB: VB6, DAO 3.6, Access Database

Tables\Queries:
tbl_Customer
l_Mem_id (Key)
dt_DateCreated
str_First_nm
str_Last_nm

Qry_Child
l_ID_id (Key)
l_Mem_id
dt_DOB
str_Name
l_age (l_Age: Int((DateDiff("d",[dt_DOB],Now()+1)/365.25))

Qry_Visit
l_ID_id (Key)
l_Mem_id
dt_Date
str_Reason
l_Quarter (l_Quarter: DatePart("q",[dt_Date])

Any help would be appreciated! Thanks Confused | :confused:

John Kuhn21-Feb-04 18:59

John Kuhn

21-Feb-04 18:59

Not sure if the exact syntax will work in Access, but here goes:

SELECT * FROM tbl_Customer WHERE
  l_Mem_id IN (SELECT l_Mem_id FROM Qry_Child WHERE l_age BETWEEN 0 AND 5) AND 
  l_Mem_id IN (SELECT l_Mem_id FROM Qry_Visit WHERE dt_Date BETWEEN @startdate AND @enddate)

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

xfitr221-Feb-04 20:57

21-Feb-04 20:57

Many thanks. I added a NOT IN statement to exclude them if they came in during another Quarter. One problem that I am having is the number of people is inconsistent if you run the query a couple of times. I even added people during earlier quarters that showed up during the specified dates and it would not show the person after I did a requery but the number of people would sometimes stay the same or change to 1 less and sometimes 2-3 times less people. I have inserted the revised SQL statement below Any suggestions?

SELECT * FROM tbl_Customer WHERE l_Mem_id In (SELECT l_Mem_id FROM Qry_Child WHERE l_age BETWEEN 0 AND 5) And l_Mem_id In (SELECT l_Mem_id FROM tbl_Visit WHERE dt_Date BETWEEN #4/1/2003# AND #6/30/2003#) And l_Mem_id Not In (SELECT l_Mem_id FROM tbl_Visit WHERE dt_Date BETWEEN #1/1/2003# AND #3/31/2003#)

John Kuhn22-Feb-04 6:05

John Kuhn

22-Feb-04 6:05

I think I see a possible issue here.

If a member has a visit between 4/1/2003 and 6/30/2003 and the same member has a visit between 1/1/2003 and 3/31/2003, is that member included or excluded?

Also, after I wrote this last night, I realized that the same query might be feasible with an INNER JOIN...

SELECT * FROM tbl_Customer 
  INNER JOIN Qry_Child ON tblCustomer.l_Mem_id = Qry_Child.l_Mem_id 
     AND Qry_Child.l_age BETWEEN 0 AND 5
  INNER JOIN tbl_Visit ON tblCustomer.l_Mem_id = tbl_Visit.l_Mem_id 
     AND (tbl_Visit.dt_Date BETWEEN #4/1/2003# AND #6/30/2003#)
     AND NOT (tbl_Visit.dt_Date BETWEEN #1/1/2003# AND #3/31/2003#)

xfitr222-Feb-04 6:57

22-Feb-04 6:57

They are excluded. They are only counted once a year. I tried to run your query and it returned no results. I tried playing with it a little and inner joining the Qry_Child and running subqueries on the tbl_Visit (IN and NOT IN) but only recieved errors.

Also, could you possibly explain the difference of when to join tables and when to use a subquery. I am still having trouble understanding the logic. Thanks.

John Kuhn22-Feb-04 7:54

John Kuhn

22-Feb-04 7:54

Yeah, I suppose joins are best applied when you want to include fields from table on both sides of the join statement, but they can be applied to form the basis for including or excluding rows. Since it was late last night, the idea of INNER JOINS might be flawed... I always seem to try several things until I get the one thing that works consistenly.

* thinking out loud *

SELECT table1.*, table2.* FROM table1 RIGHT JOIN table2 ON table1.key = table2.fkey WHERE ...

-- all rows from table2 and matching rows from table1

SELECT table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.key = table2.fkey WHERE ...

-- all rows from table1 and matching rows from table2

SELECT table1.*, table2.* FROM table1 INNER JOIN table2 ON table1.key = table2.fkey WHERE ...

-- only matching rows from table1 and table2

SELECT table1.*, table2.* FROM table1 FULL JOIN table2 ON table1.key = table2.fkey WHERE ...

-- all rows from table1 and table2

Ok, so that's the difference, using IN or EXISTS simply forms the basis for inclusion or exclusion of rows from the table specified in the FROM clause, whereas using a join does as described above.

So, it seems like your example should work consistently, unless the underlying data are changing so often that the results change accordingly. If you like, you can send me some or all of the data and I can try it out.

What a piece of work is man, how noble in reason, how infinite in faculties, in form and moving how express and admirable . . . and yet to me, what is this quintessence of dust? -- Hamlet, Act II, Scene ii.

xfitr222-Feb-04 8:25