Database Discussion Boards

Deleted entries reappearing in Access 2000 DB?

mav.northwind16-Aug-05 20:28

16-Aug-05 20:28

Hi community!

I was wondering if anyone has experienced a similar behaviour and knows how to fix it...

Recently I was told that a DB app I've written some time ago (using an Access 2000 DB) is showing entries that were deleted some time ago.

Another, perhaps connected behaviour report came from another customer, where I was told that some database entries were not visible for several hours. The INSERTs ran OK, as the log files prove, but querying the data from a client program didn't show the new entries (there were no error messages or anything, just an empty DataSet. Don't have client side logs, though.). I couldn't reproduce the behaviour, though, and the customer can't, either.

Is this something you'll have to expect when using Access 2000? Until now I was under the impression that, yes, it's not the greatest or fastest of databases, but it's easily setup and works well with databases up to about 100MB. The mdb files we're talking about are both about 8MB, with approx. 15 tables, so I didn't expect there to be a problem.

Thankful for any feedback,

mav

how to accessing Paradox use ADO

ebinaini16-Aug-05 19:20

ebinaini

16-Aug-05 19:20

can someone plz give me a tutorial on how to accessing Paradox useing ADO.
i'd like to do it completely in Win32/SDK also

Thanks In Advance,
bin e

nothing

.NET SQL Stored Procedures

Carl Mercier16-Aug-05 6:36

Carl Mercier

16-Aug-05 6:36

Hi,

I am creating a simple SPROC in .NET (SQL Server 2005) and I want to send the content of a DataTable to the pipe. I'm not sure how to do this (all this is still quite new to all of us!).

Pipe.Send takes a SqlDataReader or SqlDataRecord as an argument. However, the DataTable can only return a DataTableReader with CreateDataReader.

Is there a way to cast something into something else to make this work? Casting the DataTableReader to a SqlDataReader doesn't work.

Thanks!

Triggers Problem [modified]

Faheem Habib15-Aug-05 23:23

Faheem Habib

15-Aug-05 23:23

i want to generate a trigger on a table whenever the date of the system changes. Can any one help me.

Programmers Solutions is QAU Programmers

http://www.qauprogrammers.com
http://www.linksexchangedirectory.org
http://www.appleiphonetricks.com
http://www.dubaieclassifieds.com
http://www.eshopsdubai.com
http://www.faheemhabib.com

modified on Thursday, February 3, 2011 7:41 AM

Re: Triggers Problem

ToddHileHoffer16-Aug-05 10:23

ToddHileHoffer

16-Aug-05 10:23

You need to create a sql server agent job an run it daily. You can't run a trigger on on insert update and delete.

"People who never make mistakes, never do anything."

My blog
http://toddsnotsoamazinglife.blogspot.com/

need help about analysis service connection

ianpeter15-Aug-05 21:25

ianpeter

15-Aug-05 21:25

i have problem to make connection to Server of Analysis Service in other computer. It's easy if i use local server, but i need to connect other server.
Can somebody help me?

NB: error message that show is "the server is either not started or too busy"

anwhat's wrong with my cursor!!!!!!!!!

under281115-Aug-05 21:11

under2811

15-Aug-05 21:11

Hello
I have empt table where job_id is field in it.
I want to update empt table if job_id = '1' or '3' by '999'
And if job_id not '1' or '3' then update by '456'
So what's wrong with my cursor

T.I.A
Shashank
-----------------------------------------------------

CREATE procedure lnt.textt
@qurstr varchar(10)

AS
Declare @in AS Varchar(10)

Declare crs_cc cursor for select job_id from empt FOR UPDATE OF job_id

open crs_cc

fetch next from crs_cc INTO @in

while @@fetch_status = 0

IF @qurstr = '1' OR @qurstr = '3'
BEGIN
UPDATE empt set job_id = '999'
where job_id = @qurstr
print 'U Miss By Miles!!!!'
print @qurstr
END

IF @qurstr IN (SELECT job_id from empt where job_id not in ('1','3'))
BEGIN
update empt set job_id = '456'
where job_id = @qurstr
print ' Success'
END

FETCH NEXT FROM crs_cc

CLOSE crs_cc

DEALLOCATE crs_cc

GO

Re: anwhat's wrong with my cursor!!!!!!!!!

Colin Angus Mackay15-Aug-05 22:11

Colin Angus Mackay

15-Aug-05 22:11

I don't understand what you are trying to do with your code, but from your description at the top the update can be done much much faster without a cursor.

UPDATE empt
SET job_id = '999'
WHERE job_id IN ('1', '3')

UPDATE empt
SET job_id = '456'
WHERE job_id NOT IN ('1', '3')

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

How does .NET Data Provider for SQL Server convert varchar data to Unicode?

GlennBits15-Aug-05 6:46

GlennBits

15-Aug-05 6:46

After executing a select query the data provider returns the value in a varchar field in a .NET Unicode string, how does it determine the encoding conversion to perform? My guess is that it's determined by the collation setting on the column, but I'm not sure? For example, if the collation is SQL_Latin1_General_CP1_CI_AS, the Provider converts from code page 1252 to Unicode.
Does anyone know for sure the strategy applied here?

SQL Problem

WDI15-Aug-05 3:39

WDI

15-Aug-05 3:39

Hi
I have a table T with columns ID(int) , visible(bit);

visible cells are 1 or 0;

when i write "SELECT visible FROM T " in the query analyzer i got list of 1 and 0;

when i write "SELECT visible FROM T " in the VS in a sp and run it i got a list of 0 and -1 instead 1

WHY ?

Re: SQL Problem

Colin Angus Mackay15-Aug-05 5:01

Colin Angus Mackay

15-Aug-05 5:01

Shouldn't bit columns be cast into bool values? That way you will get true and false.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

SQL Error Handling...

Illegal Operation15-Aug-05 0:51

Illegal Operation

15-Aug-05 0:51

Can someone please help me with error handling in SQL 2000? If an entry allready exist then the user must not be able to add the duplicate and he must be warned that there is a duplicate.

Illegal Operation

Making Computer Software Talk

Re: SQL Error Handling...

Vasudevan Deepak Kumar15-Aug-05 0:54

Vasudevan Deepak Kumar

15-Aug-05 0:54

The table can be configured with the column constrained as 'UNIQUE'. This way, SQLServer itself would Raise an exception, which you can handle.

Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/

Re: SQL Error Handling...

Illegal Operation15-Aug-05 20:31

Illegal Operation

15-Aug-05 20:31

I have configured the table with the unique constraints but now I want to catch the error generated by SQL and then display or give it a meaningfull way to handle.

In other words, when the error occurs in SQL, I need to redirect the user to another page.

Illegal Operation

Making Computer Software Talk

Re: SQL Error Handling...

ToddHileHoffer16-Aug-05 10:26

ToddHileHoffer

16-Aug-05 10:26

Declare @intErrorCode int<br />
select @intErrorCode = @@Error<br />
<br />
begin transaction<br />
<br />
If @intErrorCode = 0<br />
begin<br />
-- insert SQL Statement<br />
set @intErrorCode = @@Error<br />
end<br />
<br />
If @intErrorCode = 0<br />
begin<br />
-- insert another SQL Statement<br />
set @intErrorCode = @@Error<br />
end<br />
<br />
<br />
IF @intErrorCode = 0<br />
commit transaction<br />
else<br />
rollback transaction<br />
return @intErrorCode

To handel the error in your page use the

Try <br />
Cmd.ExecuteNonQuery<br />
catch ex as sqlclient.sqlexception<br />
'Put code to redirect<br />
End Try

"People who never make mistakes, never do anything."

My blog
http://toddsnotsoamazinglife.blogspot.com/

primary key performance

ppp00114-Aug-05 20:33

ppp001

14-Aug-05 20:33

Hi,

In a relational database, I would to like to know the performance difference between of using a string and an integer as the primary key field for the tabl;e. Will a column field of integer be indexed faster than a string column field ?

Thanks

Re: primary key performance

Colin Angus Mackay14-Aug-05 23:09

Colin Angus Mackay

14-Aug-05 23:09

CraigBurton wrote:
Will a column field of integer be indexed faster than a string column field ?

Yes, simply because the key will be smaller. The smaller the key the faster it can be indexed and retrieved because the index will be smaller overall and it won't have to pull so much data off the disk in order to scan the index.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: primary key performance

ppp00114-Aug-05 23:29

ppp001

14-Aug-05 23:29

Thanks

Besides integer is smaller than string, will implicitly
the indexing of integer is faster than string, if they are of
similar length ?

How about for the retrievel after indexing, should be same ?

Re: primary key performance

Colin Angus Mackay14-Aug-05 23:39

Colin Angus Mackay

14-Aug-05 23:39

If you use a CHAR or NCHAR then I doubt there will be much difference. If you use a VARCHAR or NVARCHAR then there is additional complexity due to the variable lengths possible.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

no item error

Anonymous13-Aug-05 23:37

Anonymous

13-Aug-05 23:37

when i expand the enteprize manager i get the no item error .i increase any time in the option but no advantage... .! i am not the owner of the database .is this is the reason of that error.

Closing a connection opened by ADODC

Maitre Capelo13-Aug-05 2:14

Maitre Capelo

13-Aug-05 2:14

Hi,

I have written a VB6 program that uses a datagrid bound to a ADO data control. I do the following:

Adodc1.ConnectionString = "DSN=" & m_objSentryDB.DSN & ";uid=" & strUserID & ";pwd=" & strPassword
Adodc1.RecordSource = strSQL

Set DataGrid1.DataSource = Adodc1

This is working fine, however, when I want to close the program, how do i CLOSE the connection opened by the ADODC control? I am using a sybase database, and they is basically one ghost connection on the server remaining after each use of the program. I looked for a 'close' method on the ADODC object, but to no avail.

Also, what is the correct way to refresh the grid after the underlying table has changed? I use adocdc1.refresh, but this seams to knock out the display properties of the grid (size, caption etc).

Any ideas?

thanks

Maitre Capelo

ado.net and sql

Micu Valentin12-Aug-05 10:54

Micu Valentin

12-Aug-05 10:54

please anybody knows in c# how can I add new records in joined tables?

Re: ado.net and sql

Colin Angus Mackay14-Aug-05 23:10

Colin Angus Mackay

14-Aug-05 23:10

Micu Valentin wrote:
how can I add new records in joined tables?

You add a row to the parent table first, then add the rows to the child table. The child table is the table with the foreign key to the parent table.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: ado.net and sql

Micu Valentin14-Aug-05 23:25

Micu Valentin

14-Aug-05 23:25

i was talking how to do it by code in c#.
can you help me with an example?
i have 1 table: person_id, person_name
second table: number_id, person_id, telephone no:
the relashion is 1 to many.
how can i add a record that the person_id to be in both tables automatically like in microsoft access?
do i have to use the DataRelation?
waiting

Re: ado.net and sql

Colin Angus Mackay14-Aug-05 23:36

Colin Angus Mackay

14-Aug-05 23:36

I was giving a higher lever overview because you insert/update it as two single tables rather than one joined table. I assumed you already knew how to do that.

Here is a simple example:

// First insert the parent row
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection; // Replace this with your connection object
cmd.CommandText = "INSERT table1(person_id, person_name) VALUES (@person_id, @person_name)";
cmd.Parameters.Add("@person_id", 1);
cmd.Parameters.Add("@person_name", "Joe Bloggs");
cmd.ExecuteNonQuery();

// Now insert the child row
cmd = new SqlCommand();
cmd.Connection = myConnection; // Replace this with your connection object
cmd.CommandText = "INSERT table2(number_id, person_id, telephone_no) VALUES (@number_id, @person_id, @telephone_no)";
cmd.Parameters.Add("@number_id", 10);
cmd.Parameters.Add("@person_id", 1);
cmd.Parameters.Add("@telephone_no", "+44 131 332 4455");
cmd.ExecuteNonQuery();

Does this help?

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

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