Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: morfasie
  • Order by date
  1. morfasie

    Refresh Dataflow Task & SQL Task

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

    Datagridview column size

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

    Datagridview column size

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

    Datagridview column size

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

    Datagridview column size

    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?
  6. morfasie

    How to rewrite this better

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

    problem with ADO and unidirectional

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

    problem with ADO and unidirectional

    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?
  9. morfasie

    problem with ADO and unidirectional

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

    program not responding

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

    problem with strings and float

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

    Stored Procedures

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

    Joins

    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`...
  14. morfasie

    Joins

    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?
  15. morfasie

    Joins

    No unfortundely not, but is it possible tojoin three tables? thanks
  16. morfasie

    Joins

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

    joins or inner selects

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

    Using Join or normal selects

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

    Using Join or normal selects

    Sorry I moved my query to MySQL Forum. Thanks
  20. morfasie

    joins or inner selects

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

Part and Inventory Search

Back
Top