SQL cookbook - Database Discussion Boards

Re: Access Not Saving Data (Sometimes...)

Expert Coming2-Sep-07 17:45

Expert Coming

2-Sep-07 17:45

Yes, my code all works as far as C#. Is is when the users are actually in the database using its forms and tables.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Access Not Saving Data (Sometimes...)

Paul Conrad2-Sep-07 5:34

Paul Conrad

2-Sep-07 5:34

Expert Coming wrote:
through forms in the database(horrible I know, but my employer will not pay me to write all that code)

I can relate to that from a few experiences out there.

Expert Coming wrote:
say that SOMETIMES, it doesn't save the changes, which contradicts both computers with the sometimes, and Access since it writes constantly.

Is there any kind of record-level locking going on? Access can let you turn such a thing on and off...

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: Access Not Saving Data (Sometimes...)

Expert Coming2-Sep-07 17:46

Expert Coming

2-Sep-07 17:46

Not sure, it would be the default which I am sure is locked. Do you know what the default is?

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Access Not Saving Data (Sometimes...)

Paul Conrad3-Sep-07 5:48

Paul Conrad

3-Sep-07 5:48

I think the default is set to No Locking. Or your problem could be something completely different, though.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Get Max of a column from database

.NET_Labview31-Aug-07 10:32

.NET_Labview

31-Aug-07 10:32

hello all,

i am working on a application to get the last updated date for a table. the date is already in the table in the UPDATE_TIMESTAMP column. Now the following code is not getting the result for me. can anyone help? I am getting an insufficient priviliges error

public static string GetLastUpdateTime()
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT MAX(updated_timestamp) lastUpadateTime FROM TABLEA");
OracleHelper oracleHelper = new OracleHelper();

string sql = sb.ToString();
object obj = oracleHelper.ExecuteScalar(Utility.GetConnectionKey(),CommandType.Text,sql);

if (obj == DBNull.Value)
{
return "";
}

return ((DateTime)obj).ToString("mm/dd/yyyy");
}

Re: Get Max of a column from database

Expert Coming31-Aug-07 13:32

Expert Coming

31-Aug-07 13:32

Is this a misspelling or did you do this in the table too?

.NET_Labview wrote:
sb.Append("SELECT MAX(updated_timestamp) lastUpadateTime FROM TABLEA");

'lastUpadateTime'

I think it may be spelled as 'lastUpdateTime' in the database.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Get Max of a column from database

.NET_Labview1-Sep-07 13:53

.NET_Labview

1-Sep-07 13:53

Thanks expertcoming!!

this is just an Alias used to represent the result set..though I agree this is a spelling mistake.....

now based on what I have found I need to know if we can have a dataset having a single value as resultset.

Can you tell me if we can have one value as a dataset......

SQL cookbook

DQNOK31-Aug-07 9:51

DQNOK

31-Aug-07 9:51

Does anybody know of a good on-line SQL "cookbook"?

I see that O'Reilly actually publishes a book by this name, but it is a book (perhaps not as googleable as online source). I see the same questions keep popping-up here repeatedly, and it's difficult to locate the "search forums" dialog here at codeproject (it took me a good while to locate it). Perhaps folks could get quicker answers to their specific questions if a searchable cookbook was readily available.

Actually, even having the Search function here at codeproject apply to the forums (instead of just Articles and Authors) would reduce some of the noise. But even then, a well written, easily searchable cookbook would sure be nice.

David

Re: SQL cookbook

Vasudevan Deepak Kumar1-Sep-07 1:22

Vasudevan Deepak Kumar

1-Sep-07 1:22

How about BooksOnline?

http://msdn2.microsoft.com/en-us/library/ms130214.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: SQL cookbook

DQNOK10-Sep-07 6:15

DQNOK

10-Sep-07 6:15

Thanks for the reply.

Actually, I had in mind more of a "cookbook"; simple pre-packaged answers to common issues and questions like the ones that crop-up repeatedly within this forum. Good link anyway. Think I'll download it!

David

insertin data into new table

rcwoods31-Aug-07 8:28

rcwoods

31-Aug-07 8:28

hi.
could someone please help me out.
im tryin to take data from one table, summarize it, and insert it into a new table.

what i have is a current 'daily' stats table for a user. but now what i want to do is take that data and add up 7 days worth of stats for each user. so, in other words, i have the last weeks stats for each user.

basically i need to know how to select data out daily table and then insert into weekly table.

Thanks!

Re: insertin data into new table

Colin Angus Mackay31-Aug-07 8:36

Colin Angus Mackay

31-Aug-07 8:36

The INSERT command can contain a SELECT

INSERT INTO Destination
SELECT Column1, Column2, Column3
FROM SourceTable

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

Re: insertin data into new table

DQNOK31-Aug-07 10:07

DQNOK

31-Aug-07 10:07

Depending on what you mean by "summarize it", I suspect you may be looking for a "GROUP BY" construct.

INSERT INTO tblWeekly
SELECT userName, SUM(stats)
FROM tblDaily
GROUP BY userName;

Can you give a few-record example of 'daily stats' and then what a summary of those stats should look like in the weekly table?

David

Re: insertin data into new table

rcwoods2-Sep-07 0:01

rcwoods

2-Sep-07 0:01

thanks for the reply.

i have a table "DailyUsage", which has 3 fields, namely Username, TheDate, DailyCount. primary key is a combination of Username and TheDate.

Now, because this table is pretty big, cos its storing daily usage for the last year, I want to do a sort of round robin methodoligy so my reports can run alot quicker.

So, ive created a table called "weeklyUsage" which will have Username, TheDate, and WeeklyCount. tbl WeeklyUsage will have only for example the last 3 or 4 weeks of data in it. So, I need to do a SUM of DailyCounts for each username for the last 3 or 4 weeks and then insert into tbl WeeklyUsage...

Re: insertin data into new table

DQNOK10-Sep-07 4:01

DQNOK

10-Sep-07 4:01

Sorry about taking so long to respond; I have been out of town.

How about

INSERT INTO weeklyUsage
SELECT Username, SUM(DailyCount)
FROM DailyUsage
GROUP BY Username
WHERE TheDate > DATE() - 21;

to get summaries for the last three weeks.

David

Re: insertin data into new table

rcwoods10-Sep-07 11:04

rcwoods

10-Sep-07 11:04

thanks for the reply.

i tried that DATE() function but its not working, im using SQL Server.dont know if thats the problem.
Is that 'DATE()' suppose to give me the current date?

Re: insertin data into new table

DQNOK10-Sep-07 11:08

DQNOK

10-Sep-07 11:08

Yes, the current date. In Oracle, it's "SYSDATE()" plus some other synonyms. I don't use SQL Server, and don't know what it wants.

Since you didn't give examples, I am not sure the query I provided will give what you want, but from your description, i *THINK* it's what you want. Let me know how it turns out.

David

Re: insertin data into new table

rcwoods15-Sep-07 3:51

rcwoods

15-Sep-07 3:51

yes, it works.
its GETDATE() for sql server.

Thanks Alot! Smile | :)

SQL PERVASIVE 9.0

marclenoir200531-Aug-07 6:22

marclenoir2005

31-Aug-07 6:22

Good morning guys,

i'm using sql pervasive 9.0 for accpac. I have a password on one of my databases, so that i can't get in. I would like to remove it(i mean reset the old password) and set a new one.

Someboby please can help me find any solution about this?

Regards.

Re: SQL PERVASIVE 9.0

Vasudevan Deepak Kumar1-Sep-07 1:24

Vasudevan Deepak Kumar

1-Sep-07 1:24

Did you check with the Customer Support?

Clickety[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: SQL PERVASIVE 9.0

marclenoir20057-Sep-07 3:44

marclenoir2005

7-Sep-07 3:44

not yet! thanks for your advice. try it today.

COBOL AND MS SQL

A.R.Bhagirathi30-Aug-07 23:00

A.R.Bhagirathi

30-Aug-07 23:00

Hi all

I need to get some information on how cobol handles database? and how can we access the MS SQL Database from ACUCOBOL?

I would really appreciate if any body can forward links on this topic,
Bhagirathi

Re: COBOL AND MS SQL

Colin Angus Mackay30-Aug-07 23:50

Colin Angus Mackay

30-Aug-07 23:50

Have you tried this link?[^]

Re: COBOL AND MS SQL

A.R.Bhagirathi31-Aug-07 0:40

A.R.Bhagirathi

31-Aug-07 0:40

Hi colin

Thanks fr your time , i did go thru some sites, actually i don't know cobol at all and i am looking for code logic to access sql databse from cobol and how different it is from access any dbms

i am not able to spot any good code refernce i have checked out
cobug-cobol users group and some other sites, i need a basic idea that is all

Regards
Bhagirathi

Re: COBOL AND MS SQL

Colin Angus Mackay31-Aug-07 1:02

Colin Angus Mackay

31-Aug-07 1:02

Since SQL Server is a relational database I would imagine that the way you access it is fairly similar to any othe relational database system.

Of course, COBOL has such a long legacy that it has connected to all manner of weird and wonderful databases in its time.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.