dbTalk Databases Forums  

Table select problem

comp.databases.paradox comp.databases.paradox


Discuss Table select problem in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
EdgarK
 
Posts: n/a

Default Table select problem - 07-06-2006 , 11:27 AM







Hi there
I've got a paradox db, version 5.0, using product winware(you probably know
it) i^m trying, using dotnet, to access some tables via odbc what worked
fine, for a few days at least. My very simple statement is "SELECT * FROM
TEXT" where text is stupid name for a table. now this returns me an "syntax
error in FROM clausel" with i thing is, cause the TEXT-word, BUT if it put
in in brackets[] (SELECT * FROM [TEXT]) it returns "invalid argument" exeption.
Can someone plz help me?

Greez & thx

Reply With Quote
  #2  
Old   
EdgarK
 
Posts: n/a

Default Re: Table select problem - 07-06-2006 , 12:27 PM







I found out, that i can get text, just up to 2046 signs. is there an odbc
limit?can i change this "buffer size"? i already installed the newest jet
enginge.

merci & bye

Reply With Quote
  #3  
Old   
Larry DiGiovanni
 
Posts: n/a

Default Re: Table select problem - 07-06-2006 , 04:48 PM



SELECT * FROM "text.db"

Maybe.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.



Reply With Quote
  #4  
Old   
EdgarK
 
Posts: n/a

Default Re: Table select problem - 07-07-2006 , 11:19 AM




thx, but its definitly a 2046 char limit, if all text are less than 2046 signs
it works perfecly. can someone tell me a workaround?

thx!

Reply With Quote
  #5  
Old   
Tony McGuire
 
Posts: n/a

Default Re: Table select problem - 07-07-2006 , 11:36 AM




Basically, a 2k limit?

Does MS driver support memo fields?

Perhaps you can ask about increased buffer size of the folks that make your
'winware' product?


---------------------------------------------------------
Tony McGuire



Reply With Quote
  #6  
Old   
EdgarK
 
Posts: n/a

Default Re: Table select problem - 07-07-2006 , 11:42 AM




Hiho,

jup, ms driver supports it, but not enouth i think i think the buffer size
i something dbe specific, thats why i ask you here another problem it that
this winware product is applied by a foreign companie that doesn't give support
any more:/ an upgrade is impossible...

thx maaaans and have a nice day


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.