Recent

Author Topic: spaces in DBEdit box  (Read 1023 times)

mobilevil

  • Jr. Member
  • **
  • Posts: 55
    • http://www.kachun.com
spaces in DBEdit box
« on: June 18, 2018, 12:18:12 pm »
Hello,
is there any to trim the space automatically for db text fields in the client side, or set it up as default in server side? I searched around but found no result.

how the DBEdit or DBMemo boxes has excessive spaces on them even if I tried to delete them in data.

for a DBLookupCombo box, I added TRIM() in SQL command but doing it for all the fields would be quite a problem.

I am using Firebird 3 and Lazarus 1.8.4 on Windows 10 64 bit.

Thanks.

mobilevil

  • Jr. Member
  • **
  • Posts: 55
    • http://www.kachun.com
Re: spaces in DBEdit box
« Reply #1 on: June 20, 2018, 07:31:15 am »
Sorry I found it. I should use VARCHAR instead of CHAR on server side.