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 Rhinorhino 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: *

  1. bowens44

    display MySQL date field in DBaware components

    I am using Delphi 6. I am rather new to this. Whenever an empty MySQL date field (not really empty but 000-00-00) is displayed in db-aware controls (dbgrid and dbedit), it is displayed as '12/30/1899'. Is there way to make the controls display and empty/blank field instead of 12/30/1899 ?
  2. bowens44

    Error with 'LOAD DATA LOCAL INFILE'

    Oops. Thought I included that ...... Warning | 1261 | Row 4225 doesn't contain data for all columns Warning | 1261 | Row 4226 doesn't contain data for all columns Warning | 1261 | Row 4227 doesn't contain data for all columns Warning | 1261 | Row 4228 doesn't contain data for all columns...
  3. bowens44

    Error with 'LOAD DATA LOCAL INFILE'

    forgot to include table structure: CREATE TABLE tablename ( ticket_number varchar(20), title varchar(250), incident_type varchar(5), date_occurred date, date_resolved date, keyword varchar(50), sub_component varchar(40), priority varchar(1), c1_customer varchar(100), reporter_name varchar(50)...
  4. bowens44

    Error with 'LOAD DATA LOCAL INFILE'

    I get an error when importing a csv file. Query OK, 16394 rows affected, 176 warnings (0.27 sec) Records: 16394 Deleted: 0 Skipped: 0 Warnings: 176 LOAD DATA LOCAL INFILE '/path/janfeb2008.csv' into table tablename fields terminated by ',' lines terminated by '\r\n' ( ticket_number, title...
  5. bowens44

    Invalid property value

    I'm writing an application in Delphi 6. Last time I saved the project everything was working, now when loading I get an error. When loading form1.pas I get 'Invalid property value'. How can I determine what is causing this? I am rather new to this so please keep that in mind when answering...
  6. bowens44

    read/display results of query - Mysql

    I am beginning to suspect that is were my problem lies. I'm not using ODBC, I am using a freeware query component in conjunction with libmysql.dll. I have been hoping to accomplish this with out OBDC or BDE. As long as I don't use calculated fields on the mysql side, everything is great.
  7. bowens44

    read/display results of query - Mysql

    Hi Andrew, Actually , I was executing the query before hitting the button to update the form caption. I was doing it in another button. It seems to execute alright, I have a datasource and datagrid attached to the query, I see the field 'priority' listed in the grid. the datagrid looks like...
  8. bowens44

    read/display results of query - Mysql

    this is the code that I am using to build the query datamodule2.mysqldataset2.active:=false; datamodule2.mysqldataset2.sql.clear; datamodule2.mysqldataset2.sql.add('select '); datamodule2.mysqldataset2.SQL.add('priority,avg(datediff(date_resolved,date_occurred)) as AverageDays ')...
  9. bowens44

    read/display results of query - Mysql

    Hi Leslie, Thanks for your response. I'm still having a problem accessing this data. The query executes as it shouold but when I attempt to access the field 'AverageDays' , I am told field does not exist. Does the field have to exist in the table in the database?
  10. bowens44

    read/display results of query - Mysql

    I am execute the following query: select priority,(avg(datediff(dateresolve,dateoccurred)) from table group by priority. if I execute this in mysql I get: +----------+--------------------------------------------+ | priority | avg(datediff(date_resolved,date_occurred)) |...

Part and Inventory Search

Back
Top