Database

Russell Jones6-Dec-05 4:25

Russell Jones

6-Dec-05 4:25

to add your own function create a COM dll whose name starts with CRUFL and place it in the same directory as u2lcom.dll on your machine. Functions declared in the dll will now be available to crystal reports.

I've used this before to translate report labels.

HTH

Russ

Russell Jones6-Dec-05 5:23

Russell Jones

6-Dec-05 5:23

Just to clarify about com dlls.

I have done this in the past using VB6 which created the dlls for me. Now that vb and c# 2005 express editors are available from MS free of charge i guess you could use these and generate interop assemblies to use with crystal.

i found this link on codeproject with a .net example

http://www.codeproject.com/dotnet/DecryptForCrystal.asp?print=true

HTH

Russ

achrafus7-Dec-05 7:40

achrafus

7-Dec-05 7:40

hi, and sorry again.
I followed the steps that are in the link and got some problems I couldn"t deal with. The first is that my DLL couldn't be registered within Windows. It says "No DLLRegisterServer Access point found"? I don't know what it means. The other problem is that within my project the "register for Com Interop is set to false but does not allow changes to true.
What I did is I created a new projet containing only the class needed to the translation an builded a new DLL named CRUFLctw.dll. Bt I 'm having the problem of Access point ??So the function still does not appear within formla staff in crystal report...
Please, I m really blocked and need your help

Thanks in advance

-- modified at 14:01 Wednesday 7th December, 2005

Russell Jones7-Dec-05 22:35

Russell Jones

7-Dec-05 22:35

My guess here, and it's only a guess is that you have specified a windows application as the project output type. This is in the General section of the common properties tab. If you change the output type to Class library and then close and reopen the properties window (apply is not enough for some reason) You should be able to change the value of register for com interop.

BTW do you know that you will have to have the .net framework installed on any client that you want to run this function?

What Isolation Level should I use

achrafus7-Dec-05 23:59

achrafus

7-Dec-05 23:59

thanks for your answer,
I checked the project output it's set to class library. I think the problem comes from the fact that when trying to register the dll using regsvr32 it does not find DLLRegisterServer entry point. the msg I got is mydll.dll was correctly loaded But the DLLRegisterServer entry point was not found. Unable to register within windows. (I got the msg in french , I think this is the eng version.)
I didn't know that I'll need to have the .net framework installed on my clients

The Liquidian6-Dec-05 1:30

The Liquidian

6-Dec-05 1:30

In my apllication, I read from 3 tables, I then make updates on the tables and then I read from them again, then I commit or roleback based on the information.

I want to make sure that from when I do the first read, that the database (or at least the 3 tables) is/are locked to that specific transaction. I do not want other clients to even read from the 3 table while the transaction is in progress.

I would like to know what Isolation Level is best for this?

Thank you.... Roll eyes | :rolleyes:

Re: What Isolation Level should I use

Farhan Noor Qureshi6-Dec-05 9:55

Re: SQL server 2000 backup

6-Dec-05 9:55

The default one i.e. "Read committed" is fine in this case.

Farhan Noor Qureshi

^{if (this == this) thow this;}

SQL server 2000 backup

tusar1235-Dec-05 23:55

tusar123

5-Dec-05 23:55

Hi,
I want to take backup my datbase with backup filename as string + system date .can You suggest me how it is possible in SQL server 2000 Using Scheduling.

Thanks in Advance

Manoj

Farhan Noor Qureshi6-Dec-05 10:02

Re: SQL server 2000 backup

6-Dec-05 10:02

You can write valid TSQL in different steps of your SQL jobs. In Enterprise Manager navigate to database server->Management->SQL Server Agent->Jobs and define a new backup job.
For example, I have a back up job defined in EM with one step having following code.

Declare @fileName nvarchar(250)
Set @fileName = N'C:\DBDailyBackup' + Replace(Replace(Replace(Convert(nvarchar(50), GetDate(), 20), ':', ''), ' ', ''), '-', '') + '.bak'

BACKUP DATABASE [pubs] TO  DISK = @fileName WITH  NOINIT ,  NOUNLOAD ,  NAME = N'pubs backup',  NOSKIP ,  STATS = 10,  NOFORMAT

You can also do it from Right click context menu on your database, choose All Tasks->Backup Database and define as schedule. Needless to say that you have to have SQL Agent service running for it to work properly.

Farhan Noor Qureshi

^{if (this == this) thow this;}

tusar12310-Dec-05 0:49

tusar123

10-Dec-05 0:49

Thanks For ur Solution
But I want To do It Through Enterprises Manager in Sql Server 2000. How We change the filename with Current date

Manoj

Selection + Selection + Selection

Sasuko5-Dec-05 21:48

Sasuko

5-Dec-05 21:48

i need to create a SQL query in my C# code,
serching for all selected control voices.
I have 3 or more controlls (combobox)
If the user select a voice for the first and third one for example i need to create a query made like this:
Select * from myTable where...
Value N = ComboBoxN Selected Voice
loop

i've tried but i doesn't work.
If i try a multiple join yes, but how can i realize it?

Re: Selection + Selection + Selection

Colin Angus Mackay5-Dec-05 22:41

Colin Angus Mackay

5-Dec-05 22:41

Your question doesn't make any sense to me. However, perhaps this is what you are looking for:

SELECT * FROM MyTable
WHERE (someColumn = @comboBox1Value AND @comboBox1Value IS NOT NULL)
OR (someColumn = @comboBox2Value AND @comboBox2Value IS NOT NULL)
OR (someColumn = @comboBox3Value AND @comboBox3Value IS NOT NULL)

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Database, selecting the primary key

steve_rm5-Dec-05 5:06

steve_rm

5-Dec-05 5:06

Hello,

I have a table called customer. I have other tables, but they are not important regards to this question.

This hold customers' details for their online account for a supermarket.
The fields are the following:
CustomerID bigint identy seed, Primary Key
Username nvarchar
Name nvarchar
Address nvarchar
City nvarchar
Postcode nvarchar
Password nvarchar

My question is. Do l need the customerID field as primary key. As username will be a unique value. No one will have the same username.

Like for e-mails, l have a username that is unique. Would I have another id as well. For e.g. Does yahoo have our usernames as our primary key fields?

I was thinking of desiging this database without the customerID, and only having username as the primary key.

Thanks in advance,

Steve

Re: Database, selecting the primary key

Duncan Edwards Jones5-Dec-05 6:15

Duncan Edwards Jones

5-Dec-05 6:15

If the user name is unique and invariant make it the key...however if it can be changed or is not unique you shouldn't.

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Re: Database, selecting the primary key

S Douglas7-Dec-05 0:15

S Douglas

7-Dec-05 0:15

steve_rm wrote:
Like for e-mails, l have a username that is unique. Would I have another id as well. For e.g. Does yahoo have our usernames as our primary key fields?

Using a User name as primary key is probably a bad thing. Think about it how many Mike Smiths are there in the world? The answer is there are a lot of duplicate names in the world.

Do you think everyone of your customers are willing to give you their email address? What about the poeple in the world that don’t have email?

Seems to me your better off using the int as a primary key for the table.

Just my 2 cents...

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

Save and retrieve picture

Mohammad Daba'an4-Dec-05 22:35

Mohammad Daba'an

4-Dec-05 22:35

hi, how can i save a real picture on the SQL DB and retrieve it. Smile | :)

Thanks alot
Hamody

Re: Save and retrieve picture

Farhan Noor Qureshi5-Dec-05 10:27

Server Explorer in NET VS.2003

5-Dec-05 10:27

Check out this[^]

Farhan Noor Qureshi

^{if (this == this) thow this;}

cduwel4-Dec-05 4:06

cduwel

4-Dec-05 4:06

Can anyone tell me why I am not seeing any SQL Server 2K user defined functions in the server explorer in VS.2003. The documentation talks about running a udf in server explorer by right clicking a udf in the udf folder - Well I ain't got no stinking udf folders in any SQL Server databases although I know they are there. Using professional edition.
Thanks
Confused | :confused:

cduwel

Binding Database to multiple controls

Taen_Karth3-Dec-05 21:27

Taen_Karth

3-Dec-05 21:27

This was posted in the VB forum as well since I was not sure which it pertained to.

Ok, not sure exactly how to word this so here goes. I have a winform in my project that has the following:

Controls

1. DropDownList1 - Customer Name
2. TextBox1 - Customer ID
3. DropDownList2 - Site Name

DataBase Tables

1. tblCust - Fields(CustName, CustID, Status)
2. tblCustSiteAssoc - Fields(CustId, CustSiteID)
3. tblCustSite - Fields(CustSiteID, CustSiteName, ...)

What I am trying to do is this:
1. When the form open have customers names bound to the DropDownList1 control with nothing selected
2. Once I select something in the DropDownList1 control (SelectedIndexChanged) have it update the other two controls with the selected customers' data.

I assume I make a DataSet that queries all three tables and I understand how to bind the CustName to the first DropDownList box. What I don't understand is how to use the selected information to get the relevant information for the other two controls.

Thanks in advance,

Taen Karth

Thanks,

Taen Karth

Can ADO be used in C (not C++)

FFKONG3-Dec-05 12:36

FFKONG

3-Dec-05 12:36

Can ADO be used in C (not Visual C++), using Microsoft Visual Studio? Is there any sample code on this? Thanks.

Rob Graham3-Dec-05 15:24

Rob Graham

3-Dec-05 15:24

Since ADO is a COM server, I would doubt it.

Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke

Matt Gullett3-Dec-05 17:18

Matt Gullett

3-Dec-05 17:18

Probably not directly, but there is nothing stopping you from creating a Windows DLL that wraps the ADO class heirarchy in a set of public functions. This DLL could then be used in straight C.

FFKONG4-Dec-05 22:01

FFKONG

4-Dec-05 22:01

This DLL is not only be used by C, but also other client languages like Delphi, Borland C++, VB.NET etc. I am still figuring out how to wrap this ADO in the DLL so that it can be called by all client languages. Do you have any sample code or references that I may refer? Thanks.

Farhan Noor Qureshi5-Dec-05 10:28