Having trouble querying Peachtree or Sage 50 via ODBC? Try this !
select
xf$Name as tablename,
xe$Name as fieldname,
xf$id as tableid,
xe$id as fieldid,
xe$datatype as datatype,
xe$size as size
from
x$File f
inner join x$Field e on e.xe$file = f.xf$id
where
tableid in (11,22,33,34,46,38,46,51,52,55,56,58,72,96)
order by
tableid asc,
fieldname asc
Just a few SQL scripts to help work with Peachtree / Sage 50 databases. ERP / LOL.