Visual Basic

Re: Please help me in hurry!

26-Jul-07 23:09

chansothea wrote:
Please help me in hurry!

No.

I doubt anyone even knows what you're talking about, but either way, you want a site like Rentacoder. When you're paying, you can ask people to write code to your specifications. Here, people ask for help with code they have written.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dave Kreskowiak27-Jul-07 1:49

Dave Kreskowiak

27-Jul-07 1:49

Christian Graus wrote:
a site like Rentacoder. When you're paying, you can ask people to write code to your specifications.

You mean "attempt to write code...", don't you?? Laugh | :laugh:

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Stored Procedures - Recordset

Werries26-Jul-07 22:22

Werries

26-Jul-07 22:22

Hi there,

In the past I used SQL commands to retrieve recordsets from my DB. Now I moved those SQL commands to stored procedures in my DB to retrieve the recordsets. The main issue I have is that I cannot set the absolute position etc on that recordset from my stored procedure. Here is what I did in the past:

Dim rsRecord            As Recordset<br />
<br />
Set rsRecord = New Recordset<br />
<br />
rsRecord.Open "SELECT * FROM Customers", cnDatabase, adOpenKeyset<br />

If I open the recordset like the sample above I can get the rsRecordset.RecordCount, but if I use a stored procedure to fetch the same data into a recordset the rsRecordset.RecordCount property returns -1

Dim cmCommand     As ADODB.Command<br />
Set cmCommand = New ADODB.Command<br />
<br />
Set cmCommand.ActiveConnection = cnDatabase<br />
cmCommand.CommandType = adCmdStoredProc<br />
cmCommand.CommandText = " [dbo].[FetchCustomers]"<br />
Set rsRecord =  cmCommand.Execute<br />

rsRecordset.RecordCount = -1

How can I use a stored procedure to scroll through a recordset? Confused | :confused:

Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Re: Stored Procedures - Recordset [modified]

andyharman27-Jul-07 1:27

andyharman

27-Jul-07 1:27

Hi Werries

Your problem lays with the way that you are opening your recordset, rather than with the stored procedure. ADO is using the "adOpenForwardOnly" cursor-type in your second example. Try:

rsRecord.Open "[dbo].[FetchCustomers]", cnDatabase, adOpenKeyset, adLockReadOnly,  adCmdStoredProcedure

There are several other overloads for the Open method, including one that allows you to open the recordset from a command object.

Regards
Andy

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

Werries27-Jul-07 2:07

Werries

27-Jul-07 2:07

Hi Andy,

Maybe I must rephrase my problem and question. I wànt to use a stored procedure to fetch the information, but the way I retrieve the recordsets does not allow me to scroll the records in the recordset. I need to be able to set the absolute position of the recordset and then fetch records from there. If I use a SQL command to retrieve the recordset like in my first attempt, I can set the absolute position of the recordset, but if I retrieve a recordset through a stored procedure the recordset does not allow me to set the absolute position on it. It raises an error 3251, ‘Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.’ If I can change the cursortype when using a stored procedute that supports bookmarks it will be great.

I hope I have explained myself better this time. Thanks for your previous reply on this matter. Any other suggestions? Unsure | :~

Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

andyharman27-Jul-07 3:36

andyharman

27-Jul-07 3:36

I went back and modified my original reply to invoke your stored procedure. Your problem was caused by ADO using its default forward-only cursor type, rather than the keyset cursor type that you were originally using with your SQL select.

Werries27-Jul-07 5:08

Werries

27-Jul-07 5:08

Hi Andy,

I did see your modification on your first reply and applied it to my code, but it seems to me I still have a forward-only cursor type. When I'm trying to set the absolute position of the recordset the same error occurs 'Current Recordset does not support bookmarks....'

I still don’t have a solution for my problem, but I'm thinking of trying a whole different way of implementing what I actually want to do. But if you've got a solution of why the recordset still have a forward-only cursor type, I’ll be glad to hear it from you. I appreciate all your help.

Have a nice weekend,

Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Migration Of VB6 app to Vb .NET

andyharman27-Jul-07 6:11

andyharman

27-Jul-07 6:11

Hi Werries

If ADO doesn't think that a requested cursor-type is possible then it silently changes to another type.

I don't normally use bookmarks - so its not something that I have a problem with. I normally use GetRows() to grab the recordset's contents into a 2-dimensional array. This allows me to close the recordset and grab any output parameters.

Have a good weekend.

Regards
Andy

PS: Have you set "Set nocount on" in the stored procedure?

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".

birajendu26-Jul-07 21:37

birajendu

26-Jul-07 21:37

I have a application build around VB6 for windows, I want to change that application to VB .NET to run for Win CE. Can I do with the migration procedure?Or by any other means?

Thanx in advance...

birajendu
CyberG India
Delhi
India

Re: Migration Of VB6 app to Vb .NET

Christian Graus26-Jul-07 21:43

26-Jul-07 21:43

You basically have to do it by hand, they are very different languages.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Crystal Report Porblem

help as an alias26-Jul-07 19:47

26-Jul-07 19:47

Hi All,
I want to connect a crystal Report dynamically with database which changes accordingly but the table is same in all the database table name = “Stock “ Also I want to add condition
“SELECT * FROM Stock Where Date BETWEEN ‘xyz’ AND ‘abc’” Database is used by me is ACCESS.

Any one help me. Thanks in advance.

Nikesh Kr. Yadav

CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)

Paul Conrad26-Jul-07 20:19

26-Jul-07 20:19

What is exactly is your problem? You described what you were doing, but didn't really say what the problem is, thus can't really help you until you give better detail to the problem.

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

help as an alias26-Jul-07 20:24

26-Jul-07 20:24

just give the logic or code for the dynamic connection with crystal report Smile | :)

Nikesh Kr. Yadav

CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)

Paul Conrad26-Jul-07 20:31

26-Jul-07 20:31

Er nikesh yadav wrote:
just give the logic or code for the dynamic connection with crystal report

Nope. I don't work like that. The code I develop costs a substantial amount money and I only offer advise, not code.

Here is advice for the dynamic connection, assuming you have a connection string already setup, you can change them at runtime. I don't see any really descriptive problem here.

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

help as an alias26-Jul-07 20:35

26-Jul-07 20:35

sorry i forgot the please but i rally thank ful to you if u can explain some more i already tried your suggestion it doen't work please help me Smile | :)

Nikesh Kr. Yadav

CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)

Paul Conrad26-Jul-07 20:37

26-Jul-07 20:37

Er nikesh yadav wrote:
sorry i forgot the please

Don't worry about it, bro. Rose | [Rose]

I am just getting tired and cranky Poke tongue | ;-P

But do look up readings on Crystal Reports, even visit their site, they may have white papers to help you.

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

help as an alias26-Jul-07 20:40

26-Jul-07 20:40

thanks

Nikesh Kr. Yadav

CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)

Christian Graus26-Jul-07 20:38

26-Jul-07 20:38

I suggest you read up on how to ask questions. I can guarentee you that the advice you've been given, works. So, if you can't work out how to do it, try posting code and explaining what is going wrong, so we can help you to follow the advice you've been given.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Paul Conrad26-Jul-07 20:35

26-Jul-07 20:35

On a kinder note, I recommend you find some good literature on Crystal Reports since it seems you are asking alot of questions about it lately.

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

STOP !!!!

Christian Graus26-Jul-07 20:21

26-Jul-07 20:21

Looking at your message history, you post every question you have to at least three forums. Please don't do that, it's rude and annoying. Pick the right forum and ask there.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: STOP !!!!

Paul Conrad26-Jul-07 20:27