Search found 6 matches

by OsquiVilla
06.12.2017, 18:25
Forum: Off Topic
Topic: About network access to DB
Replies: 2
Views: 25312

Re: About network access to DB

Thanks
by OsquiVilla
04.12.2017, 22:17
Forum: Off Topic
Topic: About network access to DB
Replies: 2
Views: 25312

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...
by OsquiVilla
23.11.2017, 19:45
Forum: SQLite
Topic: SELECT UNION truncate string fields at 510 character
Replies: 4
Views: 4750

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
by OsquiVilla
18.11.2017, 18:42
Forum: SQLite
Topic: SELECT UNION truncate string fields at 510 character
Replies: 4
Views: 4750

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
by OsquiVilla
16.11.2017, 21:41
Forum: SQLite
Topic: SELECT UNION truncate string fields at 510 character
Replies: 4
Views: 4750

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...
by OsquiVilla
16.11.2017, 13:36
Forum: SQLite
Topic: SELECT with UNION return String Field truncated at 510 size
Replies: 0
Views: 2742

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...