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...

Sorry everybody, stupid me, didn't see that I had the following command before the = "20" DataGridView3.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells It works fine now!! Thanks

Hi Noel, unfortunately isn't doing anything, not changing the width of the column. Regards

Hi, thanks for replies, unfortunately it is not what I am looking for. I want to adjust one column in a datagridview. If I use, datagridview1.column[0].width = 20, it gives an error? why is that? thanks

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 thanks man, I am using MySQL, and delphi 2006. The thing is, I am searching for people in my database and then populate the dbgrid with the results, so the person using the system, can then select the person in the dbgrid and it loads another page then. So I don't know how to do it without...

thanks for the reply, is there then any other way to display information like a dbgrid, but without a dbgrid? or hwat should I do now?

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

Ok here I am posting everything now Productioncalc Table CREATE TABLE `productioncalc` ( `agent code` varchar(12) NOT NULL default '', `policy number` varchar(25) NOT NULL default '', `group name` varchar(200) NOT NULL default '', `branch` varchar(255) default NULL, `title`...

Yes but I am using left join so as to get all the data from the first table and only those values where they have a pair in table 1 from the other tables. so normal select with 2 left joins? But its not working correctly?

No unfortundely not, but is it possible tojoin three tables? 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

Hi thanks man but unfortunedly MySQL 4 doesn't allow nested selects. I have to get another way? thanks for the help

O ja and by the way thanks, but it still stays SQL, I just need another way to write the query. Thanks

Sorry I moved my query to MySQL Forum. 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 |...