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!
-
Congratulations Mike Lewis 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
No ideas...?! :-(- BOH2007
- Post #2
- Forum: Pervasive: Pervasive.SQL
-
Create Index on Upper( Fieldname )...?!
That's absolutly right, but no option at this moment :-(- BOH2007
- Post #6
- Forum: Pervasive: Pervasive.SQL
-
Converting dBase fieldtypes logical and memo
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- BOH2007
- Thread
- Replies: 2
- Forum: Pervasive: Pervasive.SQL
-
Create Index on Upper( Fieldname )...?!
I've got it, just reading the manual... ;-)- BOH2007
- Post #4
- Forum: Pervasive: Pervasive.SQL
-
Create Index on Upper( Fieldname )...?!
Good question... ;-) I'm trying to convert dBase files from an advantage database server to pervasive. Building the table structures with sql queries getting from an advantage tool. These old dbase files have indexes as I described above, on upper( fieldname )... You think, if I change the...- BOH2007
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
Create Index on Upper( Fieldname )...?!
Hi@all, isn't it possible to create an index with using the function upper()...?! Like this: Create Index Indexname on Tablename( Upper( Fieldname ) ); I'm using Pervasive.SQL 2000i Service Pack 4 Kind regards BOH- BOH2007
- Thread
- Replies: 5
- Forum: Pervasive: Pervasive.SQL
