Recent content by DaveMere

Hi all, I need to replicate all the stored procedures in a database. I've generated a DDL to re-create them, but for some reason the DDL does not contain the GRANT statements required to allow my various user groups access to the procedures. The GRANT statements are generated when I run the...

I don't know about that, but have you considered using nested queries instead?

Hi all. Does anyone know of a way in which I can search all the stored procedures in a database for a particular table name? I have to make a slight change to the structure of one of my tables and would like to know precisely which stored procs I'll have to alter as a result. Cheers, DaveMere

Open Sybase Central, open the database, find the view, then open the script.

Call the stored procedure by name, in the same fashion as you would pass through any SQL string from VB. For example. you might pass a simple SQL string like so; strSQL = "SELECT * FROM <tablename>" Set mRs = mCn.Execute(strSQL) To call a stored procedure you should replace strSQL with the...

Hi all. Is it possible to re-order the contents of a 2-dimensional array according to the contents of one field? I have an array; LOC(1 to 5, 1 to n) which consists of n returned records with 5 fields each. I'd like to reorder this array several times in the same function, each time ordering...

It all works fine now. Thanks to you all - this was of great help. DaveMere

Thanks Dimandja, but I'm afraid I still can't get this to work. I copy the code from that link into my application; but what do I do with the actual vbSendMail exe that I downloaded? How does my application use the vbSendMail code? Cheers, DaveMere

Hi all. Is anyone familiar with sending email from VB applications using the vbSendMail download? I've downloaded the program and it works fine when running independantly. What I'd like to do though is to send an email automatically from an application of mine when a certain function is...

Yes, I can imagine all the Nuns who read this forum are most offended by my foul language.

Ah right. We actually use Pegasus Mail. Is there anyway I can set up MAPI commands to use Pegasus or has Microsoft got me?

Hi, I've been trying to find a way of sending emails automatically through VB, and I've been usign the MAPI functionality. Initially the system crashed because of a lack of a certain mapi32.dll file, which I have since located and copied to my C drive. Now however when I run the line...

Hello all. I'm having problems with handling errors returned from a Sybase database. We use an ODBC driver with ADO as an access interface. The problem is when the database returns an error for some reason, the connection object supplies no numbers associated with the errors. It recognises that...

I can't find the mapi.dll anywhere. I'm a little confused about all this to be honest. We don't use Outlook Express, and the techs seem to think that direct mail from VB using mapi isn't going to work. What about sending the mail via a direct UNIX command? Can you send a line of unix code...

I use Pegasus Mail 3.1 on Windows NT. How might I find out if the MAPI subsystem is installed (and what is it?)