Re: [SQL] delphi access question

2005-03-30 Thread Lin Kun Hsin
hello I can run your sql statement in PgAdmin,too. so your statement should be OK! Can you post more example about add to result, let us have idea about your question. I think you can try to set char(1) to char(2), try it will useful.. -- http://alumni.cyut.edu.tw Open WebMail Project (http:/

Re: [SQL] delphi access question?

2005-03-30 Thread Joel Fradkin
Yea odd thing is if I use a table type object it see the fields so it is only with query objects. The same odbc works ok with my asp pages. I will see if I can figure out the zeos stuff. Something is not translating CHAR values correctly -- all the fields that you "see" are not char values. Hav

Re: [SQL] delphi access question?

2005-03-30 Thread Gregory S. Williamson
Something is not translating CHAR values correctly -- all the fields that you "see" are not char values. Have no idea off hand *why* this would be ... character encoding differences maybe ? Greg Williamson DBA GlobeXplorer LLC -Original Message- From: Joel Fradkin [mailto:[EMAIL PRO