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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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 ?- bowens44
- Thread
- Replies: 2
- Forum: Embarcadero: Delphi
-
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... -
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...- bowens44
- Thread
- Replies: 3
- Forum: Embarcadero: Delphi
-
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)) |...- bowens44
- Thread
- Replies: 9
- Forum: Embarcadero: Delphi
