Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting dBase fieldtypes logical and memo

Status
Not open for further replies.
BOH2007

BOH2007

Programmer
Sep 27, 2007
6
DE
Once more Hi@all,

I have to convert dBase tables into Pervasive tables and don't know how to convert the fieldtypes "logical" and "memo".

On runnnig my queries, I'm getting error messages on these types. What to do? Any ideas?

Thanks
 
Sort by date Sort by votes
I'm not sure what those data types are in dBase but a Logical in PSQL is mapped as a Bit data type. A memo is probably a LongVarChar.
All of the Data Types are described in Appendix A (in the PSQL 2000i version) of the SQL Engine Reference.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

profoundhypnotic
  • Locked
  • Question
how to select min and max value and the date for each
Replies
1
Views
257
mirtheil
mirtheil
DrB0b
  • Locked
  • Question
ERP uses PSQL DB and functions slowly via VPN
Replies
5
Views
308
DrB0b
DrB0b
David Ford
  • Locked
  • Question
[pervasive][odbc client interface] Numeric value out of range. (#0) - MS Access and Sage 50
Replies
2
Views
153
David Ford
David Ford
Sladybug
  • Locked
  • Question
Pervasive SQL - Updating database date fields via ODBC with null and '' values
Replies
0
Views
105
Sladybug
Sladybug
doc1000101
  • Locked
  • Question
Creating view and changing data type
Replies
1
Views
157
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top