Search found 6 matches
- 06.12.2017, 18:25
- Forum: Off Topic
- Topic: About network access to DB
- Replies: 2
- Views: 25424
- 04.12.2017, 22:17
- Forum: Off Topic
- Topic: About network access to DB
- Replies: 2
- Views: 25424
About network access to DB
Hello: I want to ask a question maybe absurd about a simple issue of network access to a database. It is about not accessing a database through a server, but to access a database file through the network, through a shared folder. The problem is that if you access the same database in the same PC, ev...
- 23.11.2017, 19:45
- Forum: SQLite
- Topic: SELECT UNION truncate string fields at 510 character
- Replies: 4
- Views: 4798
Re: SELECT UNION truncate string fields at 510 character
Yes, I instaled the last 7.2 and the error disappear. But now, I need to change all .Open with .ExecSQL because an error occurs jaja. But this new version doesn´t truncate the strings.
Thanks for all
Thanks for all
- 18.11.2017, 18:42
- Forum: SQLite
- Topic: SELECT UNION truncate string fields at 510 character
- Replies: 4
- Views: 4798
Re: SELECT UNION truncate string fields at 510 character
Yes, I have a piece of sql and code, but now I'm noy at home.
But, the truncated field are Memo, not Varchar.
I just download 7.2 and I'll try. Later I'll send the code and sql too.
Thanks
But, the truncated field are Memo, not Varchar.
I just download 7.2 and I'll try. Later I'll send the code and sql too.
Thanks
- 16.11.2017, 21:41
- Forum: SQLite
- Topic: SELECT UNION truncate string fields at 510 character
- Replies: 4
- Views: 4798
SELECT UNION truncate string fields at 510 character
Hello: I have a SQLite database with 6 tables. When I use an SQL command with 6 SELECT and UNION, if the result responds only to one table, everything is correct, but if the result involves more than one table, the text fields are truncated to 510 characters. Uso Delphi 2006, sqlite3 y ZeosLib 7.1.1...
- 16.11.2017, 13:36
- Forum: SQLite
- Topic: SELECT with UNION return String Field truncated at 510 size
- Replies: 0
- Views: 2775
SELECT with UNION return String Field truncated at 510 size
"SELECT with UNION return String Field truncated at 510 size" I have this error from long time and I couldn´t found a solution. I use 6 tables and I want to search with SELECT using UNION. All warks ok if the result data comes from only one table (it means, the 6 selects only return data f...