Recent content by Mirak

Hi, ok that is it yes and yes we need to have a .h and .cpp file. And yes he have asked us to use / and %. thank you very much.

#include <iostream> using std::cout; using std::cin; using std::endl; #include <string> // program uses C++ standard string class using std::string; using std::getline; // Class DigitSeparator definition class DigitSeparator { public: // this...

Ok thanks

LOL. ok can you help me out I don't want anyone to do it for me I just want to start the steps.

Create a class called DigitSeparator. This class will only have one function called separator. Function separator will have ONE parameter of type long int which will be used to accept a six-digit number. Function separator will take the number passed to the parameter and separate it into its...

2) Each user has his/her own SQL username and password I am not using a trusted connection.

Hi I want to code a form that will enable the user to change his/her password from with a VB application. I already have the form to allow the user to connect to sql server in the vb application. But now i want to allow the user to change his logon from within the vb application. Is this...

Hi, I finally got it to work. I basically used the SET DATEFORMAT ymd as suggested by SQL Bill. This will tell SQL what date format to expect. That was half of the solution. The other half, as rsinj pointed out, the date might not be coming across correctly to SQL Server. Using the CDate()...

Hi, I tried your suggestion but SQL still had some problems. When I used the Cdate() function to convert my parameter, SQL report a problem with the '/' in the date. However, when I view the data in the actual table (thru Enterprise Manager), the date field date format is dd/mm/yyyy. How can I...

Hi, I am having major league headache with SQL Server. I am trying to write a report which will execute a stored procedure based on certain parameters. Two of the parameters in the stored procedure are datetime data types. My main problem is passing the date value from an Access form to the...

Hi, How can I pass optional parameters to a view when it is called from a stored procedure. Basically I want the recordset from the view to be filtered based on criteria requested by the calling procedure. I do not want the view to return records that are not needed for my report. Furthermore...

Hi, I need some urgent assistance. I need to create views for a report, but the data that I need resides on different tables on two different databases on SQL Server. Is it possible to reference tables across databases. I know in MS Access its easy to link the tables and write the query, but I...

Hi, I have a main report in crystal report, which has a formula field showing a running total. However, I also inserted a subreport which provides a brought foward figure that I want to include in the running total of the main report. How do I tell the main report to use the brought foward...

I have a main report with two subreports inserted in it. I am running the report from a vb application. All three reports use the same data file which is an access .mdb. My major problem is that the report will only run locally thru the application. when I try to run it over the network, it...

Thanks ZahidKhan03, I thought about that possibility, but the database is also password protected therefore its unlikely (but not impossible) that unauthorized users would open the database from outside the application. Is that the only reason a database would become corrupt? As I mentioned, in...