Hi There,

I have created DDFs for a pervasive sql 9 database using the DDF
builder provided by Pervasive. I have managed to get the DDFs to
indicate the fields properly for most of the tables. However, I cannot
manage to view the memo fields that are in few of the tables. Do the
memo fields get stored separate from the raw data files? And if they do
how do i create DDFs for these fields?

TIA
MD

meghdutt (AT) gmail (DOT) com wrote:

Most applications store "memo" fields as the old NOTE data type. You
cannot directly create a SQL statement for this data type in PSQLv9.
As such, you may need to create the table first, then go back into the
table designer and change the field type at the Btrieve level.

I know this is possible in PSQLV8 and PSQL2000i. I don't have the UI
for the newer DDF Builder memorized enough to tell you exactly where to
go to change this, but it should be easy enough to find...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Sydney: Pervasive.SQL Service & Support Class - 02/27/06 ***
*** Chicago: Pervasive.SQL Service & Support Class - 03/27/06 ***

Bill,

I can create the Memo field as the last field of my table. i.e.
after I am done with creating DDFs for all the fields in that table
(after skipping the field that is a memo field) , I can then create an
additional last field in that table as the memo field.
And yes the data type gets jumbled up in PCC even if you specify
the datatype as 'Note'.

MD

As an afterthought, how do I access this notes field using odbc
connection in PHP. Although it doesn't throw me an error, It doesn't
return any value either. Is there a way by which I can access these
fields without having to jump back to Pervasive 2000i or something.

Thanks.
MD