Posts by Edu Mendonça • 2,564 points

• 1

  votes

  1

  answer

  1810

  views

  A: How to convert dates into varchar to date in SQL `Firebird`?

  Put it like this select * from TAB_FATURAMENTO where cd_cliente like '%' and dt_item between **"15/05/2017"** and **"31/05/2017"** with Double Quotes that goes I do so.

  sql firebird date varchar

  answered 7 years, 4 months ago Edu Mendonça 2,564

• 1

  votes

  2

  answers

  202

  views

  Q: SQL query with duplicate items

  I have this situation and do not know why it happens. When I pass this SQL command the displayed items comes duplicated. What should I do to appear one item each without putting the DISTICT SELECT…

  sql firebird

  asked 7 years, 4 months ago Edu Mendonça 2,564

• 1

  votes

  2

  answers

  692

  views

  Q: How to disable Autocommit in Firedac

  How would it be to disable Autocommit type: FDTable1.AutoCommit := False; or FDconection.AutoCommit := False; I don’t think so.

  delphi firedac

  asked 7 years, 4 months ago Edu Mendonça 2,564