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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL error
Anyone ever seen this error before ? becasue i cant find anything about it. Except: com.borland.dx.dataset.DataSetException: [interclient][interbase] conversion error from string "TN 256" See com.borland.dx.dataset.DataSetException error code: BASE+66...- Gandi
- Thread
- Replies: 2
- Forum: Embarcadero: InterBase
-
elo =) I have a table with a TIM
yeah i have tryed that, but it doesn't work. Becasue i cant use CURRENT_DATE, i can only use CURRENT_TIMESTAMP (here i get both date and time), so when i do the -14 it takes it from the time or something, becasue it dont work. And if i try to use CURRENT_DATE it pops up the error: SQL error...- Gandi
- Post #3
- Forum: Embarcadero: InterBase
-
elo =) I have a table with a TIM
elo =) I have a table with a TIMESTAMP in it, where i like a PROCEDURE to do a check though the table, if any of the record is older then 2weeks (14days) they shall be deleted. I have tryed something, where i use SELECT EXTRACT YEARDAY, as i saw days was easy to work with, after that i cant get...- Gandi
- Thread
- Replies: 3
- Forum: Embarcadero: InterBase
