Search results for query: *

Hi, I created a package with SQL 2005. The package gets the Access DB and then inserts it into SQL Server. If I open the package in .NET, I can see the SQL Task and Data Flow Task. The SQL Task has a property sqlstatementsource, which has the necxessary SQL code to create the tables. How can...

Hi, I am trying to set the column size of the datagridview. with the statement : datagridview1.columns[0].width = 20 but it gives me the following error : property access must assign to the property or use its value? Can anybody help please?

Hi all, I want to know how to rewrite this better, because I know there must be. I tried enumerations but failed? I get the month from readline in file and have to convert it to 01,02 etc. month := leftstr(rightstr(A[8],8),3); if (month = 'Jan') then monthnr = '01'...

hi all, I have a problem. I retrieve data from adoquery and then set a datasource dataset to the adoquery. then I set the datasource of a dbgrid to the datasource itself. if the adoquery has the cursorlocation set to : cluseclient, then everything works well, but if I set the cursorlocation to...

hi all, I was just wondering? When you create an application that makes use of lets say a DB etc. You then open the application and it starts running, but if you open a normal window over your application, and you want to go back to your app, it is all white, or shows not responding, but it is...

hi all, in my mysql DB my field is float 10,2. i have normal query in crystal 10 pro, selecting all data. If I look at the field type in field exploer, it says the field is string[23], why is that? it should be number? because in the Db it is a number? So I can't sum that field or do any...

Hi everybody, could you guys maybe help, how do you guys debug stored procedures? Is there function to pause a procedure at a certain point so you can look at variables in command prompt? thanks

Hi, is it possible to join threee tables in one join? One table is people, other children and other assets? I want a list of all the people with their child name and assets name? So like this: name | chilc name | assets name | thanks

I have 2 tables with a group name, date and premium column I want to sum both of them for a specific month. Table 1 -------- group 1 | 2005-12-01 | 50 | group 1 | 2005-12-01 | 50 | group 2 | 2005-01-01 | 40 | group 1 | 2005-01-01 | 50 | group 1 | 2005-12-01 | 40 | Table 2 -------- group 3 |...

I have 2 tables with a group name, date and premium column I want to sum both of them for a specific month. Table 1 -------- group 1 | 2005-12-01 | 50 | group 1 | 2005-12-01 | 50 | group 2 | 2005-01-01 | 40 | group 1 | 2005-01-01 | 50 | group 1 | 2005-12-01 | 40 | Table 2 -------- group 3 |...

Hi I have the following query, but it seems inner selects take much longer to execute. Is there a better way with joins to write this? SELECT @group := c.`group name`as 'Group Name', (select companyname(@group)), (select sum(umbrella_premium+pensioner_premium+seniorplan_premium) from...

If I have a table like this : name | money | date -------------------- group 1 | 10 | january group 1 | 10 | february group 1 | 10 | march another table with memebrs in it. I want to sum the money in the first table, and do a count on the second table, to see how many members the group has...

If I have a table like this : name | money | date -------------------- group 1 | 10 | january group 1 | 10 | february group 1 | 10 | march another table with memebrs in it. I want to sum the money in the first table, and do a count on the second table, to see how many members the group has...

Hi, I have this query that works fine, select a.`group name`,a.umbrella_premium,a.money_received,sum(d.amount_paid) from schedule_premiums a,groups c left outer join claim_payment_new d on c.`group name` = d.`group name` where a.`group name` = c.`group name` and c.`group name` = b.`group name`...

Hi I created a report with code and the tab functions in rave report and connected with a DB. I return the surnames of people but when I review the report, it only generates the first page? Why is that? Is there a setting to set? Thanks

Hi, I have been using Crystal Reports 9 with delphi and use the code crpe1.show to show the report. Unfortunetly it is getting really slow to do it like that? was wondering if there isn't a crystal viewer in delphi like in .Net?

Hi all, can somebody maybe help me? How does the repository work? Where do I set it up so I can log into it? Where can I find information about the repository? thanks

Hi, I have a report with a lot of subreports, but it is going really slow, when I export the report throught delphi and then preview it, it takes ages to turn to the next pages. Is there a way to increase the speed. thanks

Hi, I have a table with fields char, char and auto increment number. In a sub report I wan to use that auto increment number as my parameter, but cannot seem to link to it. Can you only link to char values in sub reportS? Thanks

Hi, if I have a main report and a sub report, send to variables from the sub to the main through shared variables, can I use them in a chart? if not, what can I do to be able to use them?