Table select problem - 07-06-2006 , 11:27 AM
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
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
merci & bye
Re: Table select problem - 07-06-2006 , 04:48 PM
SELECT * FROM "text.db"
IT Consulting and Staffing Solutions
Check out www.thedbcommunity.com for Paradox resources.
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
Re: Table select problem - 07-07-2006 , 11:42 AM
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